tobymao/sqlglot
62.4
Adequate · 17 November 2026
73.3k
lines of production code
Python
primary language
1
measurement over time
What this system is
Behavioural changes
1266 commits (155 fixes) modifying (repo-wide)
A change to existing behaviour in (repo-wide) — 1266 commits (155 fixs), 16 files: “Update LICENSE”; “docs: update API docs, CHANGELOG.md for v25.9.0 \[skip ci\]”; “docs: update API docs, CHANGELOG.md for v19.7.0 \[skip ci\]”; and 898 more (refs \#3938, \#7468, \#8638, \#7458, \#7500, …).
(repo-wide) · low confidence · unverified
136 commits (39 fixes) modifying sqlglot/executor
A change to existing behaviour in sqlglot/executor — 136 commits (39 fixs), 5 files: “add between”; “Refactor(executor): simplify column type inference (\#3104)”; “fix(executor): execute an IN/ANY subquery that has no FROM \[CLAUDE\] (\#8221)”; and 133 more (refs \#3104, \#8221, \#8158, \#2983, \#7276, …).
sqlglot/executor · medium confidence · unverified
19 commits (2 fixes) modifying benchmarks
A change to existing behaviour in benchmarks — 19 commits (2 fixs), 4 files: “feat!!: remove rust and build c (\#7120)”; “Chore: compare performance on main vs pr branch (\#5149)”; “perf: cache generator dispatch table for faster sql() \[CLAUDE\] (\#7404)”; and 16 more (refs \#7120, \#5149, \#7404, \#3595, \#7293, …).
benchmarks · medium confidence · unverified
231 commits (89 fixes) modifying sqlglot/expressions
A change to existing behaviour in sqlglot/expressions — 231 commits (89 fixs), 16 files: “feat(trino): parse CASE routine statements \[CLAUDE\] (\#8068)”; “feat(parser): supprot AGG (\#8414)”; “fix(postgres): support jsonpath @? operator CODEX (\#7766)”; and 227 more (refs \#8068, \#8414, \#7766, \#8633, \#8223, …).
sqlglot/expressions · medium confidence · unverified
3130 commits (1266 fixes) modifying sqlglot/dialects
A change to existing behaviour in sqlglot/dialects — 3130 commits (1266 fixs), 35 files: “feat(teradata): random lower upper closes \#3721”; “fix: duckdb ISNAN (\#2024)”; “Fix(clickhouse): add ipv4/6 data type parser (\#2829)”; and 3090 more (refs \#3721, \#2024, \#2829, \#4806, \#3836, …).
sqlglot/dialects · medium confidence · unverified
3330 commits (1363 fixes) modifying sqlglot
A change to existing behaviour in sqlglot — 3330 commits (1363 fixs), 20 files: “v1.27.0”; “truncate and other command functions”; “feat(teradata): random lower upper closes \#3721”; and 3262 more (refs \#3721, \#2829, \#7290, \#1105, \#846, …).
sqlglot · medium confidence · unverified
428 commits (52 fixes) modifying sqlglot/typing
A change to existing behaviour in sqlglot/typing — 428 commits (52 fixs), 15 files: “feat(snowflake)!: New type + type annotation for TO\_FILE (\#6548)”; “feat(optimizer)!: annotate \UNIX\_DATE(expr)\ for Spark/DBX (\#7011)”; “feat(snowflake)!: annotation support for APPROX\_TOP\_K\_ESTIMATE . Return type ARRAY (\#6445)”; and 424 more (refs \#6548, \#7011, \#6445, \#8059, \#6736, …).
sqlglot/typing · medium confidence · unverified
57 commits (6 fixes) modifying sqlglotc
A change to existing behaviour in sqlglotc — 57 commits (6 fixs), 2 files: “Refactor!: Fully compile schema (\#7276)”; “refactor!: Extract Teradata parser for mypyc compilation (\#7237)”; “feat!!: remove rust and build c (\#7120)”; and 54 more (refs \#7276, \#7237, \#7120, \#7236, \#7238, …).
sqlglotc · medium confidence · unverified
6 commits (1 fix) modifying pdoc
A change to existing behaviour in pdoc — 6 commits (1 fix), 2 files: “chore: switch to ruff (\#2912)”; “update pdoc link”; “Chore: fix pdoc deployment (\#4856)”; and 3 more (refs \#2912, \#4856, \#7149, \#820).
pdoc · medium confidence · unverified
Fixes
391 commits (205 fixes) fixing sqlglot/parsers
A fix in sqlglot/parsers — 391 commits (205 fixs), 35 files: “feat(snowflake): support SCOPED TEMPORARY objects (\#8883)”; “feat(trino): parse CASE routine statements \[CLAUDE\] (\#8068)”; “fix(clickhouse): map bitwise aggregates to groupBitAnd/Or/Xor (\#8556)”; and 380 more (refs \#8883, \#8068, \#8556, \#8633, \#8006, …).
sqlglot/parsers · medium confidence · unverified
441 commits (260 fixes) fixing sqlglot/generators
A fix in sqlglot/generators — 441 commits (260 fixs), 35 files: “feat(snowflake): support SCOPED TEMPORARY objects (\#8883)”; “feat(duckdb): Add transpilation support for RTRIMMED\_LENGTH function (\#7468)”; “feat(trino): parse CASE routine statements \[CLAUDE\] (\#8068)”; and 426 more (refs \#8883, \#7468, \#8068, \#8550, \#8556, …).
sqlglot/generators · medium confidence · unverified
937 commits (532 fixes) fixing sqlglot/optimizer
A fix in sqlglot/optimizer — 937 commits (532 fixs), 24 files: “remove unnecessary copies”; “fix(optimizer): allow aliased negative integer literal as group by column (\#5791)”; “fix(optimizer)!: only qualify lateral sources in their defining scope (\#8049)”; and 918 more (refs \#5791, \#8049, \#8638, \#438, \#1583, …).
sqlglot/optimizer · medium confidence · unverified
Test coverage
1 commit adding/updating tests in tests/sqlglot; 1241 commits adding/updating tests in tests/fixtures/optimizer; 1291 commits adding/updating tests in tests; 3811 commits adding/updating tests in tests/dialects; 565 commits adding/updating tests in tests/fixtures; 57 commits adding/updating tests in tests/fixtures/optimizer/tpc-ds; 59 commits adding/updating tests in tests/fixtures/optimizer/tpc-h.
Dependencies
31 commits updating dependencies (2 manifests)
A dependency / build maintenance change in (dependencies) — 31 commits (7 fixs), 2 files: “Chore: bump sqlglot-mypy, fix leakcheck”; “Chore: Revert setup.py for sqlglot-mypy (\#7458)”; “Refactor: use ruff UP rule to modernize coding style (\#7459)”; and 28 more (refs \#7458, \#7459, \#7120, \#4865, \#8126, …).
(dependencies) · medium confidence · unverified
Written by cca.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.
How this codebase got here
Baseline
- First survey — no prior run to compare against. CAI 62.4.
Lenses
- Code Health 62.4
- Architecture 85.3
- Maturity 66.3
- Readiness 62.8
- Security 58.4
- Performance 85.0
Changes since last survey
- 300 commits — 113 feature/other, 187 fixes
By area
- (root) — 83 commits
- sqlglot/generators — 52 commits
- sqlglot/optimizer — 35 commits
- tests/dialects — 28 commits
- sqlglot/parsers — 24 commits
- sqlglot/dialects — 23 commits
- sqlglot/expressions — 19 commits
- sqlglot/generator.py — 11 commits
- sqlglot/parser.py — 10 commits
- tests/fixtures — 3 commits
- sqlglot/diff.py — 2 commits
- sqlglot/schema.py — 2 commits
- sqlglot/typing — 2 commits
- .github/workflows — 1 commit
- posts/ast_primer.md — 1 commit
- sqlglot/jsonpath.py — 1 commit
- sqlglot/tokens.py — 1 commit
- sqlglot/transforms.py — 1 commit
- tests/test_optimizer.py — 1 commit
Notable commits
- fix: fix(optimizer)!: preserve row presence when decorrelating scalar aggregates (#8851)
- fix: Fix BigQuery mixed STRUCT/tuple arrays for cross-dialect transpilation (#8998)
- fix: Fix(parser): infinite recursion in _parse_describe when DESC is followed by a dot (#8871)
- fix: fix ci
- fix: fix style
- fix: fix test
- fix: fix test
- fix: fix tests, simplify guard
- fix: fix!: NormalizationStrategy.CASE_INSENSITIVE_EXCEPT_TALBES (#8935)
- fix: fix(bigquery): cast zoneless Presto/Trino AT TIME ZONE operand to TIMESTAMP (#9097)
- fix: fix(bigquery): escape backticks and backslashes in quoted identifiers (#8863)
- fix: fix(bigquery): rewrite LIKE ... ESCAPE literal patterns to backslash escapes (#9095)
- fix: fix(bigquery): stabilize INFORMATION_SCHEMA round trips [CODEX] (#9133)
- fix: fix(bigquery): type DATETIME_ADD/TIMESTAMP_ADD by their argument (#9117)
- fix: fix(clickhouse)!: treat SHA1/SHA256/SHA512 as binary digests [CLAUDE] (#9156)
- fix: fix(clickhouse): generate array sorts and logical aggregates (#9072)
- fix: fix(clickhouse): map formatDateTime specifiers that differ from strftime
- fix: fix(clickhouse): parenthesize multi-row VALUES relations (#8943)
- fix: fix(clickhouse): preserve escaped time format specifiers
- fix: fix(clickhouse): preserve logical aggregate null and numeric semantics
- …and 280 more
Written by cca.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.
Survey your own repository
tobymao/sqlglot was measured the same way every project in this corpus was: the same rubric, at a pinned commit, with the result published in full. Point a surveyor at a repository you know and see whether you agree with it.
About this page
- The score is its most recent published measurement, taken on 17 November 2026 at a pinned commit. It is not a live figure and does not change until the project is measured again.
- Measured at commit 3721a79d71d7f7b4dd3c8f08e56fbe527d45eb5b — the exact code this score is about.
- Scored under rubric-2026.11.4 — the same rubric and the same method as every other entry in this index.
- Measured by Canine Code Analyzer (cca.canine.dev) using cca measure-2026.11.85+preprod-eba6548ac50f.