sqlfluff/sqlfluff 3.4.0

[3.4.0] - 2025-04-17

on GitHub

Highlights

This release brings a couple of breaking changes:

• We have dropped support for Python 3.8
• We have a new rule: LT15 (layout.newlines). This rule allows you to control the number of consecutive
  blank lines both inside, and outside of queries.

We also have a host of dialect improvements, bugfixes, and general code clean-up. This release has 79 contributions in it!

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

What’s Changed

• Clickhouse: support more complex types and functions in table definition (#6804) @LSturtew
• feat: Add possibility to set dbt project_dir as environment variable (#6737) @svdimchenko
• Add support for ZEROFILL columns in MySQL. (#6735) @joaostorrer
• RF02: Add config for ignoring external references found in subqueries (#6791) @keraion
• Fix CREATE TABLE statements in Redshift. (#6808) @joaostorrer
• Improve support for CREATE USER statements in Oracle. (#6809) @joaostorrer
• Add support for the WITH clause for an OPENROWSET in T-SQL (#6810) @rayz90
• Add hybrid tables to Snowflake dialect (#6812) @moreaupascal56
• Trino Dialect - Parse UNNEST (...) WITH ORDINALITY (#6813) @rileymcdowell
• Adds support for varchar(max) in Redshift. (#6806) @joaostorrer
• BigQuery: Make select replace AS not optional (#6780) @keraion
• CI: Update add-to-release-notes to use ubuntu-latest (#6798) @keraion
• CI: mirror image deployment to ghcr.io (#6790) @keraion
• add ERROR_INTEGRATION to AlterPipeSegment (#6796) @moreaupascal56
• Housekeeping: snowflake use CommentEqualsClauseSegment everywhere (#6795) @moreaupascal56
• Allow quoted charset identifiers for MySQL/MariaDB (#6781) @pprkut
• Fix reserved keywords in Postgres. (#6782) @joaostorrer
• Adds support for user defined datatypes in Redshift. (#6783) @joaostorrer
• improve alter table statement handling for clickhouse dialect (#6787) @LSturtew
• Athena: Support some Trino-based v3 functions (#6788) @keraion
• SparkSQL/Databricks: Support dot sign operator (#6789) @keraion
• RF02: do not trigger on snowflake lambda anonymous parameters (#6689) @shervinmathieu
• Adding additional object to grant statement in snowflake dialect (#6779) @SteveFrensch
• Adds support for +=, -=, *=, /= and %= operators in tsql. (#6756) @joaostorrer
• ST11: Fix quoted table name comparisons (#6768) @keraion
• Formatter Stub Types (#6761) @alanmcruickshank
• CP02, LT01: Fix duplicated elements generated from a FixPatch ordering conflict (#6769) @keraion
• Added support for geospatial data for MySQL (#6765) @AidanHarveyNelson
• Adds support for identity clause in CREATE TABLE and ALTER TABLE statements in Oracle. (#6767) @joaostorrer
• Fix PivotSegment to accept alias in FunctionSegment in Oracle. (#6766) @joaostorrer
• New Rule: LT15 (#6641) @WittierDinosaur
• Additional cleanup for python 3.9 (#6758) @keraion
• feat(snowflake): allow reference variables in create task (#6759) @mrlannigan
• Always use utf-8 encoding for toml files (#6760) @keraion
• Fix rule failures for MySQL/MariaDB with backticked identifiers (#6702) @pprkut
• ON CONFLICT indentation for Postgres (#6660) @WillMatthews
• Update release instructions (#6751) @alanmcruickshank
• Add support for Oracle PL/SQL (Procedures, Functions, Packages, Triggers, Types, Cursors, Loops) (#6635) @joaostorrer
• Tighter typing of Rule configs (#6750) @alanmcruickshank
• Fix: column aliases should find the topmost alias (#6755) @keraion
• AM08: Handle any-cased UNNEST (#6757) @keraion
• Python 3.9+ Type simplifications (#6745) @alanmcruickshank
• Snowflake dynamic table fixes (#6748) @ulixius9
• Update TSQL Execute Statement for Expressions (#6744) @nathanthorell
• Duckdb: Adding InsertStatementSegment for Duckdb specifics (#6740) @nathanthorell
• Drop support for Python 3.8 (#6743) @WittierDinosaur
• Fix tox config so that it supports spaces in the path name (#6726) (#6727) @maxgrenderjones
• BigQuery: support UNION ALL BY NAME and other new set operator modifiers (#6722) @Robin-C
• Fill in gap in parsing create user rsa_public_key=... / snowflake (#6731) @juli4nb4dillo
• Adds support for partition options in ALTER TABLE statements in MySQL. (#6742) @joaostorrer
• Update oracle reserved keywords. (#6730) @joaostorrer
• Add support in TSQL for Open Symmetric Key (#6736) @nathanthorell
• Cleaning: Remove Todo set tag from Snowflake ALTER TABLE statement (#6738) @moreaupascal56
• SparkSQL: Make colon optional in STRUCT datatype (#6739) @NormallyGaussian
• Redshift: Support GROUP BY ALL (#6714) @WittierDinosaur
• Fix tests with Click 8.2 (#6706) @cjwatson
• Remove USER from reserved words in Postgres. (#6707) @joaostorrer
• Add support for key: value syntax in functions in Postgres. (#6708) @joaostorrer
• Fill in Gap in Snowflake DROP DYNAMIC TABLE (#6673) @LoganPrice344
• Fill in Gap in Snowflake ALTER TABLE Parsing (#6654) @LoganPrice344
• Fill in Gap in Snowflake CREATE AUTHENTICATION POLICY Parsing (#6685) @LoganPrice344
• Adds support for JoinClauseSegment in DeleteStatementSegment in Postgres (#6692) @joaostorrer
• Fix check constraints in ALTER TABLE statements in Oracle. (#6661) @joaostorrer
• Add support for Obevo annotations. (#6662) @joaostorrer
• Add support for DEFAULT keyword as function parameter in tsql. (#6663) @joaostorrer
• Fill in gap in DECLARE Syntax (#6665) @LoganPrice344
• AL03: Lint for missing aliases on subqueries (#6666) @keraion
• IN TABLE/CTE and implicit Array, Tuple support for ClickHouse (#6667) @pheepa
• ST11: Fix rule name in documentation for noqa (#6668) @keraion
• Fill in Gap in Snowflake ALTER TABLE Parsing (#6671) @LoganPrice344
• Allows Snowflake CREATE ROW ACCESS POLICY to Parse Quoted Policy Names (#6648) @LoganPrice344
• Add support for EVENT statements in MySQL. (#6646) @joaostorrer
• Fill in Gap in Snowflake Exception Parsing (#6645) @LoganPrice344
• Snowflake: Add TITLE parameter support in CREATE STREAMLIT statement (#6642) @kawashiro
• TSQL: Add support for OPENQUERY (#6640) @nathanthorell
• Snowflake: Add support for CORTEX SEARCH SERVICE (#6639) @sfc-gh-amauser
• Add support for WithCompoundStatementSegment in procedures in Postgres (#6632) @joaostorrer
• Add support for SET NEW.<column> statements in MySQL. (#6634) @joaostorrer
• feat: Add missing parquet file format keywords to SF dialect (#6638) @jjlkant