Sqlfluff

Highlights

This release contains one larger change, which is a big upgrade to case sensitivity in
the alias use rules. Also allowing the customisation of how SQLFluff uses case sensitivity
in rules like AL05. Beyond that, this also includes a handful of dialect improvements.

Thanks especially to [olshak](https://github.com/olshak), [MarkPaulin](https://github.com/MarkPaulin),
[mhoogendoorn](https://github.com/mhoogendoorn) & [kawashiro](https://github.com/kawashiro)
who made their first contributions in this release! 🚀

What’s Changed

* BigQuery: Support CREATE SNAPSHOT TABLE statement [5779](https://github.com/sqlfluff/sqlfluff/pull/5779) [kzosabe](https://github.com/kzosabe)
* Upgrades to release actions. [5774](https://github.com/sqlfluff/sqlfluff/pull/5774) [alanmcruickshank](https://github.com/alanmcruickshank)
* Improve Snowflake syntax support [5770](https://github.com/sqlfluff/sqlfluff/pull/5770) [kawashiro](https://github.com/kawashiro)
* TSQL: allow 'OR ALTER' on 'CREATE TRIGGER' [5772](https://github.com/sqlfluff/sqlfluff/pull/5772) [mhoogendoorn](https://github.com/mhoogendoorn)
* Enhancement: Improved Identifiers - casefolding, quoted values, and basic escaping [5726](https://github.com/sqlfluff/sqlfluff/pull/5726) [keraion](https://github.com/keraion)
* TSQL: Fix bare functions in default constraints [5771](https://github.com/sqlfluff/sqlfluff/pull/5771) [MarkPaulin](https://github.com/MarkPaulin)
* MySQL: Fix parsing 'ALTER TABLE ts ADD COLUMN modified_at TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP;' (5766) [5767](https://github.com/sqlfluff/sqlfluff/pull/5767) [olshak](https://github.com/olshak)


New Contributors
* [olshak](https://github.com/olshak) made their first contribution in [#5767](https://github.com/sqlfluff/sqlfluff/pull/5767)
* [MarkPaulin](https://github.com/MarkPaulin) made their first contribution in [#5771](https://github.com/sqlfluff/sqlfluff/pull/5771)
* [mhoogendoorn](https://github.com/mhoogendoorn) made their first contribution in [#5772](https://github.com/sqlfluff/sqlfluff/pull/5772)
* [kawashiro](https://github.com/kawashiro) made their first contribution in [#5770](https://github.com/sqlfluff/sqlfluff/pull/5770)

Highlights

This is a standard bugfix release bringing a bunch of dialect improvements and
bugfixes. Almost every dialect sees some improvements and it also includes
quality of life improvements to the CLI, pre-commit hooks, docs and several
rules.

Thanks also to the **eight** new contributors whose first contributions are
included in this release. 🎉🎉🏆🎉🎉

What’s Changed

* TSQL: Move PROPERTY to unreserved [5759](https://github.com/sqlfluff/sqlfluff/pull/5759) [WittierDinosaur](https://github.com/WittierDinosaur)
* Mysql: Add Character Set Literals [5755](https://github.com/sqlfluff/sqlfluff/pull/5755) [WittierDinosaur](https://github.com/WittierDinosaur)
* Snowflake: Support ASOF Joins [5756](https://github.com/sqlfluff/sqlfluff/pull/5756) [WittierDinosaur](https://github.com/WittierDinosaur)
* Mysql: Support scoped function calls [5757](https://github.com/sqlfluff/sqlfluff/pull/5757) [WittierDinosaur](https://github.com/WittierDinosaur)
* Postgres: Support pgvector vector type [5758](https://github.com/sqlfluff/sqlfluff/pull/5758) [WittierDinosaur](https://github.com/WittierDinosaur)
* SQLite: Support RETURNING Clause [5760](https://github.com/sqlfluff/sqlfluff/pull/5760) [WittierDinosaur](https://github.com/WittierDinosaur)
* Postgres: Allow return control structures in atomic functions [5761](https://github.com/sqlfluff/sqlfluff/pull/5761) [WittierDinosaur](https://github.com/WittierDinosaur)
* ST04: Retain comments when flattening `CASE` [5753](https://github.com/sqlfluff/sqlfluff/pull/5753) [keraion](https://github.com/keraion)
* dbt templater: Raise UserError when using stdin [5752](https://github.com/sqlfluff/sqlfluff/pull/5752) [keraion](https://github.com/keraion)
* SQLite: Add `GLOB`, `MATCH`. Improved `REGEXP` [5745](https://github.com/sqlfluff/sqlfluff/pull/5745) [keraion](https://github.com/keraion)
* Databricks: Fix Aliases for Join-like objects [5748](https://github.com/sqlfluff/sqlfluff/pull/5748) [keraion](https://github.com/keraion)
* Add missing README ref, and issues labels [5741](https://github.com/sqlfluff/sqlfluff/pull/5741) [WittierDinosaur](https://github.com/WittierDinosaur)
* Qual: Add pre-commit to CI [5730](https://github.com/sqlfluff/sqlfluff/pull/5730) [mdeweerd](https://github.com/mdeweerd)
* Added support for 'greater/less than or equal' on ANSI CASE statement [5728](https://github.com/sqlfluff/sqlfluff/pull/5728) [IliyanKostov9](https://github.com/IliyanKostov9)
* Remove `--force` flag from pre-commit hook definition [5739](https://github.com/sqlfluff/sqlfluff/pull/5739) [borchero](https://github.com/borchero)
* adding snake_case to CP01 extended_capitalisation_policy [5736](https://github.com/sqlfluff/sqlfluff/pull/5736) [alecsgonz](https://github.com/alecsgonz)
* ST04: Ignore simplifying `CASE`s with different expressions [5735](https://github.com/sqlfluff/sqlfluff/pull/5735) [keraion](https://github.com/keraion)
* Fix 5724 mysql: Allow Line comments without space after -- [5731](https://github.com/sqlfluff/sqlfluff/pull/5731) [mdeweerd](https://github.com/mdeweerd)
* Fix spelling [5729](https://github.com/sqlfluff/sqlfluff/pull/5729) [mdeweerd](https://github.com/mdeweerd)
* Fix implementation for view_column_name_list in BigQuery's CREATE VIEW [5738](https://github.com/sqlfluff/sqlfluff/pull/5738) [kzosabe](https://github.com/kzosabe)
* CLI: Suppress tracebacks on render/fix/format [5734](https://github.com/sqlfluff/sqlfluff/pull/5734) [keraion](https://github.com/keraion)
* Clickhouse: add parsing for select except clause [5725](https://github.com/sqlfluff/sqlfluff/pull/5725) [tojahech](https://github.com/tojahech)
* Add array type support to Trino dialect [5722](https://github.com/sqlfluff/sqlfluff/pull/5722) [kirkhansen](https://github.com/kirkhansen)
* Fix/snowflake unparsable tag in create stmt [5720](https://github.com/sqlfluff/sqlfluff/pull/5720) [mariq41](https://github.com/mariq41)
* Fix/snowflake ext storage [5714](https://github.com/sqlfluff/sqlfluff/pull/5714) [mariq41](https://github.com/mariq41)
* Clickhouse: add parsing for "distinct on" syntax [5716](https://github.com/sqlfluff/sqlfluff/pull/5716) [tojahech](https://github.com/tojahech)
* added refresh mode init on create table statement [5715](https://github.com/sqlfluff/sqlfluff/pull/5715) [IliyanKostov9](https://github.com/IliyanKostov9)
* added `ifNotExistsGrammar` to Snowflake procedure [5709](https://github.com/sqlfluff/sqlfluff/pull/5709) [IliyanKostov9](https://github.com/IliyanKostov9)
* Trino: 'TIMESTAMP(p)' no longer triggers LT01 [5711](https://github.com/sqlfluff/sqlfluff/pull/5711) [rileymcdowell](https://github.com/rileymcdowell)
* Snowflake: add support for streamlit [5692](https://github.com/sqlfluff/sqlfluff/pull/5692) [vgw-chriskruger](https://github.com/vgw-chriskruger)

New Contributors

* [vgw-chriskruger](https://github.com/vgw-chriskruger) made their first contribution in [#5692](https://github.com/sqlfluff/sqlfluff/pull/5692)
* [IliyanKostov9](https://github.com/IliyanKostov9) made their first contribution in [#5709](https://github.com/sqlfluff/sqlfluff/pull/5709)
* [tojahech](https://github.com/tojahech) made their first contribution in [#5716](https://github.com/sqlfluff/sqlfluff/pull/5716)
* [mariq41](https://github.com/mariq41) made their first contribution in [#5714](https://github.com/sqlfluff/sqlfluff/pull/5714)
* [kirkhansen](https://github.com/kirkhansen) made their first contribution in [#5722](https://github.com/sqlfluff/sqlfluff/pull/5722)
* [kzosabe](https://github.com/kzosabe) made their first contribution in [#5738](https://github.com/sqlfluff/sqlfluff/pull/5738)
* [mdeweerd](https://github.com/mdeweerd) made their first contribution in [#5729](https://github.com/sqlfluff/sqlfluff/pull/5729)
* [alecsgonz](https://github.com/alecsgonz) made their first contribution in [#5736](https://github.com/sqlfluff/sqlfluff/pull/5736)

Highlights

This is a standard minor release fixing a set of dialect issues with Trino, BigQuery,
Vertica and Snowflake.

Thanks to [maegan-canva](https://github.com/maegan-canva),
[rileymcdowell](https://github.com/rileymcdowell) &
[paysni](https://github.com/paysni) who made their first contributions in this release.

What’s Changed

* [TSQL] Create columnstore indexes [5708](https://github.com/sqlfluff/sqlfluff/pull/5708) [paysni](https://github.com/paysni)
* [Vertica] fix gaps for some datatypes, complex alias support, fix group by for DDL [5691](https://github.com/sqlfluff/sqlfluff/pull/5691) [PolitePp](https://github.com/PolitePp)
* BigQuery: Unreserve KEY keyword [5703](https://github.com/sqlfluff/sqlfluff/pull/5703) [greg-finley](https://github.com/greg-finley)
* Trino: Add INTEGER synonym of INT [5702](https://github.com/sqlfluff/sqlfluff/pull/5702) [rileymcdowell](https://github.com/rileymcdowell)
* Snowflake shouldn't reserve DO as a keyword. [5699](https://github.com/sqlfluff/sqlfluff/pull/5699) [alanmcruickshank](https://github.com/alanmcruickshank)
* Allow use of STREAM in snowflake CHANGES clause [5698](https://github.com/sqlfluff/sqlfluff/pull/5698) [alanmcruickshank](https://github.com/alanmcruickshank)
* Trino: Parse regexp_replace with lambda func [5683](https://github.com/sqlfluff/sqlfluff/pull/5683) [rileymcdowell](https://github.com/rileymcdowell)
* Documentation update: Remove reference to alias' default config being "consistent" [5689](https://github.com/sqlfluff/sqlfluff/pull/5689) [maegan-canva](https://github.com/maegan-canva)

New Contributors
* [maegan-canva](https://github.com/maegan-canva) made their first contribution in [#5689](https://github.com/sqlfluff/sqlfluff/pull/5689)
* [rileymcdowell](https://github.com/rileymcdowell) made their first contribution in [#5683](https://github.com/sqlfluff/sqlfluff/pull/5683)
* [paysni](https://github.com/paysni) made their first contribution in [#5708](https://github.com/sqlfluff/sqlfluff/pull/5708)

- Update changelog

- Add a status bar button that runs "Format document with sqlfluff"
- If dbt-core-interface is enabled in the extension
- The "fix" command should use dbt-core-interface /format endpoint
- The "format selection" action should also use dbt-core-interface /format endpoint

- Update for sqlfluff version 3.0.0.
- Add Vertica dialect.
- Removed `--force` from `fix` as it is the default for >= 3.0.0.