# Changelog

## 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
