Sqlfluff

Highlights

This release primarily fixes an issue introduced by the recent dbt 1.7.14 release,
and better support for dbt 1.7+. It also includes a range of dialect improvements
and CLI refinements.

This release also includes the groundwork for linting the unrendered sections of
Jinja templates. More documentation on this will be released in due course when
it's ready for beta testing.

Thanks also to [padraic00](https://github.com/padraic00) &
[burhanyasar](https://github.com/burhanyasar) who made their first contributions
in this release. 🎉🎉🏆🎉🎉

What’s Changed

* [fix_clickhouse] Temporary Table Create AS SELECT [5843](https://github.com/sqlfluff/sqlfluff/pull/5843) [konnectr](https://github.com/konnectr)
* Bugfix: ST02 - Compare entire condition expression [5850](https://github.com/sqlfluff/sqlfluff/pull/5850) [WittierDinosaur](https://github.com/WittierDinosaur)
* Clichouse prewhere [5849](https://github.com/sqlfluff/sqlfluff/pull/5849) [konnectr](https://github.com/konnectr)
* BigQuery: Support missing DROP statements [5848](https://github.com/sqlfluff/sqlfluff/pull/5848) [kzosabe](https://github.com/kzosabe)
* BigQuery: various CREATE statements [5846](https://github.com/sqlfluff/sqlfluff/pull/5846) [greg-finley](https://github.com/greg-finley)
* BigQuery Alter Schema [5835](https://github.com/sqlfluff/sqlfluff/pull/5835) [greg-finley](https://github.com/greg-finley)
* Snowflake execute immediate from [5836](https://github.com/sqlfluff/sqlfluff/pull/5836) [greg-finley](https://github.com/greg-finley)
* Support dbt 1.7 [5842](https://github.com/sqlfluff/sqlfluff/pull/5842) [WittierDinosaur](https://github.com/WittierDinosaur)
* Postgres: Create extension cascade [5834](https://github.com/sqlfluff/sqlfluff/pull/5834) [greg-finley](https://github.com/greg-finley)
* Postgres: Add Support for PostGIS operators [5830](https://github.com/sqlfluff/sqlfluff/pull/5830) [burhanyasar](https://github.com/burhanyasar)
* Db2: Support additional CREATE INDEX options [5827](https://github.com/sqlfluff/sqlfluff/pull/5827) [keraion](https://github.com/keraion)
* Allow to align all siblings when respacing [5826](https://github.com/sqlfluff/sqlfluff/pull/5826) [borchero](https://github.com/borchero)
* BigQuery: Support EXECUTE IMMEDIATE [5820](https://github.com/sqlfluff/sqlfluff/pull/5820) [keraion](https://github.com/keraion)
* BigQuery: Support CREATE ROW ACCESS POLICY statement [5821](https://github.com/sqlfluff/sqlfluff/pull/5821) [kzosabe](https://github.com/kzosabe)
* Fix Jinja variant location correction [5814](https://github.com/sqlfluff/sqlfluff/pull/5814) [alanmcruickshank](https://github.com/alanmcruickshank)
* Test cases for linter fails. [5815](https://github.com/sqlfluff/sqlfluff/pull/5815) [alanmcruickshank](https://github.com/alanmcruickshank)
* BigQuery: Support nested BEGIN, Fix CREATE PROCEDURE OPTIONS [5816](https://github.com/sqlfluff/sqlfluff/pull/5816) [keraion](https://github.com/keraion)
* Bring multiple jinja variants through to the parser. [5794](https://github.com/sqlfluff/sqlfluff/pull/5794) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix placeholder labelling [5813](https://github.com/sqlfluff/sqlfluff/pull/5813) [alanmcruickshank](https://github.com/alanmcruickshank)
* Tighten up the return from .process() [5810](https://github.com/sqlfluff/sqlfluff/pull/5810) [alanmcruickshank](https://github.com/alanmcruickshank)
* BigQuery: Support CREATE MATERIALIZED VIEW AS REPLICA OF [5811](https://github.com/sqlfluff/sqlfluff/pull/5811) [kzosabe](https://github.com/kzosabe)
* BigQuery: Support OPTIONS in CREATE FUNCTION statement [5812](https://github.com/sqlfluff/sqlfluff/pull/5812) [kzosabe](https://github.com/kzosabe)
* TSQL: fix `ALTER TABLE ... SWITCH PARTITION` [5807](https://github.com/sqlfluff/sqlfluff/pull/5807) [keen85](https://github.com/keen85)
* SparkSQL: Add functions that use UNIT keywords [5806](https://github.com/sqlfluff/sqlfluff/pull/5806) [keraion](https://github.com/keraion)
* CLI: Add `--stdin-filename` option [5805](https://github.com/sqlfluff/sqlfluff/pull/5805) [keraion](https://github.com/keraion)
* TSQL: parse `CREATE/ALTER/DROP MASTER KEY` [5802](https://github.com/sqlfluff/sqlfluff/pull/5802) [keen85](https://github.com/keen85)
* Jinja Variant Configuration [5785](https://github.com/sqlfluff/sqlfluff/pull/5785) [alanmcruickshank](https://github.com/alanmcruickshank)
* Small refactor in jinja templater [5786](https://github.com/sqlfluff/sqlfluff/pull/5786) [alanmcruickshank](https://github.com/alanmcruickshank)
* BigQuery: Support FOR SYSTEM_TIME AS OF in CREATE TABLE CLONE statement [5798](https://github.com/sqlfluff/sqlfluff/pull/5798) [kzosabe](https://github.com/kzosabe)
* TSQL: support for `CREATE/ALTER PARTITION FUNCTION/SCHEME` [5793](https://github.com/sqlfluff/sqlfluff/pull/5793) [keen85](https://github.com/keen85)
* BigQuery: Support DEFAULT COLLATE segment [5790](https://github.com/sqlfluff/sqlfluff/pull/5790) [kzosabe](https://github.com/kzosabe)
* TSQL: support computed columns [5792](https://github.com/sqlfluff/sqlfluff/pull/5792) [keen85](https://github.com/keen85)
* Simplify one of the lexer methods [5788](https://github.com/sqlfluff/sqlfluff/pull/5788) [alanmcruickshank](https://github.com/alanmcruickshank)
* Improve light colour highlight [5784](https://github.com/sqlfluff/sqlfluff/pull/5784) [alanmcruickshank](https://github.com/alanmcruickshank)
* SparkSQL: Support TIMESTAMP_LTZ and TIMESTAMP_NTZ types [5783](https://github.com/sqlfluff/sqlfluff/pull/5783) [padraic00](https://github.com/padraic00)

New Contributors

* [padraic00](https://github.com/padraic00) made their first contribution in [#5783](https://github.com/sqlfluff/sqlfluff/pull/5783)
* [burhanyasar](https://github.com/burhanyasar) made their first contribution in [#5830](https://github.com/sqlfluff/sqlfluff/pull/5830)

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)

Highlights

This is primarily another hotfix release for 3.0.0. Specifically making sure the
deprecation warnings for `-f/--force` go to `stderr` rather than `stdout`. It also
includes two dialect improvements, one for Snowflake and one for T-SQL.

What’s Changed

* Snowflake: Support External Volumes [5684](https://github.com/sqlfluff/sqlfluff/pull/5684) [WittierDinosaur](https://github.com/WittierDinosaur)
* T-SQL: Support Reconfigure [5685](https://github.com/sqlfluff/sqlfluff/pull/5685) [WittierDinosaur](https://github.com/WittierDinosaur)
* CLI: Make `--force` deprecation print on stderr [5681](https://github.com/sqlfluff/sqlfluff/pull/5681) [keraion](https://github.com/keraion)

Highlights

This minor release is a hotfix to resolve a bug introduced affecting CLI exit codes
in the 3.0.0 release.

What’s Changed

* Fix 5673 [5676](https://github.com/sqlfluff/sqlfluff/pull/5676) [alanmcruickshank](https://github.com/alanmcruickshank)