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 }}
codeDing18
sqlglot
Repository navigation
Code
Pull requests
Actions
Projects
Security and quality
Insights
More
items
Commits
Breadcrumbs
History for
sqlglot
sqlglot
transforms.py
on
dev
User selector
All users
Datepicker
All time
Commit history
Commits on Mar 8, 2024
Refactor!(optimizer): only create scopes for the DDL queries (#3096)
Show description for 8a34fb4
georgesittas
authored
8a34fb4
View commit details
Copy full SHA for 8a34fb4
View code at this point
Browse repository at this point
Commits on Feb 24, 2024
fix!: refactor structs to always be aliases (#3017)
Show description for 238f9aa
tobymao
authored
238f9aa
View commit details
Copy full SHA for 238f9aa
View code at this point
Browse repository at this point
Commits on Feb 23, 2024
feat: add unnest type annotations (#3019)
Show description for 17e34e7
tobymao
authored
17e34e7
View commit details
Copy full SHA for 17e34e7
View code at this point
Browse repository at this point
Commits on Feb 9, 2024
fix: if doesn't support different types
tobymao
committed
b70a394
View commit details
Copy full SHA for b70a394
View code at this point
Browse repository at this point
fix(spark): CREATE TABLE ... PARTITIONED BY fixes (#2937)
barakalon
authored
76d6634
View commit details
Copy full SHA for 76d6634
View code at this point
Browse repository at this point
feat: add array and tuple helpers
tobymao
committed
e71d489
View commit details
Copy full SHA for e71d489
View code at this point
Browse repository at this point
fix: explode_outer to unnest closes #2941
tobymao
committed
844018b
View commit details
Copy full SHA for 844018b
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 Dec 31, 2023
fix: generate `CROSS JOIN` instead of comma in `explode_to_unnest` transformation (#2739)
cpcloud
authored
a43174f
View commit details
Copy full SHA for a43174f
View code at this point
Browse repository at this point
Commits on Dec 1, 2023
fix: cannot have union with limit
tobymao
committed
441f624
View commit details
Copy full SHA for 441f624
View code at this point
Browse repository at this point
Fix!: qualify columns added in explode to unnest transformation (#2615)
georgesittas
authored
019e0e5
View commit details
Copy full SHA for 019e0e5
View code at this point
Browse repository at this point
Commits on Nov 30, 2023
Fix: preserve alias quotes in explode_to_unnest (#2613)
georgesittas
authored
5aa134d
View commit details
Copy full SHA for 5aa134d
View code at this point
Browse repository at this point
Commits on Nov 22, 2023
Fix(duckdb): unqualify columns under Pivot (#2590)
Show description for 426075f
georgesittas
authored
426075f
View commit details
Copy full SHA for 426075f
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
Commits on Nov 7, 2023
Remove CTEs from union right side (#2522)
treysp
authored
e9334ea
View commit details
Copy full SHA for e9334ea
View code at this point
Browse repository at this point
Commits on Oct 29, 2023
Refactor!: generator now always copies, making transforms much simpler (#2477)
Show description for 7a6da28
tobymao
and
georgesittas
authored
7a6da28
View commit details
Copy full SHA for 7a6da28
View code at this point
Browse repository at this point
Commits on Oct 27, 2023
Feat!(hive,tsql): move CTEs to top-level, fix T-SQL recursive CTEs (#2467)
Show description for 8036ac4
georgesittas
authored
8036ac4
View commit details
Copy full SHA for 8036ac4
View code at this point
Browse repository at this point
Commits on Oct 25, 2023
Feat(mysql): convert full outer join to union with left/right outer joins (#2461)
Show description for 542ea6c
georgesittas
authored
542ea6c
View commit details
Copy full SHA for 542ea6c
View code at this point
Browse repository at this point
Chore: add docstrings in rest of transforms
georgesittas
committed
927f5aa
View commit details
Copy full SHA for 927f5aa
View code at this point
Browse repository at this point
Commits on Oct 17, 2023
fix: smarter detection of timestamp() fallback to cast
tobymao
committed
a00b5b5
View commit details
Copy full SHA for a00b5b5
View code at this point
Browse repository at this point
Commits on Oct 10, 2023
Feat!: add explode outer and change hiearchy are explosions closes #2393
tobymao
committed
c7c3869
View commit details
Copy full SHA for c7c3869
View code at this point
Browse repository at this point
Commits on Sep 22, 2023
Fix: unnest complex closes #2284
tobymao
committed
06e0869
View commit details
Copy full SHA for 06e0869
View code at this point
Browse repository at this point
Commits on Sep 17, 2023
Fix(snowflake): rename GenerateSeries, include offset in unnest_sql (#2243)
Show description for 829415c
georgesittas
authored
829415c
View commit details
Copy full SHA for 829415c
View code at this point
Browse repository at this point
Feat: eliminate semi/anti joins transformation (#2242)
Show description for f63a06b
georgesittas
authored
f63a06b
View commit details
Copy full SHA for f63a06b
View code at this point
Browse repository at this point
Commits on Sep 16, 2023
Fix!: explode to unnest with multiple explosions (#2235)
Show description for 8100311
tobymao
authored
8100311
View commit details
Copy full SHA for 8100311
View code at this point
Browse repository at this point
Commits on Sep 15, 2023
fix(mysql): TIMESTAMP -> CAST (#2223)
Show description for 857e380
barakalon
authored
857e380
View commit details
Copy full SHA for 857e380
View code at this point
Browse repository at this point
Commits on Sep 14, 2023
Feat: improve support for percentiles in duckdb, postgres (#2219)
georgesittas
authored
0378325
View commit details
Copy full SHA for 0378325
View code at this point
Browse repository at this point
Commits on Sep 6, 2023
add alias when transforming distinct on (#2175)
eakmanrq
authored
dd454b3
View commit details
Copy full SHA for dd454b3
View code at this point
Browse repository at this point
Commits on Sep 5, 2023
Fix: remove inconsistent quotes from eliminate distinct on transform
tobymao
committed
36ac469
View commit details
Copy full SHA for 36ac469
View code at this point
Browse repository at this point
Commits on Sep 1, 2023
Fix: row number in transform requires order by
tobymao
committed
32d8e54
View commit details
Copy full SHA for 32d8e54
View code at this point
Browse repository at this point
Commits on Aug 18, 2023
Refactor!: rename DataTypeSize -> DataTypeParam (#2097)
georgesittas
authored
edb9a96
View commit details
Copy full SHA for edb9a96
View code at this point
Browse repository at this point
Commits on Aug 2, 2023
Fix: ensure eliminate_qualify won't introduce duplicate projections (#1990)
georgesittas
authored
1865959
View commit details
Copy full SHA for 1865959
View code at this point
Browse repository at this point
Commits on Jul 3, 2023
Fix: bigquery don't strip nested types
tobymao
committed
82f8fff
View commit details
Copy full SHA for 82f8fff
View code at this point
Browse repository at this point
Refactor!: hashable args is now more efficient and identifiers no longer accomodate case insensitivity because that is dialect specific
tobymao
committed
f747260
View commit details
Copy full SHA for f747260
View code at this point
Browse repository at this point
Previous
Next
You can’t perform that action at this time.