[3.4.1] – 2025-06-13

Highlights

• This is primarily a bugfix, rule enhancement, and dialect enhancement release.
• We also have done some light refactoring of the internal codebase.

This release has 80 contributions in it!

Also, welcome to the fourteen new contributors! Thanks for your contributions!

What’s Changed

• Adds support for RETURNING INTO clause in INSERT, UPDATE, DELETE and MERGE statements in Oracle. (#6941) @joaostorrer
• converted large_file_skip_byte_limit value to integer before comparison, fixes Issue #6847 (#6848) @M-van-alten-BW
• Feat: Support explode in sparksql lateral clauses (#6875) @ShaneMazur
• Trino: Support for INSERT, COMMIT, ROLLBACK and SET SESSION statements (#6928) @ykicisk
• feat(redshift): add support for ALTER TABLE SET LOCATION syntax (#6936) @studansp
• TSQL: fix USER (bare function) unparsable (#6935) @keen85
• TSQL: add support for SECURITY POLICY (CREATE, ALTER, DROP) (#6937) @keen85
• CI: update coverage paths for C: directory (#6938) @keraion
• Adds support for column list after table name in COLLECT STATISTICS (#6896) @thomascjohnson
• Adds support for trigger predicates in IF statements and :NEW. variables in assignment statements in Oracle. (#6930) @joaostorrer
• Adds support for operator in MySQL. (#6929) @joaostorrer
• CLI: Read inline configurations when using --stdin-filename (#6900) @keraion
• Refactor Bracketed (#6827) @WittierDinosaur
• cli: Enable --disregard-sqlfluffignores for fix and format (#6885) @keraion
• Improves support for SET statements in MySQL. (#6922) @joaostorrer
• RF01: Fix quoted object references with dots (#6923) @keraion
• LT14: Add exclusion configuration option (#6909) @keraion
• Duckdb: Support double equals comparison (#6924) @keraion
• Fix mypy 1.16 issues (#6920) @keraion
• Databricks: Prevent parsing error when reading from a streaming file (#6910) @cpwithers
• dbup style variables into placeholder templater (#6852) @dreik
• Postgres: Add support for session authorization (#6903) @pierrand
• Redshift: Fix documentation link (#6901) @joaonunesk
• ST05: Ignore table_expressions that aren’t bracketed (#6883) @keraion
• Pin to Click < 8.3.0 (#6892) @wyardley
• Fix RawFileSlice idx and tags in lexer_test (#6890) @keraion
• CV12: fix assertion on bracketed join (#6898) @keraion
• Redshift: Add support for Kafka external schema (#6899) @pierrand
• Adds support for variadic declarations in Postgres. (#6887) @joaostorrer
• Adds support for Teradata CREATE TABLE with MAP option (#6895) @thomascjohnson
• MySQL: Add collate expressions (#6886) @keraion
• Add support for PRIVATE MATERIALIZED VIEW syntax to databricks dialect (#6882) @TheCleric
• CI: Ignore mypy call-arg for CliRunner mix_stderr (#6884) @keraion
• Postgres / Redshift: Add support for prepared statement (#6874) @pierrand
• Add support for Snowflake LOAD_UNCERTAIN_FILES (#6879) @mxr
• Update the Dockerfile to use Python 3.12 (#6876) @keraion
• TSQL: Support named windows (#6869) @WittierDinosaur
• Postgres: Support Security Label (#6868) @WittierDinosaur
• Bigquery: Support Pipe statements (#6870) @WittierDinosaur
• LT01: Brackets should touch datatypes (#6867) @keraion
• chore: Clean up OptionallyDelimited workarounds in Snowflake (#6866) @WittierDinosaur
• Add pgvector operators (#6863) @reteps
• Add support for OFFSET to ANSI and POSTGRES dialect (#6862) @reteps
• Terminate SELECT with ON CONFLICT (#6864) @reteps
• feat(snowflake): add support for ‘DROP ICEBERG TABLE’ statement (#6860) @VishalSinha1103
• SQLite: allow trailing unsigned (#6856) @covracer
• Fixes Oracle parsing tree with / operator. (#6853) @joaostorrer
• OptionallyDelimited Grammar (#6837) @WittierDinosaur
• TSQL: Add support for JSON_ARRAY and JSON_OBJECT (#6845) @nathanthorell
• Optimise CI test performance (#6829) @WittierDinosaur
• Snowflake: add EXTERNAL VOLUME and EXECUTE MANAGED TASK parameters to GRANT clause (#6839) @moreaupascal56
• Adds support for REMOVE DUPLICATES clause in merge statements in Redshift (#6841) @joaostorrer
• Redshift: Add support for select exclude syntax (#6838) @pierrand
• Snowflake: Create Network Policy Network Rule List (#6835) @WittierDinosaur
• Snowflake: Full support of resource monitors (#6834) @WittierDinosaur
• Remove AliasedObjectReferenceSegment (#6833) @WittierDinosaur
• Postgres: Fix RETURNING Select terminator (#6832) @WittierDinosaur
• Trino: Better support for CreateTable (#6831) @WittierDinosaur
• Snowflake: Support use_privatelink_endpoint (#6830) @WittierDinosaur
• CV12 rule to exclude APPLY clause from the rule (#6828) @paysni
• Set up Docker development environment (#6826) @WittierDinosaur
• Feat: Snowflake, Add catalog integration & create iceberg table (#6793) @moreaupascal56
• Snowflake: Add create API INTEGRATION support (#6815) @moreaupascal56

Source: https://github.com/sqlfluff/sqlfluff/releases/tag/3.4.1