v0.39.0

What's Changed

• chore: improve next-sqlfluff skill with branching and fixture checks by @benfdking in #2545
• chore: skip adding schema to set statement, already ported (#4580) by @benfdking in #2546
• chore: skip trailing_comments config for long lines, already ported (#4558) by @benfdking in #2547
• chore: improve next-sqlfluff skill with bazel tests and PR creation by @benfdking in #2548
• chore: skip terminators in BaseExpression, already ported (#4577) by @benfdking in #2549
• chore: make Bazel tests mandatory in next-sqlfluff skill by @benfdking in #2551
• chore: skip matches_target_tuples removal, already ported (#4561) by @benfdking in #2550
• chore: bump CodSpeedHQ/action from 4.13.0 to 4.13.1 by @dependabot[bot] in #2553
• chore: update hash rust dependencies by @benfdking in #2563
• chore: bump docker/build-push-action from 7.0.0 to 7.1.0 by @dependabot[bot] in #2557
• chore: bump vite from 8.0.5 to 8.0.8 by @dependabot[bot] in #2562
• chore: bump pytest from 9.0.2 to 9.0.3 in the uv group across 1 directory by @dependabot[bot] in #2564
• chore: bump PyO3/maturin-action from 1.50.1 to 1.51.0 by @dependabot[bot] in #2552
• chore: bump @secretlint/secretlint-rule-no-dotenv from 11.4.1 to 11.7.1 by @dependabot[bot] in #2561
• chore: bump actions/upload-artifact from 7.0.0 to 7.0.1 by @dependabot[bot] in #2554
• chore: bump actions/upload-pages-artifact from 4.0.0 to 5.0.0 by @dependabot[bot] in #2555
• chore: fix clippy errors by @benfdking in #2581
• chore: update bazel to version 9.1.0 by @benfdking in #2582
• chore: update node deps by @benfdking in #2583
• chore: bump rust dependencies by @benfdking in #2585
• chore: bump CodSpeedHQ/action from 4.13.1 to 4.14.0 by @dependabot[bot] in #2574
• chore: bump postcss from 8.5.8 to 8.5.10 in the npm_and_yarn group across 1 directory by @dependabot[bot] in #2584
• chore: bump actions/setup-node from 6.3.0 to 6.4.0 by @dependabot[bot] in #2567
• chore: bump @secretlint/secretlint-rule-preset-recommend from 12.1.0 to 12.3.1 by @dependabot[bot] in #2568
• chore: bump python-multipart from 0.0.22 to 0.0.26 in the uv group across 1 directory by @dependabot[bot] in #2566
• Fix broken default configuration file link by @fengfeng-zi in #2580
• feat: add DB2 unreserved keywords from IBM docs (4575) by @benfdking in #2565
• chore: update rust by @benfdking in #2588
• chore: TSQL implicit indents on WHERE already ported (4583) by @benfdking in #2589
• chore: skip Python-only preface debug formatting (4584) by @benfdking in #2590
• chore: skip MySQL quoted-literal alias intermediate state (4591) by @benfdking in #2591
• chore: skip data type spacing refactor (4592) by @benfdking in #2592
• chore: bump hashbrown from 0.17.0 to 0.17.1 by @dependabot[bot] in #2604
• chore: bump serde_with from 3.18.0 to 3.20.0 by @dependabot[bot] in #2603
• chore: bump the uv group across 1 directory with 2 updates by @dependabot[bot] in #2600
• chore: bump eslint from 10.2.1 to 10.3.0 by @dependabot[bot] in #2597
• chore: bump postcss from 8.5.10 to 8.5.13 by @dependabot[bot] in #2595
• chore: bump the npm_and_yarn group across 1 directory with 9 updates by @dependabot[bot] in #2608
• chore: bump CodSpeedHQ/action from 4.14.0 to 4.15.1 by @dependabot[bot] in #2602
• chore: bump urllib3 from 2.6.3 to 2.7.0 in the uv group across 1 directory by @dependabot[bot] in #2609
• chore: bump typescript from 6.0.2 to 6.0.3 by @dependabot[bot] in #2616
• chore: bump vite from 8.0.8 to 8.0.13 by @dependabot[bot] in #2613
• chore: bump fflate to 0.8.3 and assert_cmd to 2.2.2 by @benfdking in #2619
• chore: bump the uv group across 1 directory with 2 updates by @dependabot[bot] in #2618
• chore: bump ws from 8.20.0 to 8.20.1 in the npm_and_yarn group across 1 directory by @dependabot[bot] in #2617
• chore: bump @playwright/test from 1.57.0 to 1.60.0 by @dependabot[bot] in #2615
• chore: skip already-ported parse caching commit (#4576) by @benfdking in #2625
• chore: skip SQLFluff 2.0.2 version bump (#4597) by @benfdking in #2626
• chore: skip already-ported Postgres WITH ORDINALITY support (#4599) by @benfdking in #2627
• chore: skip already-ported Clickhouse lambda function support (#4611) by @benfdking in #2628
• chore: skip dbt DbtProjectError handling, already covered (#4606) by @benfdking in #2629
• chore: skip already-ported Clickhouse materialized view (#4605) by @benfdking in #2630
• feat: TSQL CREATE DATABASE SCOPED CREDENTIAL (#4615) by @benfdking in #2631
• fix: allow KEY as identifier in SQLite dialect by @benfdking in #2632
• feat: MySQL unnamed constraints (#4616) by @benfdking in #2633
• chore: skip SQLFluff --bench rule timings (#4601) by @benfdking in #2634
• chore: bump docker/setup-buildx-action from 4.0.0 to 4.1.0 by @dependabot[bot] in #2635
• chore: bump docker/build-push-action from 7.1.0 to 7.2.0 by @dependabot[bot] in #2636
• chore: bump docker/login-action from 4.1.0 to 4.2.0 by @dependabot[bot] in #2637
• chore: bump minijinja, serde_json, log, mimalloc by @benfdking in #2647
• chore: bump react, react-dom, and @types/react to 19.2.6 by @benfdking in #2648
• chore: bump @secretlint/secretlint-rule-preset-recommend from 12.3.1 to 13.0.2 by @dependabot[bot] in #2646
• chore: bump react-resizable-panels from 3.0.6 to 4.0.16 by @benfdking in #2649
• fix: LT01 alias alignment with multi-byte literals (#2605) by @benfdking in #2642
• docs: reference existing Zed extension in community projects by @benfdking in #2650
• fix(duckdb): trailing comma bug by @wyatt-herkamp in #2653
• chore: port .simple() matching for TypedMatcher (#4612) by @benfdking in #2654
• chore: port Databricks Unity Catalog support (#4568) by @benfdking in #2655
• chore: port BigQuery WINDOW parsing fix (#4629) by @benfdking in #2656
• fix(lsp): respect workspace config and sqruffignore by @gvozdvmozgu in #2651
• chore: bump docker/setup-qemu-action from 4.0.0 to 4.1.0 by @dependabot[bot] in #2660
• chore: port TSQL CREATE EXTERNAL DATA SOURCE (#4634) by @mikills in #2666
• chore: bump npm dependencies by @benfdking in #2669
• chore: bump CodSpeedHQ/action from 4.15.1 to 4.17.0 by @dependabot[bot] in #2659
• chore: bump starlette from 0.51.0 to 1.0.1 in the uv group across 1 directory by @dependabot[bot] in #2668
• chore: port MySQL bracketed SELECT in CREATE/ALTER VIEW (#4655) by @mikills in #2667
• chore: port TSQL PERIOD FOR SYSTEM_TIME for temporal tables (#4654) by @mikills in #2670
• chore: port TSQL sqlcmd commands :r and :setvar (#4653) by @mikills in #2671
• chore: bump Rust toolchain to 1.96.0 by @benfdking in #2679
• chore: port Greenplum dialect (#4661) by @mikills in #2673
• feat(postgres): add identity/schema niladic functions to bare_functions by @skyf0l in #2677
• chore: bump actions/checkout from 6.0.2 to 6.0.3 by @dependabot[bot] in #2690
• chore: bump cargo dependencies (configparser, ignore, log, serde_with) by @benfdking in #2695
• chore: bundle npm dep bumps (prettier, react, typescript-eslint, vite) by @benfdking in #2696
• chore: bump prettier from 3.8.3 to 3.8.4 by @dependabot[bot] in #2688
• chore: port TSQL CREATE EXTERNAL FILE FORMAT (#4647) by @mikills in #2674
• fix(ci): expose hermetic pytest venv site-packages via PYTHONPATH by @mikills in #2701
• chore: port TSQL CREATE EXTERNAL TABLE (#4642) by @mikills in #2675
• chore: add validation for SQLFluff SHA advancement in prs by @benfdking in #2703
• chore: advance SQLFluff SHA past RF06 prefer_quoted_keywords (#4396) by @benfdking in #2704
• chore: port TSQL OPENJSON() (#4652) by @mikills in #2680
• chore: advance SQLFluff SHA past LT07 templated WITH clause fix (4671) by @benfdking in #2705
• chore: mark AL05 is_alias_required as no-op port (4673) by @benfdking in #2706
• chore: mark Postgres untyped OVERLAPS as already-ported (4674) by @benfdking in #2707
• chore: advance sqlfluff SHA for ClickHouse [LEFT] ARRAY JOIN (#4618) by @benfdking in #2708
• chore: advance sqlfluff-sha for LT03 & LT04 performance shortcuts (#4672) by @benfdking in #2709
• chore: bump esbuild from 0.27.4 to 0.28.1 in /editors/code in the npm_and_yarn group across 1 directory by @dependabot[bot] in #2712
• Add pnpm lockfile validation check to Bazel build by @benfdking in #2715
• chore: skip SQLFluff keyword error-message improvement (4676) by @benfdking in #2710
• chore: bump SQLFluff SHA to 2.0.3 release (4663) by @benfdking in #2718
• chore: make version number an argument in release script (#4677) by @benfdking in #2719
• chore: bump SQLFluff SHA for Snowflake EXECUTE TASK (#4683) by @benfdking in #2720
• chore: bump sqlfluff SHA for Snowflake ALTER TABLE column SET/UNSET TAG (#4682) by @benfdking in #2721
• chore: skip persist-timing fix/format CLI option, bump sqlfluff-sha (#4679) by @benfdking in #2722
• chore: skip safety valve for fixes in CV03, bump sqlfluff-sha (#4685) by @benfdking in #2723
• feat: port MySQL RETURN statement (#4693) by @mikills in #2681
• Enable CI workflow for merge queue events by @benfdking in #2726
• ci: Optimize Bazel cache strategy for main branch pushes by @benfdking in #2727
• chore(ci): pin maturin and migrate free-threaded wheels to 3.14t by @mikills in #2729
• chore: port capitalisation rules ignore-templated-only-if-configured (#4697) by @mikills in #2682
• chore: check for existing port before creating branch in next-sqlfluff skill by @benfdking in #2734
• chore: port Jinja import/from-as-templated tracer change (#4696) by @benfdking in #2733
• ci: add bazel test verifying uv.lock is up to date by @benfdking in #2731
• feat: add a none output format option (#4704) by @benfdking in #2736
• chore: advance sqlfluff SHA for CV06 empty-file handling (#4709) by @benfdking in #2737
• chore: advance .sqlfluff-sha past zero-length template segment change (#4708) by @benfdking in #2738
• feat: MySQL CREATE/ALTER VIEW may take UNION (#4713) by @benfdking in #2739
• chore: advance .sqlfluff-sha for newline-on-write (#4703) by @benfdking in #2740
• chore: advance .sqlfluff-sha for LT01 templated spacing (#4698) by @benfdking in #2743
• chore: update dependencies in playground and workspace by @benfdking in #2745
• chore: advance .sqlfluff-sha for AM02 fix-compatible (#4714) by @benfdking in #2746
• chore: advance .sqlfluff-sha for already-ported Snowflake sample variable (#4712) by @benfdking in #2749
• chore: advance .sqlfluff-sha to Snowflake integration params refactor (#4705) by @benfdking in #2756
• chore: align JJ01 docstring code-block language with SQLFluff (#4695) by @benfdking in #2757
• chore: bump CodSpeedHQ/action from 4.17.0 to 4.17.5 by @dependabot[bot] in #2750
• fix(sqlite): support bind parameters so >= isn't split before @param by @mikills in #2759
• chore: advance .sqlfluff-sha to SparkSQL distinct comparison operator (4719) by @benfdking in #2760
• fix(reflow): don't split operators inside unparsable sections by @mikills in #2762
• chore: advance .sqlfluff-sha to PG DROP/REASSIGN OWNED statements (4720) by @benfdking in #2761
• chore: bump pyo3 from 0.28.3 to 0.29.0 in the cargo group across 1 directory by @dependabot[bot] in #2711
• chore: advance .sqlfluff-sha for SparkSQL file literal lexing (#4718) by @benfdking in #2763
• chore: bump pyjwt from 2.10.1 to 2.13.0 in the uv group across 1 directory by @dependabot[bot] in #2764
• chore: advance .sqlfluff-sha to SparkSQL CREATE EXTERNAL TABLE (#4692) by @benfdking in #2765
• chore: bump regex from 1.12.3 to 1.12.4 by @dependabot[bot] in #2751
• chore: advance .sqlfluff-sha for already-ported PG PUBLICATION stmts (4716) by @benfdking in #2767
• chore: advance sqlfluff sha for SparkSQL window frame bounds (#4722) by @benfdking in #2769
• chore: bump the uv group across 1 directory with 2 updates by @dependabot[bot] in #2766
• chore: advance .sqlfluff-sha for Indent Aliases (4706) by @benfdking in #2771
• chore: bump secretlint deps to 13.0.2 by @benfdking in #2768
• chore: bump the uv group across 1 directory with 2 updates by @dependabot[bot] in #2770
• chore: bump vscode-languageclient and vscode-languageserver to 10.0.0 by @benfdking in #2773
• chore: update documentation links in default config by @benfdking in #2774
• chore: port LT02 reindent templated-line bounds-check test (4707) by @benfdking in #2772
• chore: advance sqlfluff sha for Spark Iceberg DDL (4690) by @benfdking in #2775
• fix: RF02 flags unqualified references in correlated subqueries (#2598) by @benfdking in #2744
• chore: advance sqlfluff-sha for PG SET ROLE / RESET ROLE (4734) by @benfdking in #2776
• chore: bump sqlfluff-sha for CREATE/DROP CAST statements (4744) by @benfdking in #2777
• chore: advance sqlfluff SHA for already-ported PG DML-in-CTE change (4741) by @benfdking in #2778
• chore: advance sqlfluff-sha past already-ported Athena MAP type fix (4739) by @benfdking in #2794
• fix(reflow): avoid LT05 panic on templated newlines by @mikills in #2779
• chore: advance sqlfluff-sha past CHAR VARYING for PG (4738) by @benfdking in #2795
• chore: advance sqlfluff-sha for postgres drop multiple views (4736) by @benfdking in #2797
• chore: advance sqlfluff-sha for CREATE SCHEMA AUTHORIZATION port (4735) by @benfdking in #2798
• chore: bump the uv group across 1 directory with 2 updates by @dependabot[bot] in #2796
• chore: keep out zero length keywords from dialect keyword sets (4723) by @benfdking in #2799
• chore: bump CodSpeedHQ/action from 4.17.5 to 4.17.6 by @dependabot[bot] in #2789
• chore: bump typescript-eslint from 8.61.0 to 8.61.1 by @dependabot[bot] in #2785
• chore: bump rust-lang/crates-io-auth-action from 1.0.4 to 1.0.5 by @dependabot[bot] in #2788
• chore: bump actions/checkout from 6.0.3 to 7.0.0 by @dependabot[bot] in #2790
• chore: port MySQL improved interval expressions (#4746) by @benfdking in #2800
• chore: bump @vscode/test-electron from 2.5.2 to 3.0.0 by @dependabot[bot] in #2784
• chore: advance sqlfluff SHA for PG SET on/integers port (#4740) by @benfdking in #2801
• chore: bump SQLFluff SHA for DROP multiple indexes in PG (4737) by @benfdking in #2802
• chore: bump SQLFluff SHA for EXCLUDE table constraints in PG (4725) by @benfdking in #2803
• chore: bump SQLFluff SHA for SparkSQL GROUP BY clause fix (4732) by @benfdking in #2804
• chore: advance sqlfluff-sha past "Indents on window functions" (4560) by @benfdking in #2805
• chore: advance sqlfluff SHA past docs-only starter config (#4702) by @benfdking in #2806
• chore: advance sqlfluff-sha for SparkSQL CREATE TABLE clause ordering (#4721) by @benfdking in #2807
• chore: advance .sqlfluff-sha for PG array accessor expressions (4748) by @benfdking in #2808
• chore: advance sqlfluff-sha for PG VACUUM statement (#4742) by @benfdking in #2809
• chore: advance sqlfluff SHA — Expression_A/B tilde grammar already ported (4717) by @benfdking in #2810
• chore: bump log, itertools, and minijinja by @benfdking in #2812
• chore: bump @playwright/test from 1.60.0 to 1.61.0 by @benfdking in #2813
• feat: SparkSQL improvements to lateral view, hints, sort by (#4731) by @benfdking in #2811
• chore: advance tracked SQLFluff SHA past 2.0.4 release prep (#4730) by @benfdking in #2814
• feat: recognize quoted data types in tsql create table (#4747) by @benfdking in #2815
• chore: advance tracked SQLFluff SHA past "Don't be too eager on window functions" by @benfdking in #2816
• chore: advance sqlfluff-sha for PG common-segment refactor (#4726) by @benfdking in #2817
• chore: advance sqlfluff-sha past 2.0.5 release prep (#4756) by @benfdking in #2818
• chore: port end-of-file > end_of_file rule rename (4753) by @benfdking in #2819
• chore: advance sqlfluff-sha to LT01 templated-newline fix (4757) by @benfdking in #2820
• fix: preserve postgres named constraint indentation by @mtibben in #2782
• chore: enable jinja templater for ignored rule fixtures that pass by @benfdking in #2822
• chore: bump actions/setup-python from 6.2.0 to 6.3.0 by @dependabot[bot] in #2826
• chore: bump @vscode/test-web from 0.0.80 to 0.0.81 by @dependabot[bot] in #2833
• fix: templated layout false positives in Jinja regions by @mikills in #2824
• chore: bump lsp-server to 0.8.0 by @benfdking in #2835
• fix: add CV10 templated literal parity by @mikills in #2834
• chore: combine pnpm dependabot updates by @benfdking in #2836
• chore: bump CodSpeedHQ/action from 4.17.6 to 4.18.1 by @dependabot[bot] in #2827
• chore: bump actions/attest-build-provenance from 4.1.0 to 4.1.1 by @dependabot[bot] in #2825
• fix: support sqruff TOML config files by @mikills in #2838
• perf(parser): avoid hashing the whole templated file per parent marker by @naamanhirschfeld-armis in #2839
• fix: preserve ANSI reference column list spacing by @benfdking in #2823
• chore: speed up bazel cargo test by @benfdking in #2840
• chore: update to rust to 1.96.1 by @benfdking in #2841
• chore: port LT02 reindent max() fix test case (#4752) by @benfdking in #2821
• chore: sync SQLFluff SHA for greedy-matcher removal (4761) by @benfdking in #2843
• chore: advance sqlfluff-sha past already-ported comment indent match (4758) by @benfdking in #2844
• chore: move dialect config tests to fixtures by @benfdking in #2842
• chore: advance sqlfluff SHA past comments-after-end-of-line fix (4760) by @benfdking in #2845
• chore: advance sqlfluff-sha past hive SET syntax (4763) by @benfdking in #2846
• chore: bump version to 0.39.0 by @benfdking in #2847

New Contributors

• @fengfeng-zi made their first contribution in #2580
• @wyatt-herkamp made their first contribution in #2653
• @mikills made their first contribution in #2666
• @skyf0l made their first contribution in #2677
• @mtibben made their first contribution in #2782
• @naamanhirschfeld-armis made their first contribution in #2839

Full Changelog: v0.38.0...v0.39.0