Highlights
This is another release of dialect improvements and rule bugfixes. Notably:
- More robust algorithms for the indentation of Jinja template tags in
LT02. - The
github-annotation-nativeformat option now has groups for each filename.
There’s also a refactor of where we guides and howtos in the docs. Keep an eye on that section going forward for more information about best practice and troubleshooting for SQLFluff.
Even in this small PR, we’ve seen two new contributors. Welcome @nspcc-cm & @rogalski to the project!
What’s Changed
- BigQuery: Support Tuple syntax in other locations (#6328) @keraion
- Trino: Fix rule interactions with lambda functions (#6327) @keraion
- Resolve some more edge cases in LT02 (#6324) @alanmcruickshank
- RF05 – fine tuning for snowflake dialect (#6297) @rogalski
- Indentation:
UPDATEandRETURNINGclauses (#6314) @keraion - Postgres: Fix lexing some JSON operators (#6323) @keraion
- Add support for
grant monitor on user ...in Snowflake dialect (#6322) @mroy-seedbox - Exclude templated casts from CV11 (#6320) @alanmcruickshank
- Snowflake allow double-quoted comments (#6318) @greg-finley
- Databricks materialized view (#6319) @greg-finley
- Allow double quotes to be escaped by writing twice (#6316) @alanmcruickshank
- Resolve an oscillation bug with LT02 (#6306) @alanmcruickshank
- Create a “Guides and Howtos” section of the docs. (#6301) @alanmcruickshank
- Add groups to the
github-annotation-nativeformat option. (#6312) @alanmcruickshank - Snowflake: Support CTEs and multiple orders of CopyOptions in COPY INTO (#6313) @keraion
- Allow expressions in ORDER BY for clickhouse (#6311) @alanmcruickshank
- Snowflake: support temp UDFs (#6309) @rogalski
- fix: tsql create function syntax corrections (#6289) @nspcc-cm
Source: https://github.com/sqlfluff/sqlfluff/releases/tag/3.2.3