sqlfluff/sqlfluff 3.3.1

[3.3.1] - 2025-02-05

on GitHub

Highlights

This is a bugfix release resolving a several issues from 3.3.0 and previously.

• Dialect improvements for Snowflake, Oracle, SQLite, BigQuery, TSQL, Databricks, SparkSQL, Hive, Trino & Postgres.
• Rule improvements for AL04, AM08, RF01, RF02, ST03, ST05, ST09, ST10, ST11.

This release also includes the first contributions from thirteen new contributors! Welcome to the project and thank you for your contributions. 🎉🎉🏆🏆🎉🎉

What’s Changed

• Update acronym ETL/ELT in README.md (#6500) @galenseilis
• Fill in Gap for Snowflake CREATE Syntax Parsing (#6514) @LoganPrice344
• Add support for PostGIS geometry(point) datatype. (#6543) @joaostorrer
• Allow double equals in hive dialect (#6623) @TheCleric
• Bump Python version in the docs and metadata (#6626) @WittierDinosaur
• Added support for Variable Substitution for Snowflake Target_lag (#6567) @LoganPrice344
• Sqlite: Added set_clause_list to UPDATE statement (#6605) @keraion
• Oracle: Support for NOMAXVALUE and NOMINVALUE (#6606) @keraion
• RF02: Handle additional edge cases with subqueries (#6607) @keraion
• TSQL Add Set Context_Info and Replicate function (#6613) @nathanthorell
• Add Support for Snowflake Variables (#6618) @LoganPrice344
• Add support for BigQuery LOAD DATA statement (#6612) @VMois
• CI: Update to black 25.1 and pre-commit hooks (#6615) @keraion
• Add support for psql \gset and \gexec meta commands. (#6555) @joaostorrer
• TSQL improve support for CREATE USER (#6608) @nathanthorell
• Add support for Postgres ALTER FOREIGN TABLE statement. (#6597) @joaostorrer
• Add zip and zip_strict dbt jinja2 functions (#6564) @boushphong
• TSQL: fix for hex default constraint (#6586) @nathanthorell
• Add support for Oracle SQL*Plus substitution variable &. (#6573) @joaostorrer
• ST11: Table and wildcard reference fixes (#6572) @keraion
• Adding support in TSQL for Create Login (#6570) @nathanthorell
• ST05: Ordering and rule conflict fixes (#6578) @keraion
• TSQL: Add WITH ROLLUP option for GROUP BY (#6579) @keraion
• ST03: Handle quotes in CTE names (#6591) @keraion
• ST09: Handle lt_eq_gt operator (#6592) @keraion
• AL04: Check for duplicates in subquery aliases and table references (#6593) @keraion
• TSQL: adds drop and add period to alter table (#6590) @nathanthorell
• [Starrocks] Support for generated columns (#6581) @maver1ck
• Fix TSQL OPENROWSET for ADLS use (#5114) (#6584) @rayz90
• Add support for Postgres CREATE OPERATOR syntax. (#6540) @joaostorrer
• Update postgres bare functions. (#6545) @joaostorrer
• Add Postgres DROP FOREIGN TABLE statement. (#6548) @joaostorrer
• Add support for Postgres full text search operator !!. (#6541) @joaostorrer
• Fix Snowflake Dynamic Table Parsing (#6566) @ulixius9
• add variable use in tsql TemporalQuerySegment (#6565) @nathanthorell
• Add support for Postgres functions with column referenced type and argmode between parameter name and datatype. (#6542) @joaostorrer
• add MariaDB to README.md (#6559) @robertsilen
• mypyc: workaround for ABC inheritance (#6552) @keraion
• Add DuckDB to RF01 filter for dialects with dot-access (#6554) @brunobeltran
• Fill in Gap in Snowflake ALTER TAG Syntax (#6531) @LoganPrice344
• Fill in Gap in CREATE ROW ACCESS POLICY Syntax Parsing (#6550) @LoganPrice344
• [docs] Update CONTRIBUTING.md virtual env setup instructions (#6538) @sarahmccuan
• Added logic to parse named row fields using reference operator (.) for trino dialect (#6536) @prabh-me
• SparkSQL dialect: Allow datatypes for column definition in create view statements (#6518) @KikeSenpai
• Fill in Gap for ALTER_TABLE_COLUMN Syntax Parsing (#6526) @LoganPrice344
• fix: databricks describe volume recognition (#6529) @benfdking
• Fill in Gap in Snowflake ALTER ROW ACCESS POLICY Syntax Parsing (#6534) @LoganPrice344
• Fill in Gap for Snowflake ALTER warehouse Syntax (#6516) @LoganPrice344
• [docs] Update missing convention whitespace for CV10 (#6528) @sarahmccuan
• Fill in gaps for GRANT syntax (#6520) @LoganPrice344
• Snowflake: allow multiple predecessor tasks in CREATE/ALTER TASK (#6510) @mrebaker
• AM08: fix edge cases (#6506) @rogalski
• ST10: Fix edge cases (#6505) @rogalski
• Snowflake - Fill in gaps in GRANT command parsing (#6503) @korverdev
• Add support for Snowflake's CREATE OR ALTER syntax (#6497) @korverdev
• TSQL dialect - Allow for multiple columns in ALTER TABLE DROP COLUMN statements (#6501) @korverdev