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 }}
edson-github
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 Dec 28, 2023
Add option to pushdown CTE aliases earlier in qualify (#2726)
Show description for 4629410
dangoldin
authored
4629410
View commit details
Copy full SHA for 4629410
View code at this point
Browse repository at this point
Commits on Dec 26, 2023
refactor!: normalize units to all be upper case (#2714)
tobymao
authored
a4e899a
View commit details
Copy full SHA for a4e899a
View code at this point
Browse repository at this point
Commits on Dec 25, 2023
fix: predicate pushdown closes #2721
tobymao
committed
4fd6c90
View commit details
Copy full SHA for 4fd6c90
View code at this point
Browse repository at this point
Commits on Dec 20, 2023
feat(optimizer): simplify date comparisons (#2710)
barakalon
authored
5624fdb
View commit details
Copy full SHA for 5624fdb
View code at this point
Browse repository at this point
Commits on Dec 19, 2023
fix: avoid extra traverse in simplify
tobymao
committed
5b281e9
View commit details
Copy full SHA for 5b281e9
View code at this point
Browse repository at this point
Commits on Dec 16, 2023
fix(optimizer): CTE aliases overridden in FROM (#2692)
Show description for 77766ef
barakalon
authored
77766ef
View commit details
Copy full SHA for 77766ef
View code at this point
Browse repository at this point
feat: more aggressive date sorting (#2690)
tobymao
authored
feff124
View commit details
Copy full SHA for feff124
View code at this point
Browse repository at this point
Commits on Dec 15, 2023
fix: add dialect to truncation simplification (#2689)
tobymao
authored
a4466ef
View commit details
Copy full SHA for a4466ef
View code at this point
Browse repository at this point
fix!: sort comparisons (#2686)
tobymao
authored
083d374
View commit details
Copy full SHA for 083d374
View code at this point
Browse repository at this point
fix: simplify not between closes #2682
tobymao
committed
3610176
View commit details
Copy full SHA for 3610176
View code at this point
Browse repository at this point
Commits on Dec 14, 2023
fix: ignore unnesting non subqueries closes #2676
tobymao
committed
7188431
View commit details
Copy full SHA for 7188431
View code at this point
Browse repository at this point
Commits on Dec 13, 2023
fix(optimizer): eliminate eliminate_unions (#2663)
barakalon
authored
bf6d3e4
View commit details
Copy full SHA for bf6d3e4
View code at this point
Browse repository at this point
Commits on Dec 12, 2023
Fix(optimizer): handle case where top-level query is a Subquery in scope (#2661)
Show description for 8860521
georgesittas
authored
8860521
View commit details
Copy full SHA for 8860521
View code at this point
Browse repository at this point
Commits on Dec 7, 2023
Fix!: make generation of CONCAT less verbose (#2639)
Show description for 96f9b0e
georgesittas
authored
96f9b0e
View commit details
Copy full SHA for 96f9b0e
View code at this point
Browse repository at this point
Commits on Dec 6, 2023
Fix(optimizer): simplify Sub/Div more conservatively, they're not associative (#2635)
Show description for 78697b4
georgesittas
authored
78697b4
View commit details
Copy full SHA for 78697b4
View code at this point
Browse repository at this point
Feat!: introduce Dialect settings, make MySQL case-sensitive by default (#2627)
Show description for be89da3
georgesittas
authored
be89da3
View commit details
Copy full SHA for be89da3
View code at this point
Browse repository at this point
Commits on Dec 5, 2023
refactor!: remove safe versions and use a flag instead (#2629)
tobymao
authored
6e71c34
View commit details
Copy full SHA for 6e71c34
View code at this point
Browse repository at this point
Commits on Nov 28, 2023
fix!: expand positional args in order by as aliases (#2599)
Show description for c413b7f
tobymao
authored
c413b7f
View commit details
Copy full SHA for c413b7f
View code at this point
Browse repository at this point
Commits on Nov 22, 2023
Fix(optimizer): respect EXCEPT when expanding star for PIVOTs (#2589)
georgesittas
authored
f53f656
View commit details
Copy full SHA for f53f656
View code at this point
Browse repository at this point
Commits on Nov 19, 2023
Fix!(optimizer): annotate text + numeric using the numeric type (#2578)
Show description for 87377f1
georgesittas
authored
87377f1
View commit details
Copy full SHA for 87377f1
View code at this point
Browse repository at this point
Commits on Nov 16, 2023
Fix: interval simplification with non literal
tobymao
committed
932b610
View commit details
Copy full SHA for 932b610
View code at this point
Browse repository at this point
Commits on Nov 13, 2023
fix(optimizer): dont cast right side of IS (#2559)
Show description for e5e6d92
barakalon
authored
e5e6d92
View commit details
Copy full SHA for e5e6d92
View code at this point
Browse repository at this point
Commits on Nov 10, 2023
Fix!(tsql): ensure derived table projections are named / have aliases (#2549)
Show description for 8d5ca56
georgesittas
authored
8d5ca56
View commit details
Copy full SHA for 8d5ca56
View code at this point
Browse repository at this point
Commits on Nov 9, 2023
feat: more robust boolean conversions for tsql (#2543)
tobymao
authored
73746ed
View commit details
Copy full SHA for 73746ed
View code at this point
Browse repository at this point
feat(optimizer): simplify DATE_ADD on literals (#2537)
Show description for ea41ddc
barakalon
authored
ea41ddc
View commit details
Copy full SHA for ea41ddc
View code at this point
Browse repository at this point
Commits on Nov 8, 2023
fix(optimizer): more support for date literals in simplify (#2525)
barakalon
authored
e2e11ae
View commit details
Copy full SHA for e2e11ae
View code at this point
Browse repository at this point
Commits on Nov 7, 2023
Feat(optimizer): annotate type of ABS (#2524)
georgesittas
authored
01d446b
View commit details
Copy full SHA for 01d446b
View code at this point
Browse repository at this point
Chore: use tuples instead of sets for inline collection instantiations (#2520)
georgesittas
authored
7ff5f25
View commit details
Copy full SHA for 7ff5f25
View code at this point
Browse repository at this point
Commits on Nov 6, 2023
fix!: typed div and safe div semantics (#2516)
barakalon
authored
3469e75
View commit details
Copy full SHA for 3469e75
View code at this point
Browse repository at this point
fix!: transpile division (#2513)
Show description for c6db124
barakalon
authored
c6db124
View commit details
Copy full SHA for c6db124
View code at this point
Browse repository at this point
Commits on Nov 4, 2023
Fix: struct conversion for non correlated queries
tobymao
committed
c7302cf
View commit details
Copy full SHA for c7302cf
View code at this point
Browse repository at this point
Commits on Nov 2, 2023
Chore: fix type hint for normalize_identifiers (#2505)
georgesittas
authored
c51d9ae
View commit details
Copy full SHA for c51d9ae
View code at this point
Browse repository at this point
Commits on Nov 1, 2023
Feat: use parse_identifiers in qualify tables (#2502)
tobymao
authored
b18235b
View commit details
Copy full SHA for b18235b
View code at this point
Browse repository at this point
Commits on Oct 31, 2023
feat(optimizer): more date function coercion (#2493)
Show description for 3d60f0e
barakalon
authored
3d60f0e
View commit details
Copy full SHA for 3d60f0e
View code at this point
Browse repository at this point
Fix(schema): use to_identifier as fallback when normalizing names (#2492)
georgesittas
authored
8e20328
View commit details
Copy full SHA for 8e20328
View code at this point
Browse repository at this point
Previous
Next
You can’t perform that action at this time.