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 }}
removecode
sqlglot
Repository navigation
Code
Pull requests
Actions
Projects
Security and quality
Insights
More
items
Commits
Breadcrumbs
History for
sqlglot
sqlglot
optimizer
pushdown_predicates.py
on
main
User selector
All users
Datepicker
All time
Commit history
Commits on Jul 20, 2026
fix(optimizer): don't push predicates into a subquery with QUALIFY
georgesittas
committed
655876f
View commit details
Copy full SHA for 655876f
View code at this point
Browse repository at this point
fix(optimizer)!: don't push predicates into a subquery with LIMIT/OFFSET [CLAUDE] (#7901)
Show description for ae702b1
chuenchen309
authored
ae702b1
View commit details
Copy full SHA for ae702b1
View code at this point
Browse repository at this point
Commits on May 7, 2026
Constrain `Sources` types in `pushdown_predicates` to respect `selected_sources`
georgesittas
committed
fb69e79
View commit details
Copy full SHA for fb69e79
View code at this point
Browse repository at this point
refactor: improve `optimizer::pushdown_predicates` typing (#7613)
Show description for 958b27d
OutSquareCapital
authored
958b27d
View commit details
Copy full SHA for 958b27d
View code at this point
Browse repository at this point
Commits on Apr 30, 2026
refactor(optimizer): continuation on typing coverage improvements (#7572)
Show description for b3fa159
OutSquareCapital
and
Copilot
authored
b3fa159
View commit details
Copy full SHA for b3fa159
View code at this point
Browse repository at this point
Commits on Apr 28, 2026
Refactor (Expr): improve `Expr.transform()` annotations (#7570)
Show description for a328694
3 people
authored
a328694
View commit details
Copy full SHA for a328694
View code at this point
Browse repository at this point
Commits on Mar 16, 2026
fix(optimizer): add forward-reference guard to pushdown_dnf, fixing cycle error (#7299)
Show description for 0eb5aae
2 people
authored and
georgesittas
committed
0eb5aae
View commit details
Copy full SHA for 0eb5aae
View code at this point
Browse repository at this point
Commits on Feb 27, 2026
Toby/compile expressions (#7164)
Show description for 8314a2d
tobymao
authored
8314a2d
View commit details
Copy full SHA for 8314a2d
View code at this point
Browse repository at this point
Commits on Feb 16, 2026
Chore: add some type hints (#7089)
georgesittas
authored
f927329
View commit details
Copy full SHA for f927329
View code at this point
Browse repository at this point
Commits on Nov 15, 2025
!! toby/arg_cleanup (#6330)
Show description for 1559e42
tobymao
authored
1559e42
View commit details
Copy full SHA for 1559e42
View code at this point
Browse repository at this point
Commits on Jun 30, 2025
Refactor(athena)!: route statements to hive/trino depending on their type (#5314)
georgesittas
authored
cfab31c
View commit details
Copy full SHA for cfab31c
View code at this point
Browse repository at this point
Commits on May 8, 2025
Move presto import inside of pushdown_predicates
georgesittas
committed
b310a68
View commit details
Copy full SHA for b310a68
View code at this point
Browse repository at this point
Commits on May 5, 2025
fix(optimizer): prevent incorrect predicate pushdown into RHS of CROSS JOIN UNNEST (#5033)
Show description for 89b7c8e
geooo109
authored
89b7c8e
View commit details
Copy full SHA for 89b7c8e
View code at this point
Browse repository at this point
Commits on Mar 11, 2024
Fix!: traverse union scopes iteratively (#3112)
Show description for ad4937b
georgesittas
authored
ad4937b
View commit details
Copy full SHA for ad4937b
View code at this point
Browse repository at this point
Commits on Jan 10, 2024
Fix(optimizer): pushdown predicates more conservatively to avoid DAG cycles (#2808)
Show description for 076e2c1
georgesittas
authored
076e2c1
View commit details
Copy full SHA for 076e2c1
View code at this point
Browse repository at this point
Commits on Dec 25, 2023
fix: predicate pushdown closes #2721
tobymao
committed
54891de
View commit details
Copy full SHA for 54891de
View code at this point
Browse repository at this point
Commits on Dec 15, 2023
fix: add dialect to truncation simplification (#2689)
tobymao
authored
bc27575
View commit details
Copy full SHA for bc27575
View code at this point
Browse repository at this point
Commits on Aug 15, 2023
fix: pushdown predicate to HAVING (#2064)
barakalon
authored
8719b01
View commit details
Copy full SHA for 8719b01
View code at this point
Browse repository at this point
Commits on Jul 9, 2023
Fix!(optimizer): preserve parenthesized joins, tables (#1900)
Show description for 8d74a35
georgesittas
authored
8d74a35
View commit details
Copy full SHA for 8d74a35
View code at this point
Browse repository at this point
Commits on Jun 15, 2023
Fix!: cyclic joins in the optimizer (#1786)
tobymao
authored
cb45f90
View commit details
Copy full SHA for cb45f90
View code at this point
Browse repository at this point
Commits on Jun 6, 2023
Chore(optimizer): fix pushdown_predicates comment example (#1732)
georgesittas
authored
d5bc1b4
View commit details
Copy full SHA for d5bc1b4
View code at this point
Browse repository at this point
Commits on May 25, 2023
Fix: allow optimizer to handle non unionables
tobymao
committed
dd95c41
View commit details
Copy full SHA for dd95c41
View code at this point
Browse repository at this point
Commits on Jan 2, 2023
right join pushdown fixes #873 (#875)
tobymao
authored
e8d71e4
View commit details
Copy full SHA for e8d71e4
View code at this point
Browse repository at this point
Commits on Dec 30, 2022
recursive cte scope fixes #856 (#860)
tobymao
authored
e3558cb
View commit details
Copy full SHA for e3558cb
View code at this point
Browse repository at this point
Commits on Nov 11, 2022
add null, true, false methods to avoid using singletons
tobymao
committed
1b54edb
View commit details
Copy full SHA for 1b54edb
View code at this point
Browse repository at this point
Commits on Nov 8, 2022
copy column during replace (#680)
Show description for 5faceb0
ginter
and
Chris Ginter
authored
5faceb0
View commit details
Copy full SHA for 5faceb0
View code at this point
Browse repository at this point
Commits on Nov 1, 2022
100 line length
tobymao
committed
38ee9aa
View commit details
Copy full SHA for 38ee9aa
View code at this point
Browse repository at this point
Commits on Oct 11, 2022
Optimizer: Eliminate CTEs (#576)
barakalon
authored
3ae297a
View commit details
Copy full SHA for 3ae297a
View code at this point
Browse repository at this point
Commits on Oct 10, 2022
changes from review
eakmanrq
committed
fefd3ee
View commit details
Copy full SHA for fefd3ee
View code at this point
Browse repository at this point
Commits on Oct 9, 2022
improve window support in optimizer
eakmanrq
committed
02974a1
View commit details
Copy full SHA for 02974a1
View code at this point
Browse repository at this point
Commits on Oct 5, 2022
cannot push down into multi use ctes (#536)
tobymao
authored
b84660d
View commit details
Copy full SHA for b84660d
View code at this point
Browse repository at this point
Commits on Sep 21, 2022
Set black line length to 120 (#465)
Show description for 4a6a8ef
crericha
and
tobymao
authored
4a6a8ef
View commit details
Copy full SHA for 4a6a8ef
View code at this point
Browse repository at this point
Commits on Sep 6, 2022
cleanup pylint
tobymao
committed
995bea7
View commit details
Copy full SHA for 995bea7
View code at this point
Browse repository at this point
Commits on Jul 10, 2022
handle a bunch of crazy cases by adding array_*
tobymao
committed
6e01fad
View commit details
Copy full SHA for 6e01fad
View code at this point
Browse repository at this point
fix up subquery unnesting
tobymao
committed
ef77bc8
View commit details
Copy full SHA for ef77bc8
View code at this point
Browse repository at this point
Previous
Next
You can’t perform that action at this time.