Sqlfluff

- Update the scope of the settings to 'resource' for more granular settings. [Issue](https://github.com/sqlfluff/vscode-sqlfluff/issues/156)

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

New Contributors

* [VictorAtIfInsurance](https://github.com/VictorAtIfInsurance) made their first contribution in [#6362](https://github.com/sqlfluff/sqlfluff/pull/6362)
* [mchen-codaio](https://github.com/mchen-codaio) made their first contribution in [#6337](https://github.com/sqlfluff/sqlfluff/pull/6337)
* [PaulBurridge](https://github.com/PaulBurridge) made their first contribution in [#6377](https://github.com/sqlfluff/sqlfluff/pull/6377)
* [kursataktas](https://github.com/kursataktas) made their first contribution in [#6373](https://github.com/sqlfluff/sqlfluff/pull/6373)
* [simonhoerdumbonde](https://github.com/simonhoerdumbonde) made their first contribution in [#6390](https://github.com/sqlfluff/sqlfluff/pull/6390)

Highlights

This release is almost all dialect fixes and bugfixes. Notably also, this
release brings official python 3.13 support too (although most users should
not realise any differences).

We also saw **two** new contributors to the project. Welcome
[R3gardless](https://github.com/R3gardless)
& [brandonschabell](https://github.com/brandonschabell)! 🎉🎉🎉

What’s Changed

* Utilize a deepcopy of the config object when parsing files [6344](https://github.com/sqlfluff/sqlfluff/pull/6344) [brandonschabell](https://github.com/brandonschabell)
* Snowflake supports other literals in system functions [6355](https://github.com/sqlfluff/sqlfluff/pull/6355) [alanmcruickshank](https://github.com/alanmcruickshank)
* Snowflake: Un-reserve CURRENT_USER [6354](https://github.com/sqlfluff/sqlfluff/pull/6354) [alanmcruickshank](https://github.com/alanmcruickshank)
* tsql: handle additional primary/foreign key options in constraints [6347](https://github.com/sqlfluff/sqlfluff/pull/6347) [keraion](https://github.com/keraion)
* Add `DROP COLUMN` support for multiple dialects [6348](https://github.com/sqlfluff/sqlfluff/pull/6348) [keraion](https://github.com/keraion)
* TSQL: allow `UPDATE` to be a function name [6349](https://github.com/sqlfluff/sqlfluff/pull/6349) [keraion](https://github.com/keraion)
* tsql: allow both on delete and on update in a `reference_constraint` [6346](https://github.com/sqlfluff/sqlfluff/pull/6346) [keraion](https://github.com/keraion)
* Postgres : Allow Extensions with Special Characters in Name [6345](https://github.com/sqlfluff/sqlfluff/pull/6345) [R3gardless](https://github.com/R3gardless)
* Fix `tox` command in test/fixtures/dialects/README.md [6342](https://github.com/sqlfluff/sqlfluff/pull/6342) [R3gardless](https://github.com/R3gardless)
* Revise dbt warnings when a file fails to compile [6338](https://github.com/sqlfluff/sqlfluff/pull/6338) [alanmcruickshank](https://github.com/alanmcruickshank)
* Postgres: Add `CREATE FOREIGN DATA WRAPPER` statement [6335](https://github.com/sqlfluff/sqlfluff/pull/6335) [keraion](https://github.com/keraion)
* Trino: Add some support to `json_query` functions [6336](https://github.com/sqlfluff/sqlfluff/pull/6336) [keraion](https://github.com/keraion)
* Handle deprecation warning of "fork" [6332](https://github.com/sqlfluff/sqlfluff/pull/6332) [alanmcruickshank](https://github.com/alanmcruickshank)
* Python 3.13 support and make it default for test coverage [6269](https://github.com/sqlfluff/sqlfluff/pull/6269) [alanmcruickshank](https://github.com/alanmcruickshank)
* ST06 - Fix union of CTE/Subquery [6298](https://github.com/sqlfluff/sqlfluff/pull/6298) [rogalski](https://github.com/rogalski)
* Refactor timestamp grammar [6331](https://github.com/sqlfluff/sqlfluff/pull/6331) [greg-finley](https://github.com/greg-finley)

New Contributors

* [R3gardless](https://github.com/R3gardless) made their first contribution in [#6342](https://github.com/sqlfluff/sqlfluff/pull/6342)
* [brandonschabell](https://github.com/brandonschabell) made their first contribution in [#6344](https://github.com/sqlfluff/sqlfluff/pull/6344)

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](https://github.com/nspcc-cm) & [rogalski](https://github.com/rogalski)
to the project!

What’s Changed

* BigQuery: Support Tuple syntax in other locations [6328](https://github.com/sqlfluff/sqlfluff/pull/6328) [keraion](https://github.com/keraion)
* Trino: Fix rule interactions with lambda functions [6327](https://github.com/sqlfluff/sqlfluff/pull/6327) [keraion](https://github.com/keraion)
* Resolve some more edge cases in LT02 [6324](https://github.com/sqlfluff/sqlfluff/pull/6324) [alanmcruickshank](https://github.com/alanmcruickshank)
* RF05 - fine tuning for snowflake dialect [6297](https://github.com/sqlfluff/sqlfluff/pull/6297) [rogalski](https://github.com/rogalski)
* Indentation: `UPDATE` and `RETURNING` clauses [6314](https://github.com/sqlfluff/sqlfluff/pull/6314) [keraion](https://github.com/keraion)
* Postgres: Fix lexing some JSON operators [6323](https://github.com/sqlfluff/sqlfluff/pull/6323) [keraion](https://github.com/keraion)
* Add support for `grant monitor on user ...` in Snowflake dialect [6322](https://github.com/sqlfluff/sqlfluff/pull/6322) [mroy-seedbox](https://github.com/mroy-seedbox)
* Exclude templated casts from CV11 [6320](https://github.com/sqlfluff/sqlfluff/pull/6320) [alanmcruickshank](https://github.com/alanmcruickshank)
* Snowflake allow double-quoted comments [6318](https://github.com/sqlfluff/sqlfluff/pull/6318) [greg-finley](https://github.com/greg-finley)
* Databricks materialized view [6319](https://github.com/sqlfluff/sqlfluff/pull/6319) [greg-finley](https://github.com/greg-finley)
* Allow double quotes to be escaped by writing twice [6316](https://github.com/sqlfluff/sqlfluff/pull/6316) [alanmcruickshank](https://github.com/alanmcruickshank)
* Resolve an oscillation bug with LT02 [6306](https://github.com/sqlfluff/sqlfluff/pull/6306) [alanmcruickshank](https://github.com/alanmcruickshank)
* Create a "Guides and Howtos" section of the docs. [6301](https://github.com/sqlfluff/sqlfluff/pull/6301) [alanmcruickshank](https://github.com/alanmcruickshank)
* Add groups to the `github-annotation-native` format option. [6312](https://github.com/sqlfluff/sqlfluff/pull/6312) [alanmcruickshank](https://github.com/alanmcruickshank)
* Snowflake: Support CTEs and multiple orders of CopyOptions in COPY INTO [6313](https://github.com/sqlfluff/sqlfluff/pull/6313) [keraion](https://github.com/keraion)
* Allow expressions in ORDER BY for clickhouse [6311](https://github.com/sqlfluff/sqlfluff/pull/6311) [alanmcruickshank](https://github.com/alanmcruickshank)
* Snowflake: support temp UDFs [6309](https://github.com/sqlfluff/sqlfluff/pull/6309) [rogalski](https://github.com/rogalski)
* fix: tsql create function syntax corrections [6289](https://github.com/sqlfluff/sqlfluff/pull/6289) [nspcc-cm](https://github.com/nspcc-cm)

New Contributors

* [nspcc-cm](https://github.com/nspcc-cm) made their first contribution in [#6289](https://github.com/sqlfluff/sqlfluff/pull/6289)
* [rogalski](https://github.com/rogalski) made their first contribution in [#6309](https://github.com/sqlfluff/sqlfluff/pull/6309)

Highlights

This is a hotfix release to resolve an issue with the JJ01 rule when running
in parallel mode.

What’s Changed

* Hotfix for JJ01 [6304](https://github.com/sqlfluff/sqlfluff/pull/6304) [alanmcruickshank](https://github.com/alanmcruickshank)
* Add note on 3.0.x to main docs page. [6302](https://github.com/sqlfluff/sqlfluff/pull/6302) [alanmcruickshank](https://github.com/alanmcruickshank)

- Silence notification when file/path is in `.sqlfluffignore`. [Issue](https://github.com/sqlfluff/vscode-sqlfluff/issues/155)