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 }}
codingforkind
sqlglot
Repository navigation
Code
Pull requests
Actions
Projects
Security and quality
Insights
More
items
Commits
Breadcrumbs
History for
sqlglot
sqlglot
diff.py
on
main
User selector
All users
Datepicker
All time
Commit history
Commits on Apr 6, 2026
Refactor: use ruff UP rule to modernize coding style (#7459)
georgesittas
authored
08b51e8
View commit details
Copy full SHA for 08b51e8
View code at this point
Browse repository at this point
Commits on Mar 20, 2026
chore: use collections.abc and built-in types for typing to avoid deprecation (#7329)
Show description for f7bb6be
OutSquareCapital
authored
f7bb6be
View commit details
Copy full SHA for f7bb6be
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 26, 2026
Chore: scan all modules under sqlglot/ for doc tests (#7162)
georgesittas
authored
4a955cb
View commit details
Copy full SHA for 4a955cb
View code at this point
Browse repository at this point
Commits on Jan 7, 2026
Feat(diff)!: ignore comments in the semantic differ (#6675)
georgesittas
authored
a39642f
View commit details
Copy full SHA for a39642f
View code at this point
Browse repository at this point
Commits on Dec 15, 2025
Fix(diff)!: stop treating `None` args as leaves to be diffed (#6556)
georgesittas
authored
2bec0bf
View commit details
Copy full SHA for 2bec0bf
View code at this point
Browse repository at this point
Commits on Mar 3, 2025
fix: allow duplicate nodes in matchings (#4817)
tobymao
authored
e5b4adf
View commit details
Copy full SHA for e5b4adf
View code at this point
Browse repository at this point
Commits on Oct 28, 2024
Fix: handle a Move edge case in the semantic differ (#4295)
Show description for 21deda3
georgesittas
authored
21deda3
View commit details
Copy full SHA for 21deda3
View code at this point
Browse repository at this point
Commits on Oct 22, 2024
Refactor(diff)!: include the target node for Move edits (#4277)
georgesittas
authored
17b8c0b
View commit details
Copy full SHA for 17b8c0b
View code at this point
Browse repository at this point
Commits on Oct 18, 2024
Fix: make the semantic diffing aware of changes to non-expression leaves (#4268)
georgesittas
authored
a28da91
View commit details
Copy full SHA for a28da91
View code at this point
Browse repository at this point
Commits on Oct 15, 2024
Refactor: simplify _expression_only_args helper in diff module (#4251)
georgesittas
authored
912faad
View commit details
Copy full SHA for 912faad
View code at this point
Browse repository at this point
Commits on Oct 3, 2024
Feat: allow supplying dialect in diff, conditionally copy ASTs (#4208)
georgesittas
authored
355b811
View commit details
Copy full SHA for 355b811
View code at this point
Browse repository at this point
Commits on Oct 1, 2024
Fix: expand UPDATABLE_EXPRESSION_TYPES to account for Identifier changes (#4197)
georgesittas
authored
13638ce
View commit details
Copy full SHA for 13638ce
View code at this point
Browse repository at this point
Commits on Sep 26, 2024
Feat: expose a flag to automatically exclude Keep diff nodes (#4168)
georgesittas
authored
c6ad10f
View commit details
Copy full SHA for c6ad10f
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 a851ec5
tobymao
authored
a851ec5
View commit details
Copy full SHA for a851ec5
View code at this point
Browse repository at this point
Commits on Mar 1, 2024
Fix: Ignore Identifier nodes in the diffing algorithm (#3065)
izeigerman
authored
b0cd778
View commit details
Copy full SHA for b0cd778
View code at this point
Browse repository at this point
Commits on May 25, 2023
Chore!: improve python type hints (#1689)
Show description for ab3360d
georgesittas
authored
ab3360d
View commit details
Copy full SHA for ab3360d
View code at this point
Browse repository at this point
Commits on May 11, 2023
Feat: In the SQL diff improve the tie breaker for leaves with the same similarity score by comparing their parents (#1597)
izeigerman
authored
4bd1be8
View commit details
Copy full SHA for 4bd1be8
View code at this point
Browse repository at this point
Commits on Mar 22, 2023
diffing identifiers only makes sense if the parent's are the same
tobymao
committed
cde465e
View commit details
Copy full SHA for cde465e
View code at this point
Browse repository at this point
make optimizer faster (#1326)
tobymao
authored
c8da032
View commit details
Copy full SHA for c8da032
View code at this point
Browse repository at this point
Commits on Feb 22, 2023
Use idiomatic python when composing node id mappings for input matchings in diff implementation
izeigerman
committed
4cb83bf
View commit details
Copy full SHA for 4cb83bf
View code at this point
Browse repository at this point
Commits on Feb 21, 2023
Extend the diff implementation with ability to provide a list of matched node pairs (#1206)
izeigerman
authored
f5d284b
View commit details
Copy full SHA for f5d284b
View code at this point
Browse repository at this point
Export everything in __init__.py explicitly using aliases (#1207)
georgesittas
authored
2a834a1
View commit details
Copy full SHA for 2a834a1
View code at this point
Browse repository at this point
Commits on Feb 7, 2023
Minor pdoc fix
georgesittas
committed
67eb915
View commit details
Copy full SHA for 67eb915
View code at this point
Browse repository at this point
Commits on Feb 6, 2023
Add POST_CREATE properties (#1101)
Show description for fed4aec
treysp
and
georgesittas
authored
fed4aec
View commit details
Copy full SHA for fed4aec
View code at this point
Browse repository at this point
Commits on Jan 27, 2023
column level lineage (#1022)
Show description for 3b4d2c4
tobymao
authored
3b4d2c4
View commit details
Copy full SHA for 3b4d2c4
View code at this point
Browse repository at this point
Commits on Jan 26, 2023
Cleaned up some docs (#1015)
Show description for ae68543
georgesittas
authored
ae68543
View commit details
Copy full SHA for ae68543
View code at this point
Browse repository at this point
Commits on Dec 19, 2022
Add docs for expressions, minor cleanups (#823)
Show description for 7ee5c59
georgesittas
authored
7ee5c59
View commit details
Copy full SHA for 7ee5c59
View code at this point
Browse repository at this point
Commits on Nov 11, 2022
Add more python types (#695)
Show description for e93d731
georgesittas
authored
e93d731
View commit details
Copy full SHA for e93d731
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
cleanup
tobymao
committed
cf9e892
View commit details
Copy full SHA for cf9e892
View code at this point
Browse repository at this point
Annotate SQLGlot with python types (WIP) (#642)
Show description for a6a225f
georgesittas
and
eakmanrq
authored
a6a225f
View commit details
Copy full SHA for a6a225f
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
switch to autoflake
tobymao
committed
3758d15
View commit details
Copy full SHA for 3758d15
View code at this point
Browse repository at this point
Commits on Jul 28, 2022
Perform deep copying of input trees before proceeding with the comparison
izeigerman
committed
d681ca2
View commit details
Copy full SHA for d681ca2
View code at this point
Browse repository at this point
Previous
Next
You can’t perform that action at this time.