v0.40.0

What's Changed

• chore: advance sqlfluff-sha for SQLite STRICT support (4766) by @benfdking in #2848
• chore: advance sqlfluff-sha for SQLite RESPECT/QUALIFY cleanup (4765) by @benfdking in #2849
• chore: advance sqlfluff-sha for SQLite Expression_A_Grammar parse fixes (4769) by @benfdking in #2851
• feat: use CollationReferenceSegment for COLLATE in mysql and greenplum (#4770) by @benfdking in #2852
• feat: add StarRocks dialect by @benfdking in #2853
• chore: advance sqlfluff sha for already-ported untaken indents fix (4768) by @benfdking in #2854
• chore: advance sqlfluff-sha for AL05 Redshift semi-structured exception (4775) by @benfdking in #2855
• chore: bump postcss from 8.5.15 to 8.5.16 by @dependabot[bot] in #2868
• chore: bump react-resizable-panels from 4.12.0 to 4.12.1 by @dependabot[bot] in #2867
• chore: bump vite from 8.0.16 to 8.1.3 by @dependabot[bot] in #2862
• chore: bump docker/setup-qemu-action from 4.1.0 to 4.2.0 by @dependabot[bot] in #2858
• chore: bump docker/build-push-action from 7.2.0 to 7.3.0 by @dependabot[bot] in #2859
• chore: bump docker/setup-buildx-action from 4.1.0 to 4.2.0 by @dependabot[bot] in #2861
• chore: bump docker/login-action from 4.2.0 to 4.4.0 by @dependabot[bot] in #2860
• chore: bump ignore from 0.4.26 to 0.4.27 by @dependabot[bot] in #2865
• chore: bump prettier from 3.8.4 to 3.9.4 by @dependabot[bot] in #2864
• ci: use lld for Bazel Rust links by @nikolaevx in #2874
• [codex] Fix SQLite temporary view formatting by @benfdking in #2877
• chore: advance sqlfluff SHA — SQLite CreateTrigger already ported (4767) by @benfdking in #2876
• chore: advance sqlfluff SHA — Snowflake EXECUTE TASK with schema already ported (4771) by @benfdking in #2879
• chore: advance sqlfluff SHA for Jinja 'do' directive indent fix (#4778) by @benfdking in #2880
• chore: bump toml from 0.9.12+spec-1.1.0 to 1.1.2+spec-1.1.0 by @dependabot[bot] in #2863
• chore: fix Python set-up commands in CONTRIBUTING.md by @karimudev in #2883
• feat(sqlite): parse CTE materialization hints by @karimudev in #2882
• Update Bazel pnpm to 10.22.0 by @benfdking in #2884
• fix: silence fix output for none format (4764) by @benfdking in #2881
• chore: update rules_js and pnpm by @benfdking in #2885
• feat: add semantic token highlighting to the playground and VS Code by @benfdking in #2742
• chore: advance sqlfluff SHA — TemplatedFile init consistency check already ported (4776) by @benfdking in #2886
• chore: advance sqlfluff-sha past "fix files as we go" refactor (4777) by @benfdking in #2888
• fix(ST03): exempt data-modifying CTEs from unused_cte by @skyf0l in #2676
• chore: advance sqlfluff-sha past "Better handling of empty files" (4780) by @benfdking in #2890
• fix(postgres): parse ON CONFLICT after a FROM-less INSERT ... SELECT by @skyf0l in #2672
• feat: Trino RF01 row field access by @benfdking in #2892
• chore: advance sqlfluff-sha; BigQuery SAFE prefix segment already ported (4773) by @benfdking in #2891
• fix: remove caching of raw_segments_with_ancestors to prevent memory leaks by @benfdking in #2430
• chore: advance sqlfluff SHA for Snowflake Temporary View (#4789) by @benfdking in #2894
• chore: advance sqlfluff SHA past version prep 2.0.6 (4784) by @benfdking in #2895
• chore: advance sqlfluff SHA past macos/osx config docs fix (4795) by @benfdking in #2896
• chore: bump sqlfluff SHA — brackets/implicit indents fix already ported (#4797) by @benfdking in #2899
• ci: install Kerberos headers for Bazel build by @benfdking in #2898
• chore: advance sqlfluff SHA — implicit indents regression fix already ported (4798) by @benfdking in #2900
• chore: advance sqlfluff SHA past version bump 2.0.7 (#4799) by @benfdking in #2901
• feat: auto-fix naked identifiers when prefer_quoted_identifiers is enabled (RF06) by @nikolaevx with @Copilot in #2599
• chore: add Oracle bare functions parse fixture (#4804) by @benfdking in #2903
• fix(RF01): support parenthesized joined tables in FROM clause by @benfdking in #2245
• chore: update and clean up node deps by @benfdking in #2906
• feat: fix Trino multi-parameter lambdas by @benfdking in #2907
• chore: add Oracle DROP TABLE drop-behaviour fixtures (4803) by @benfdking in #2905
• fix: piggyback whitespace onto existing respace insert fixes by @nikolaevx in #2468
• chore: mark SQLFluff implicit-indent WHEN block port as complete (4755) by @benfdking in #2908
• feat(clickhouse): support CREATE USER by @benfdking in #2911
• chore: mark SQLFluff tsql RF06 square-bracket quote detection port as complete (4781) by @benfdking in #2909
• chore: mark redshift with no schema binding as ported (4813) by @benfdking in #2913
• chore: mark dbt templater error message typo as ported (4814) by @benfdking in #2914
• chore: advance sqlfluff SHA past Hive INSERT INTO without TABLE (4819) by @benfdking in #2915
• chore: advance sqlfluff-sha past ClickHouse DROP statements (4821) by @benfdking in #2916
• feat(clickhouse): add parametric aggregate functions by @benfdking in #2918
• feat(clickhouse): allow SETTINGS on ALTER TABLE by @benfdking in #2919
• chore: mark Snowflake create warehouse comment clause as ported (4823) by @benfdking in #2917
• chore: advance sqlfluff SHA past DBT 1.5 compatibility change (4828) by @benfdking in #2920
• chore: advance sqlfluff SHA past SQLite partial index support (4833) by @benfdking in #2921
• chore: bump @vscode/test-cli from 0.0.12 to 0.0.15 by @dependabot[bot] in #2932
• feat(clickhouse): add ALTER TABLE mutations by @benfdking in #2933
• chore: bump typescript-eslint from 8.61.1 to 8.63.0 by @dependabot[bot] in #2931
• chore: advance sqlfluff SHA past Postgres INSERT RETURNING (4820) by @benfdking in #2922
• chore: bump CodSpeedHQ/action from 4.18.1 to 4.18.5 by @dependabot[bot] in #2923
• chore: bump @playwright/test from 1.61.0 to 1.61.1 by @dependabot[bot] in #2930
• chore: advance sqlfluff SHA past Jinja filters support (4810) by @benfdking in #2934
• chore: bump vscode-languageserver from 10.0.1 to 10.1.0 by @dependabot[bot] in #2927
• chore: advance sqlfluff SHA past version 2.1.0 prep (4838) by @benfdking in #2935
• chore: bump Rust dependencies by @benfdking in #2937
• feat: enable Hive dialect by @benfdking in #2938
• feat: port sqlfluff hive fixtures by @benfdking in #2939
• feat(clickhouse): add tuple element access by @mikills in #2940
• feat(clickhouse): add ClickHouse grant privileges by @mikills in #2941
• fix(clickhouse): tighten parametric type parsing by @mikills in #2942
• feat: Hive support REGEXP and IREGEXP (4846) by @benfdking in #2936
• chore: advance sqlfluff-sha for Sqlite COLLATE column constraint (#4845) by @benfdking in #2943
• fix(clickhouse): parse view security and dictionaries by @mikills in #2945
• chore: bump react-resizable-panels from 4.12.1 to 4.12.2 by @dependabot[bot] in #2929
• fix(clickhouse): parse QUALIFY clauses by @mikills in #2946
• chore: bump mcp from 1.25.0 to 1.27.2 in the uv group across 1 directory by @dependabot[bot] in #2947
• fix(clickhouse): parse SETTINGS after UNION by @mikills in #2948
• fix(clickhouse): parse EXCEPT ALL bracketed set expressions by @mikills in #2949
• fix(clickhouse): parse SELECT APPLY wildcard modifiers by @mikills in #2950
• fix(clickhouse): parse lateral column aliases by @mikills in #2951
• fix: LT12 no longer errors on empty files (4834) by @benfdking in #2944
• chore: advance sqlfluff-sha for ClickHouse SYSTEM queries (#4625) by @benfdking in #2952
• chore: advance sqlfluff-sha for TSQL SET DEADLOCK_PRIORITY (#4853) by @benfdking in #2953
• feat: port TSQL CREATE ROLE AUTHORIZATION (#4852) by @benfdking in #2954
• chore: document Athena keyword source lists (Trino v3 link) (#4858) by @benfdking in #2955
• feat: support NOCOPY and INSTANT ALGORITHM on MySQL CREATE INDEX (#4865) by @benfdking in #2956
• chore: advance sqlfluff SHA past show tables/views for athena (4854) by @benfdking in #2957
• chore: mark SQLFluff Athena CUBE/ROLLUP/GROUPING SETS as ported (#4862) by @benfdking in #2958
• chore: port Athena "weird" group by test cases (4869) by @benfdking in #2959
• chore: skip docs-only pip install link fix (#4867) by @benfdking in #2960
• chore: add Oracle CREATE VIEW EDITIONING & FORCE test fixtures (4872) by @benfdking in #2961
• chore: advance sqlfluff sha for sparksql star in multiparameter functions (4874) by @benfdking in #2962
• chore: advance sqlfluff sha for athena full SHOW coverage (4876) by @benfdking in #2964
• chore: advance sqlfluff SHA for BigQuery ARRAY function type (#4880) by @benfdking in #2965
• fix(clickhouse): parse ARRAY JOIN clause boundaries by @mikills in #2963
• fix(clickhouse): parse ternary conditional operator by @mikills in #2967
• chore: advance sqlfluff SHA for BigQuery empty STRUCT in TO_JSON (#4879) by @benfdking in #2966
• fix(clickhouse): parse double-equals comparisons by @mikills in #2968
• fix(clickhouse): parse JSON type arguments by @mikills in #2971
• chore: advance sqlfluff SHA for dbt profiles dir env var change (#4886) by @benfdking in #2970
• chore: advance sqlfluff SHA for version 2.1.1 release prep (#4888) by @benfdking in #2972
• chore: advance sqlfluff SHA past ROLLUP/CUBE AM06 support (4892) by @benfdking in #2973
• chore: bump typescript-eslint from 8.63.0 to 8.64.0 by @dependabot[bot] in #2982
• feat: MySQL ON UPDATE NOW (#4898) by @benfdking in #2986
• fix(clickhouse): parse ORDER BY WITH FILL INTERPOLATE by @mikills in #2989
• chore: combine Rust dependency updates by @benfdking in #2990
• chore: mark Postgres dollar literal & non-reserved collation as already ported (4883) by @benfdking in #2987
• chore: bump actions/setup-python from 6.3.0 to 7.0.0 by @dependabot[bot] in #2975
• chore: bump actions/setup-node from 6.4.0 to 7.0.0 by @dependabot[bot] in #2974
• chore: mark bracketed FROM clause with joins as already ported (4890) by @benfdking in #2991
• test(clickhouse): cover tuple access on arbitrary expressions by @mikills in #2993
• chore: bump JavaScript dependencies by @benfdking in #2995
• chore: skip docs-only templater configuration docs refactor (4835) by @benfdking in #2994
• chore: stack next-sqlfluff port PRs by @benfdking in #2996
• feat: Oracle support for $ and # in identifiers (4903) by @benfdking in #2997
• chore: mark Snowflake CREATE PROCEDURE/FUNCTION actualization as already ported (4908) by @benfdking in #2998
• chore: advance sqlfluff sha past clickhouse CREATE DATABASE (#4620) by @benfdking in #2999
• feat: TSQL support for DROP EXTERNAL TABLE (#4919) by @benfdking in #3000
• chore: advance sqlfluff SHA past Snowflake CREATE TAG (#4914) by @benfdking in #3001
• chore: advance sqlfluff sha for postgres frame_clause quoted interval (#4915) by @benfdking in #3002
• chore: advance sqlfluff sha past release-notes docs fix (#4921) by @benfdking in #3003
• fix(clickhouse): parse non-final union member clauses by @mikills in #3006
• fix(clickhouse): parse multi-column limit by by @mikills in #3008
• fix(clickhouse): parse group by modifiers by @mikills in #3009
• feat: add --library-path override for jinja templater (#4925) by @benfdking in #3004
• chore: advance sqlfluff sha past dbt 1.5.2+ compat fix (#4939) by @benfdking in #3005
• chore: advance sqlfluff sha past dbt 1.1 & 1.2 re-enable (#4944) by @benfdking in #3010
• chore: bump postcss from 8.5.16 to 8.5.23 by @dependabot[bot] in #3024
• chore: bump docker/login-action from 4.4.0 to 4.5.1 by @dependabot[bot] in #3025
• chore: bump actions/checkout from 7.0.0 to 7.0.1 by @dependabot[bot] in #3026
• chore: bump @vitejs/plugin-react-swc from 4.3.1 to 4.3.2 by @dependabot[bot] in #3020
• chore: combine Secretlint updates by @benfdking in #3030
• chore: bump the uv group across 1 directory with 2 updates by @dependabot[bot] in #3027
• fix(oracle): drop reference to undefined JSONObjectContentSegment by @dkxmercury in #3016
• fix(postgres): lex the jsonb operators @?, @@, ?| and ?& by @merlinorg in #3019
• docs: document SQLFLUFF_JINJA_FILTERS in jinja templater (#4932) by @benfdking in #3011
• chore: advance sqlfluff sha past 2.1.2 version prep (#4931) by @benfdking in #3012
• feat: support ALTER TABLE RENAME COLUMN in MySQL dialect (#4948) by @benfdking in #3013
• feat: support ALTER TABLE RENAME INDEX/KEY in MySQL dialect (#4950) by @benfdking in #3028
• chore: decouple Cargo vendoring from Rust sources by @benfdking in #3036
• chore: advance sqlfluff sha past click mypy ignores (#4954) by @benfdking in #3029
• chore: limit SQLFluff port PR automation by @benfdking in #3041
• chore: advance sqlfluff sha past new issue labeler library (#4952) by @benfdking in #3031
• chore: advance sqlfluff sha past RF05 empty identifier fix (#4953) by @benfdking in #3033
• chore: cover Claude commands with Prettier by @benfdking in #3042
• chore: update Rust to 1.97.1 by @benfdking in #3039
• chore: bump prettier from 3.9.4 to 3.9.6 by @dependabot[bot] in #3058
• chore: combine npm dependency upgrades by @benfdking in #3063
• chore: combine Rust dependency upgrades by @benfdking in #3064
• chore: bump cryptography from 48.0.1 to 50.0.0 in the uv group across 1 directory by @dependabot[bot] in #3062
• chore: bump CodSpeedHQ/action from 4.18.5 to 5.0.1 by @dependabot[bot] in #3056
• chore: bump docker/login-action from 4.5.1 to 4.6.0 by @dependabot[bot] in #3054
• chore: update React dependencies by @benfdking in #3065
• feat(dialects): add Exasol support by @benfdking in #3045
• feat(dialects): add Materialize dialect (ported from SQLFluff) by @benfdking in #3066
• chore: bump pymdown-extensions from 11.0 to 11.0.1 in the uv group across 1 directory by @dependabot[bot] in #3067
• chore: remove Databricks keywords test fixture and reorganize Exasol/Materialize tests by @benfdking in #3068
• chore: advance sqlfluff sha past issue-labeler bump (#4958) by @benfdking in #3037
• chore: advance sqlfluff sha past postgres underscore array data type (#4959) by @benfdking in #3038
• chore: advance sqlfluff sha past run-one-rule-test-locally tooling (#4963) by @benfdking in #3040
• chore: advance sqlfluff sha past mypy ignore removal (#4972) by @benfdking in #3043
• ci: use sandbox-local Cargo home by @benfdking in #3073
• feat: add Teradata dialect by @benfdking in #3075
• chore: advance sqlfluff sha past teradata DEL keyword (#4962) by @benfdking in #3069
• chore: advance sqlfluff sha past github sponsors funding update (#4973) by @benfdking in #3070
• chore: bump Swatinem/rust-cache from 2.9.1 to 2.9.2 by @dependabot[bot] in #3079
• chore: bump actions/attest-build-provenance from 4.1.1 to 4.2.2 by @dependabot[bot] in #3084
• chore: bump CodSpeedHQ/action from 5.0.1 to 5.0.3 by @dependabot[bot] in #3080
• ci: only run the SHA advance check for .sqlfluff-sha-only changes by @benfdking in #3091
• chore: bump clap from 4.6.1 to 4.6.6 by @dependabot[bot] in #3082
• fix(dialects): preserve Databricks CTE references by @wklimowicz in #3087
• chore: enforce alphabetical SyntaxKind with google/keep-sorted by @benfdking in #3090
• chore: bump ignore from 0.4.28 to 0.4.32 by @dependabot[bot] in #3083
• ci: fix bazel test suite by @benfdking in #3078
• feat(tsql): add t-sql ALTER VIEW parsing by @benfdking in #3093
• fix(postgres): preserve quoted type casing by @benfdking in #3095
• chore: bump glob from 0.3.3 to 0.3.4 by @dependabot[bot] in #3085
• chore: bump regex-automata from 0.4.16 to 0.4.18 by @dependabot[bot] in #3081
• ci: report skipped SQLFluff SHA build checks by @benfdking in #3096
• chore: bump pyo3 from 0.29.0 to 0.29.2 by @dependabot[bot] in #3086
• chore: restore sqlfluff sha advance for #4973 by @benfdking in #3098
• fix(snowflake): parse multi-column unique constraints by @benfdking in #3097
• chore: advance sqlfluff sha past Snowflake GROUP BY ALL (#4976) by @benfdking in #3071
• chore: advance sqlfluff sha past Snowflake column named cross (#4975) by @benfdking in #3072
• chore: advance sqlfluff sha past click mypy ignore revert (#4967) by @benfdking in #3074
• fix: sparksql lateral view parse tree for multiple column alias (#4980) by @benfdking in #3076
• feat: support tsql COPY INTO (#4985) by @benfdking in #3088
• feat(sqlite): sqlite column conflict clauses by @benfdking in #3101
• chore: advance sqlfluff sha past dbt which flag (#4982) by @benfdking in #3099
• chore: advance sqlfluff sha past version prep 2.1.3 (#4979) by @benfdking in #3100
• chore: advance sqlfluff sha past athena WITH ORDINALITY (#4991) by @benfdking in #3102
• fix(sqlite): SQLite CREATE TRIGGER parsing by @benfdking in #3104
• ci: dialect grammar references by @benfdking in #3109
• chore: advance sqlfluff sha past docs fork-me banner removal (#4989) by @benfdking in #3103
• fix(trino): catch up with SQLFluff and stop panicking on common statements by @dkxmercury in #3046
• chore: advance sqlfluff sha past Snowflake CROSS JOIN syntax (#4996) by @benfdking in #3105
• chore: advance sqlfluff sha past BigQuery quoted literals with data type (#4992) by @benfdking in #3106
• fix(postgres): parse text search configuration statements by @benfdking in #3112
• chore: advance sqlfluff sha past Postgres ALTER ROLE role keywords (#4994) by @benfdking in #3107
• chore: advance sqlfluff sha past layout config validation (#4997) by @benfdking in #3108
• chore: advance sqlfluff sha past parse-phase copy reduction (#4988) by @benfdking in #3110
• fix(cli): preserve stdin formatter trailing newlines by @mikills in #3115
• feat: parse Exasol VALUES literals as literals not expressions (#4981) by @benfdking in #3111
• chore: advance sqlfluff sha past Databricks SET TIME ZONE (#5000) by @benfdking in #3113
• chore: advance sqlfluff sha past 2.1.4 version prep (#5001) by @benfdking in #3116
• chore: advance sqlfluff sha past ClickHouse dollar quoted literals (#5003) by @benfdking in #3118
• chore: advance sqlfluff sha past Redshift Qualify Clause (#5002) by @benfdking in #3119
• fix: Jinja rendered-to-source position markers by @benfdking in #3126
• fix(postgres): gate extension keywords by config by @benfdking in #3128
• chore: advance sqlfluff sha past function name in grants (#5006) by @benfdking in #3121
• chore: bump version to 0.40.0 by @benfdking in #3130

New Contributors

• @karimudev made their first contribution in #2883
• @nikolaevx with @Copilot made their first contribution in #2599
• @dkxmercury made their first contribution in #3016
• @merlinorg made their first contribution in #3019
• @wklimowicz made their first contribution in #3087

Full Changelog: v0.39.0...v0.40.0