[3.2.5] – 2024-10-25

Highlights

This release is mostly bugfixes and dialect improvements. Notably:

• Whitespace handling improvements to LT01 & LT02.
• Better error messages around trying to iterate on missing jinja variables.
• Better case sensitivity for AL09.
• Improved handling of jinja context in inline config directives.
• Enabling AM02 for Trino and Snowflake.
• Handling potential collisions between ST02 & LT01.
• Preventing false positives in AL05 with arrays.

There’s also a bunch of documentation improvements in this release, including guides on how to troubleshoot SQLFluff and how to write custom rules. Check out https://docs.sqlfluff.com for more details.

We also saw five new contributors to the project this month. Welcome to the project, and thanks for taking the time to contribute! 🎉🏆🎉

What’s Changed

• Guides for custom rules and for troubleshooting (#6379) @alanmcruickshank
• Documentation and small overhaul of parametrized rule test cases (#6380) @alanmcruickshank
• TSQL: add missing unreserved keyword NULLS (#5212) (#6390) @simonhoerdumbonde
• Introducing SQLFluff Guru on Gurubase.io (#6373) @kursataktas
• Improve heuristics for inline config (#6391) @rogalski
• Postgres: Handle expressions that occur in IN functions (#6393) @keraion
• Snowflake: Support bracketed lambda functions without datatypes (#6394) @keraion
• LT01: Add default config for match_condition to touch (#6395) @keraion
• Snowflake: Allow for additional CONNECT BY expressions that may use PRIOR (#6396) @keraion
• Details on debugging and setup for diff-quality (#6381) @alanmcruickshank
• Fix edge case in Jinja reindents (#6383) @rogalski
• Support identifier clause for Databricks (#6377) @PaulBurridge
• Enable AM02 for snowflake and trino by default. (#6369) @mchen-codaio
• Postgres: Support identifiers in ALTER DATABASE SET (#6376) @keraion
• SparkSQL: Improved lexing and parsing of file literals (#6375) @keraion
• Fix Snowflake alter share (#6372) @greg-finley
• Resolve collision between ST02 and LT01 (#6366) @alanmcruickshank
• Prevent false positives with AL05 and array functions (#6365) @alanmcruickshank
• Handle iteration and getting undefined jinja variables (#6364) @alanmcruickshank
• Update documentation with new dialects (#6337) @mchen-codaio
• enable default values when creating databricks tables (#6362) @VictorAtIfInsurance
• Postgres : Add ALTER AGGREGATE Statement (#6353) @R3gardless
• Revise AL09 (self aliasing) – stricter case sensitivity (#6333) @alanmcruickshank
• Make dbt RelationEmulator safely callable (#6358) @mroy-seedbox

New Contributors

• @VictorAtIfInsurance made their first contribution in #6362
• @mchen-codaio made their first contribution in #6337
• @PaulBurridge made their first contribution in #6377
• @kursataktas made their first contribution in #6373
• @simonhoerdumbonde made their first contribution in #6390

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