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-native format 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: UPDATE and RETURNING clauses (#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-native format 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