Sqlfluff

Highlights

This brings no further _breaking_ changes on top of `3.0.0a2`, but instead
releases a few of the more minor fixes flowing through while other breaking
changes are staged in. In particular there are a few dialect improvements
for Snowflake, TSQL, SQLite and Databricks alongsids a few further
improvements to deployment scripts off the back of earlier changes for `3.x`.

What’s Changed

* fix assertion in `test__api__lint_string_specific_exclude_single` [5437](https://github.com/sqlfluff/sqlfluff/pull/5437) [gvozdvmozgu](https://github.com/gvozdvmozgu)
* Databricks CLUSTER BY and OPTIMIZE [5436](https://github.com/sqlfluff/sqlfluff/pull/5436) [greg-finley](https://github.com/greg-finley)
* TSQL: ON DELETE NO ACTION [5434](https://github.com/sqlfluff/sqlfluff/pull/5434) [greg-finley](https://github.com/greg-finley)
* Snowflake dynamic table [5435](https://github.com/sqlfluff/sqlfluff/pull/5435) [greg-finley](https://github.com/greg-finley)
* Support parsing CONSTRAINT definitions when creating Delta Live Tables in SparkSQL/Databricks [5438](https://github.com/sqlfluff/sqlfluff/pull/5438) [rocwang](https://github.com/rocwang)
* adds few fixes for databricks/sparksql [5431](https://github.com/sqlfluff/sqlfluff/pull/5431) [markbaas](https://github.com/markbaas)
* TSQL: CREATE USER {FOR|FROM} LOGIN [5426](https://github.com/sqlfluff/sqlfluff/pull/5426) [greg-finley](https://github.com/greg-finley)
* Snowflake Create table order/noorder [5421](https://github.com/sqlfluff/sqlfluff/pull/5421) [greg-finley](https://github.com/greg-finley)
* Simplify Snowflake regexes [5419](https://github.com/sqlfluff/sqlfluff/pull/5419) [greg-finley](https://github.com/greg-finley)
* Permit .* after each tbl_name in multi-table delete syntax [5408](https://github.com/sqlfluff/sqlfluff/pull/5408) [yoichi](https://github.com/yoichi)
* Fix snowflake add search optimization grant [5412](https://github.com/sqlfluff/sqlfluff/pull/5412) [jongracecox](https://github.com/jongracecox)
* ANSI: Allow combination of UNION clause and WITH clause [5413](https://github.com/sqlfluff/sqlfluff/pull/5413) [yoichi](https://github.com/yoichi)
* SQLite: Allow block comments to be terminated by end of input [5400](https://github.com/sqlfluff/sqlfluff/pull/5400) [WittierDinosaur](https://github.com/WittierDinosaur)
* Update publish github action to use kebab case [5392](https://github.com/sqlfluff/sqlfluff/pull/5392) [alanmcruickshank](https://github.com/alanmcruickshank)

New Contributors

* [jongracecox](https://github.com/jongracecox) made their first contribution in [#5412](https://github.com/sqlfluff/sqlfluff/pull/5412)
* [markbaas](https://github.com/markbaas) made their first contribution in [#5431](https://github.com/sqlfluff/sqlfluff/pull/5431)
* [rocwang](https://github.com/rocwang) made their first contribution in [#5438](https://github.com/sqlfluff/sqlfluff/pull/5438)
* [gvozdvmozgu](https://github.com/gvozdvmozgu) made their first contribution in [#5437](https://github.com/sqlfluff/sqlfluff/pull/5437)

Highlights

The initial 3.0.0a1 release failed to build a docker image, this resolves
that issue.

What’s Changed

* Update publish actions and Dockerfile. [5390](https://github.com/sqlfluff/sqlfluff/pull/5390) [alanmcruickshank](https://github.com/alanmcruickshank)

Highlights

This release makes a couple of potentially breaking changes:

* It drops support for python 3.7, which reached end of life in June 2023.

* It migrates to `pyproject.toml` rather than `setup.cfg` as the python
packaging configuration file (although keeping `setuptools` as the default backend).

Further breaking changes may be made as part of the full 3.0.0 release, but this
alpha release is designed to test the new packaging changes for any issues before
releasing a stable version.

What’s Changed

* Move the rest of pytest over to `pyproject.toml` [5383](https://github.com/sqlfluff/sqlfluff/pull/5383) [alanmcruickshank](https://github.com/alanmcruickshank)
* Move doc8 over to pyproject [5385](https://github.com/sqlfluff/sqlfluff/pull/5385) [alanmcruickshank](https://github.com/alanmcruickshank)
* Remove exceptions for typing stubs that now exist. [5382](https://github.com/sqlfluff/sqlfluff/pull/5382) [alanmcruickshank](https://github.com/alanmcruickshank)
* Migrate to `pyproject.toml` for the core project. [5373](https://github.com/sqlfluff/sqlfluff/pull/5373) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix the snippet from a pyproject.toml in configuration.rst [5378](https://github.com/sqlfluff/sqlfluff/pull/5378) [ishiis](https://github.com/ishiis)
* Snowflake: Support AlterNetworkPolicy Statements [5377](https://github.com/sqlfluff/sqlfluff/pull/5377) [WittierDinosaur](https://github.com/WittierDinosaur)
* postgres: add support for bodies of "language sql" functions [5376](https://github.com/sqlfluff/sqlfluff/pull/5376) [65278](https://github.com/65278)
* Add support for SET NAMES statement in MySQL [5374](https://github.com/sqlfluff/sqlfluff/pull/5374) [joaostorrer](https://github.com/joaostorrer)
* Fix GRANT ALL PRIVILEGES statement in MySQL [5375](https://github.com/sqlfluff/sqlfluff/pull/5375) [joaostorrer](https://github.com/joaostorrer)
* Another extraction of fixing logic. [5365](https://github.com/sqlfluff/sqlfluff/pull/5365) [alanmcruickshank](https://github.com/alanmcruickshank)
* Remove root requirements.txt [5372](https://github.com/sqlfluff/sqlfluff/pull/5372) [alanmcruickshank](https://github.com/alanmcruickshank)
* Drop support of python 3.7 [5288](https://github.com/sqlfluff/sqlfluff/pull/5288) [zhongjiajie](https://github.com/zhongjiajie)
* API configuration documentation [5369](https://github.com/sqlfluff/sqlfluff/pull/5369) [golergka](https://github.com/golergka)
* add listagg extras support in trino dialect [5368](https://github.com/sqlfluff/sqlfluff/pull/5368) [wjhrdy](https://github.com/wjhrdy)
* Allow ignoring of comments from indentation entirely 3311 [5363](https://github.com/sqlfluff/sqlfluff/pull/5363) [alanmcruickshank](https://github.com/alanmcruickshank)
* Trino: Support Analyze statements [5361](https://github.com/sqlfluff/sqlfluff/pull/5361) [WittierDinosaur](https://github.com/WittierDinosaur)
* Resolve 5327 (logging to stdout) [5362](https://github.com/sqlfluff/sqlfluff/pull/5362) [alanmcruickshank](https://github.com/alanmcruickshank)


New Contributors
* [wjhrdy](https://github.com/wjhrdy) made their first contribution in [#5368](https://github.com/sqlfluff/sqlfluff/pull/5368)
* [golergka](https://github.com/golergka) made their first contribution in [#5369](https://github.com/sqlfluff/sqlfluff/pull/5369)
* [65278](https://github.com/65278) made their first contribution in [#5376](https://github.com/sqlfluff/sqlfluff/pull/5376)
* [ishiis](https://github.com/ishiis) made their first contribution in [#5378](https://github.com/sqlfluff/sqlfluff/pull/5378)

- Switch DBT Osmosis to DBT Core Interface. Thanks to BAntonellini's [Pull Request](https://github.com/sqlfluff/vscode-sqlfluff/pull/111)

- Use uppercase drive letters on Windows. Thanks to mhahn-ts's [Pull Request](https://github.com/sqlfluff/vscode-sqlfluff/pull/111)

- Show context menu items by default.
- Always allow for commands to show on enabled languages.