Skip to content
CAI
Software that uses CAICheck a score

tobymao/sqlglot

62.4

Adequate · 17 November 2026

73.3k

lines of production code

Python

primary language

1

measurement over time

CAI band scale
CAI lens gauges

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.