Skip to content
Navigation Menu
Sign in
Products
Platform
GitHub
Repository hosting, code review, and collaboration
Copilot
AI coding agent for tasks, projects, and automated work
Build & Ship
Actions
CI/CD and automation
Code Quality
Quality analysis, fixes, and enforcement
Codespaces
Cloud development environments
Secure
Code Security
Vulnerability detection and remediation
Secret Protection
Secret scanning and leak prevention
All Features
Developers
Learn
Documentation
Training
Certifications
Build
Build with Copilot
Customize Copilot
Integrations
Explore
Trending repos
GitHub Sponsors
Developer articles
Changelog
Changelog
Your source for the latest features, improvements, and fixes across GitHub products, all in one place.
Businesses
By Stage
Enterprises
Team
Startups
Nonprofits
By Industry
Healthcare
Financial services
Manufacturing
Government
See all industries
Evaluate GitHub
Why GitHub
Customer Stories
Business insights
Trust Center
Add-ons
GitHub Advanced Security
Enterprise-grade code security
Copilot for business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Resources
Learn & Connect
Documentation
Resource center
Blog
Events & webinars
Community Forum
Customer Stories
Integrations
Support
Customer support
Training
GitHub Status
Company
About
Partners
Changelog
GitHub Universe
GitHub Universe
The event for developers, by developers — talks, workshops, and what’s next for GitHub.
Pricing
Search
/
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
AdalbertMemSQL
sqlglot
Repository navigation
Code
Pull requests
1
(1)
Actions
Projects
Security and quality
Insights
More
items
Commits
Breadcrumbs
History for
sqlglot
sqlglot
optimizer
on
main
User selector
All users
Datepicker
All time
Commit history
Commits on Apr 11, 2025
Feat!: ensure JSON_FORMAT type is JSON when targeting Presto (#4968)
georgesittas
authored
400ea54
View commit details
Copy full SHA for 400ea54
View code at this point
Browse repository at this point
Commits on Apr 10, 2025
feat(duckdb)!: Add support for PIVOT multiple IN clauses (#4964)
Show description for 72cf4a4
VaggelisD
authored
72cf4a4
View commit details
Copy full SHA for 72cf4a4
View code at this point
Browse repository at this point
Commits on Apr 8, 2025
feat(bigquery): Add support for side & kind on set operators (#4959)
Show description for b011ee2
VaggelisD
authored
b011ee2
View commit details
Copy full SHA for b011ee2
View code at this point
Browse repository at this point
fix(clickhouse)!: Fix generation of exp.Values (#4930)
Show description for 44b955b
VaggelisD
authored
44b955b
View commit details
Copy full SHA for 44b955b
View code at this point
Browse repository at this point
Commits on Apr 2, 2025
fix(optimizer): Merge subqueries when inner query has name conflict with outer query (#4931)
barakalon
authored
7042603
View commit details
Copy full SHA for 7042603
View code at this point
Browse repository at this point
Commits on Mar 26, 2025
Fix(optimizer): avoid merging window function nested under a projection (#4919)
georgesittas
authored
ff6be71
View commit details
Copy full SHA for ff6be71
View code at this point
Browse repository at this point
Commits on Mar 25, 2025
Fix(optimizer)!: disable lateral alias expansion for Oracle fixes #4910
georgesittas
committed
71c529a
View commit details
Copy full SHA for 71c529a
View code at this point
Browse repository at this point
Commits on Mar 21, 2025
Feat: add a check and error message for set operations in pushdown_projections (#4897)
Show description for 0de4503
3 people
authored
0de4503
View commit details
Copy full SHA for 0de4503
View code at this point
Browse repository at this point
Commits on Mar 18, 2025
Fix(optimizer): handle TableFromRows properly in annotate_types (#4889)
georgesittas
authored
d7b3b3e
View commit details
Copy full SHA for d7b3b3e
View code at this point
Browse repository at this point
Commits on Mar 14, 2025
fix!: do not expand having expressions if they conflict with a projection (#4881)
tobymao
authored
ac3d311
View commit details
Copy full SHA for ac3d311
View code at this point
Browse repository at this point
Commits on Mar 12, 2025
Fix(redshift)!: turn off multi-arg coalesce simplification (#4877)
georgesittas
committed
87c94fe
View commit details
Copy full SHA for 87c94fe
View code at this point
Browse repository at this point
Commits on Feb 27, 2025
Chore(optimizer): refactor DISTINCT ON qualification to better match ORDER BY (#4811)
georgesittas
authored
e34f3bc
View commit details
Copy full SHA for e34f3bc
View code at this point
Browse repository at this point
Fix(optimizer)!: expand DISTINCT ON expressions like we do for GROUP/ORDER by (#4807)
georgesittas
authored
eae860c
View commit details
Copy full SHA for eae860c
View code at this point
Browse repository at this point
Commits on Feb 24, 2025
Fix(optimizer)!: do not coerce parameterized types (#4796)
georgesittas
authored
00c7f05
View commit details
Copy full SHA for 00c7f05
View code at this point
Browse repository at this point
Commits on Feb 23, 2025
Fix(optimizer)!: column qualify not applying in an order by inside within group when it also the alias (#4780)
Show description for dc69192
ran-lakeway
and
georgesittas
committed
dc69192
View commit details
Copy full SHA for dc69192
View code at this point
Browse repository at this point
Commits on Feb 19, 2025
Fix(optimizer): do not qualify ctes that are pivoted (#4775)
georgesittas
authored
ccdb92a
View commit details
Copy full SHA for ccdb92a
View code at this point
Browse repository at this point
Commits on Jan 21, 2025
fix: qualify using (#4646)
tobymao
authored
761e835
View commit details
Copy full SHA for 761e835
View code at this point
Browse repository at this point
fix(optimizer)!: Do not remove parens on bracketed expressions (#4645)
VaggelisD
authored
94af80b
View commit details
Copy full SHA for 94af80b
View code at this point
Browse repository at this point
Commits on Jan 16, 2025
feat(optimizer): Fix qualify for SEMI/ANTI joins (#4622)
Show description for f7628ad
VaggelisD
authored
f7628ad
View commit details
Copy full SHA for f7628ad
View code at this point
Browse repository at this point
Fix(optimizer)!: treat LEVEL column in CONNECT BY queries as an identifier (#4627)
Show description for 59d886d
georgesittas
authored
59d886d
View commit details
Copy full SHA for 59d886d
View code at this point
Browse repository at this point
Commits on Jan 13, 2025
fix(optimizer): unions on nested subqueries (#4603)
barakalon
authored
2bea466
View commit details
Copy full SHA for 2bea466
View code at this point
Browse repository at this point
Commits on Dec 19, 2024
fix!: normalize before qualifying tables (#4539)
Show description for 07d05da
tobymao
authored
07d05da
View commit details
Copy full SHA for 07d05da
View code at this point
Browse repository at this point
Commits on Dec 18, 2024
Feat: include comments in gen (#4535)
georgesittas
authored
52c8374
View commit details
Copy full SHA for 52c8374
View code at this point
Browse repository at this point
Commits on Dec 16, 2024
Fix(optimizer): qualify snowflake queries with `level` pseudocolumn (#4524)
georgesittas
authored
946cd42
View commit details
Copy full SHA for 946cd42
View code at this point
Browse repository at this point
Commits on Dec 12, 2024
fix(snowflake): Allow alias expansion inside JOIN statements (#4504)
Show description for 2b68b9b
florian-ernst-alan
and
georgesittas
authored
2b68b9b
View commit details
Copy full SHA for 2b68b9b
View code at this point
Browse repository at this point
Fix(optimizer): only expand stars for select scopes (#4515)
georgesittas
authored
7649d50
View commit details
Copy full SHA for 7649d50
View code at this point
Browse repository at this point
Commits on Dec 5, 2024
feat(optimizer)!: Alias expanded USING STRUCT fields (#4474)
Show description for 41c6d24
VaggelisD
authored
41c6d24
View commit details
Copy full SHA for 41c6d24
View code at this point
Browse repository at this point
Commits on Nov 22, 2024
Fix(optimizer)!: fix datetime coercion in the canonicalize rule (#4431)
Show description for fe35394
georgesittas
authored
fe35394
View commit details
Copy full SHA for fe35394
View code at this point
Browse repository at this point
fix: add return type (#4440)
etonlels
authored
41d6a13
View commit details
Copy full SHA for 41d6a13
View code at this point
Browse repository at this point
Commits on Oct 23, 2024
fix(optimizer)!: Fix chained exp.SetOperation type annotation (#4274)
Show description for 1691388
VaggelisD
and
georgesittas
authored
1691388
View commit details
Copy full SHA for 1691388
View code at this point
Browse repository at this point
Commits on Oct 21, 2024
fix(optimizer)!: Add type hints for optimizer rules eliminate & merge subqueries (#4267)
Show description for 222152e
VaggelisD
authored
222152e
View commit details
Copy full SHA for 222152e
View code at this point
Browse repository at this point
Commits on Oct 18, 2024
fix(optimizer): Fix merge_subqueries.py::rename_inner_sources() (#4266)
Show description for 4543fb3
VaggelisD
authored
4543fb3
View commit details
Copy full SHA for 4543fb3
View code at this point
Browse repository at this point
Commits on Oct 17, 2024
Fix(clickhouse): traverse_scope with FINAL modifier (#4263)
Show description for 8f49ad8
pkit
authored
8f49ad8
View commit details
Copy full SHA for 8f49ad8
View code at this point
Browse repository at this point
Commits on Oct 15, 2024
Feat: support non-strict qualify_columns (#4243)
Show description for 6f32e53
hsheth2
authored
6f32e53
View commit details
Copy full SHA for 6f32e53
View code at this point
Browse repository at this point
fix(bigquery): Early expand only aliased names in GROUP BY (#4246)
Show description for fcc05c9
VaggelisD
authored
fcc05c9
View commit details
Copy full SHA for fcc05c9
View code at this point
Browse repository at this point
Previous
Next
You can’t perform that action at this time.