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 }}
usefulalgorithm
sqlglot
Repository navigation
Code
Pull requests
Actions
Projects
Security and quality
Insights
More
items
Commits
Breadcrumbs
History for
sqlglot
sqlglot
optimizer
simplify.py
on
main
User selector
All users
Datepicker
All time
Commit history
Commits on Aug 23, 2024
fix!: 0 is falsey
tobymao
committed
0a9ba05
View commit details
Copy full SHA for 0a9ba05
View code at this point
Browse repository at this point
Commits on Jun 28, 2024
fix!: simplify no longer removes neg, add to_py (#3714)
tobymao
authored
ae1816f
View commit details
Copy full SHA for ae1816f
View code at this point
Browse repository at this point
Commits on Jun 7, 2024
fix(optimizer): don't use datetrunc type for right side (#3614)
Show description for 0e1a1fb
barakalon
authored
0e1a1fb
View commit details
Copy full SHA for 0e1a1fb
View code at this point
Browse repository at this point
Commits on Jun 5, 2024
fix: optimize absorb_and_eliminate and remove_complements (#3595)
barakalon
authored
061be9b
View commit details
Copy full SHA for 061be9b
View code at this point
Browse repository at this point
Commits on Apr 30, 2024
fix(optimizer): Remove XOR from connector simplifications (#3380)
Show description for b2a7e55
VaggelisD
authored
b2a7e55
View commit details
Copy full SHA for b2a7e55
View code at this point
Browse repository at this point
Commits on Apr 15, 2024
fix(optimizer)!: Preserve DPipe in simplify_concat (#3317)
Show description for 290e408
VaggelisD
and
georgesittas
authored
290e408
View commit details
Copy full SHA for 290e408
View code at this point
Browse repository at this point
Commits on Apr 12, 2024
Fix(optimizer): don't simplify parentheses when parent is SubqueryPredicate (#3315)
georgesittas
authored
ef84f17
View commit details
Copy full SHA for ef84f17
View code at this point
Browse repository at this point
Commits on Apr 4, 2024
Fix(optimizer): preserve the original type when creating a date literal (#3273)
georgesittas
authored
19302ab
View commit details
Copy full SHA for 19302ab
View code at this point
Browse repository at this point
Commits on Apr 3, 2024
fix(optimizer): tweaks to date simplification (#3270)
Show description for bc26e84
barakalon
authored
bc26e84
View commit details
Copy full SHA for bc26e84
View code at this point
Browse repository at this point
Commits on Mar 29, 2024
feat(optimizer): Support for small integer CAST elimination (#3234)
Show description for 8dba8e2
VaggelisD
authored
8dba8e2
View commit details
Copy full SHA for 8dba8e2
View code at this point
Browse repository at this point
Commits on Mar 19, 2024
fix: can't expand group by for nulls and bools
tobymao
committed
df4ce17
View commit details
Copy full SHA for df4ce17
View code at this point
Browse repository at this point
fix: can't simplify null parens
tobymao
committed
a0df28f
View commit details
Copy full SHA for a0df28f
View code at this point
Browse repository at this point
chore: actually pop the where statement
tobymao
committed
eb0a6c3
View commit details
Copy full SHA for eb0a6c3
View code at this point
Browse repository at this point
Commits on Mar 16, 2024
feat!!: make transform non recursive and cleanup walk() to only yield… (#3141)
Show description for 8f09dce
tobymao
authored
8f09dce
View commit details
Copy full SHA for 8f09dce
View code at this point
Browse repository at this point
Commits on Mar 14, 2024
fix: optimizer bugs
tobymao
committed
230a845
View commit details
Copy full SHA for 230a845
View code at this point
Browse repository at this point
Commits on Feb 29, 2024
Fix: ensure UDF identifier quotes are preserved (#3057)
Show description for 6a9501f
georgesittas
authored
6a9501f
View commit details
Copy full SHA for 6a9501f
View code at this point
Browse repository at this point
Commits on Feb 15, 2024
Refactor: clean up tech debt in dialect implementations (#2977)
Show description for 5a34f3d
georgesittas
authored
5a34f3d
View commit details
Copy full SHA for 5a34f3d
View code at this point
Browse repository at this point
Commits on Feb 5, 2024
fix(optimizer): don't remove NOT parenthesis (#2917)
barakalon
authored
15fdff2
View commit details
Copy full SHA for 15fdff2
View code at this point
Browse repository at this point
Commits on Feb 3, 2024
chore: switch to ruff (#2912)
tobymao
authored
f9fdf7b
View commit details
Copy full SHA for f9fdf7b
View code at this point
Browse repository at this point
Commits on Jan 26, 2024
chore: upgrade black
tobymao
committed
9eac93e
View commit details
Copy full SHA for 9eac93e
View code at this point
Browse repository at this point
Commits on Jan 3, 2024
Fix!: improve transpilation of JSON value extraction (#2744)
Show description for 0b6bdc4
georgesittas
authored
0b6bdc4
View commit details
Copy full SHA for 0b6bdc4
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 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
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 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
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 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 9, 2023
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 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
Previous
Next
You can’t perform that action at this time.