Highlights

This release is primarily housekeeping, bugfixes and dialect improvements. More specifically:

• Resolving regressions in JJ01, filename extension handling and the treatment of unfixable/unparsable files, which have been noticed with recent releases.
• Resolving bugs in LT07 & LT12 which relate to jinja whitespace control.
• More robust support for arbitrary methods on the ref and source macros for the dbt templater.

There's also dialect improvements for BigQuery, TSQL, MySQL, MariaDB, Snowflake, DuckDB, Databricks, Postgres, Teradata, Exasol & Vertica.

We also saw six new contributors merge their first pull request as part of this release. Welcome to the project! 🎉🏆🎉

What’s Changed

• Postgres: Support walrus operator named arguments (#6299) @keraion
• TSQL: handle nested joins, RF01 better aliasing (#6300) @keraion
• Exclude Macros - Allow multiple paths. (#6221) @culpgrant
• Dededuplicate rule ignore docs (#6296) @alanmcruickshank
• Bugfix for LT07 with consumed newlines. (#6294) @alanmcruickshank
• Bugfix for LT12 with jinja whitespace consumption (#6292) @alanmcruickshank
• RF02: Ignore DECLARE variables in BigQuery (#6295) @keraion
• Bugfix for JJ01 in parallel mode (#6293) @alanmcruickshank
• Allow arbitrary attributes & methods for ThisEmulator (#6254) @mroy-seedbox
• RF05: Add table_aliases option (#6273) @keraion
• BigQuery: Add support for concatenating in EXECUTE IMMEDIATE (#6287) @keraion
• BigQuery: Add support for SET with system variables (#6288) @keraion
• Plugins: Migrate example plugin to pyproject.toml (#6286) @keraion
• TSQL: Add DATETRUC to date_part_function_name list (#6283) @paysni
• MySQL Alter table convert to character set (#6277) @greg-finley
• Remove dependency on coveralls. (#6284) @alanmcruickshank
• Test dbt Templater Plugin with dbt 1.9.0 (#6280) @edgarrmondragon
• AM06: Ignore array expressions in BigQuery (#6276) @keraion
• Add mariadb to issue labeler (#6278) @greg-finley
• BigQuery: Add GROUPING SETS clause (#6275) @keraion
• Snowflake: Support ARRAY types (#6272) @keraion
• Move most of the config validation settings out into rule bundles. (#6262) @alanmcruickshank
• Revise warnings with fixing unfixable files. (#6257) @alanmcruickshank
• Strict mypy on sqlfluff.core (#6246) @alanmcruickshank
• DuckDB: Add DROP MACRO (#6270) @keraion
• Added Support for Databricks SQL Notebook Cells (#6267) @gabepesco
• dbt templater pyproject.toml nits (#6268) @alanmcruickshank
• Add UTF8 support for identifiers in Vertica dialect (#6183) @troshnev
• Almost all of util up to strict typing (#6263) @alanmcruickshank
• Update link to diff-cover docs (#6256) @alanmcruickshank
• MySQL: AL09 handle double quoted identifiers (#6249) @keraion
• fix: complex file extensions discovery (#6228) @Clepech
• fix RF06 issue in postgres naked identifier regex (#6247) @fvankrieken
• Strict typing for sqlfluff.core.linter (#6240) @alanmcruickshank
• DuckDB: Fixed DatatypeSegment references (#6244) @keraion
• Postgres: Support SET with double quoted identifiers (#6243) @keraion
• Consolidate Teradata tests (#6241) @greg-finley
• RF02: Ignore alias references that are self-inner (#6242) @keraion
• Add additional CREATE TABLE support for Databricks (#6216) @pahunter90
• Complete the support for PIVOT in Snowflake dialect (#6217) @fpsebastiam
• Exasol - allow function calls in values clause (#6226) @stephnan
• Snowflake: Support defining virtual columns (#6237) @babak-l1
• Teradata order of VOLATILE and MULTISET (#6233) @greg-finley
• Remove duplicate timing columns from the timing records (#6229) @Tenzer
• Fix time travel clauses in Snowflake dialect (#6230) @fpsebastiam