Sqlfluff

Highlights

This release makes a breaking change to the serialized output of the
CLI (and by extension, any of the serialized outputs of the API).

* The serialised output for `sqlfluff lint` now contains more information
about the span of linting issues and initial proposed fixes. Beside the *new*
fields, the original fields of `line_pos` and `line_no` have been
renamed to `start_line_pos` and `start_line_no`, to distinguish
them from the new fields starting `end_*`.

* The default `annotation_level` set by the `--annotation-level`
option on the `sqlfluff lint` command has been changed from `notice`
to `warning`, to better distinguish linting errors from warnings, which
always now have the level of `notice`. This is only relevant when using
the `github-annotation` or `github-annotation-native` formats.

What’s Changed

* Build out rule and fix serialisation [5364](https://github.com/sqlfluff/sqlfluff/pull/5364) [alanmcruickshank](https://github.com/alanmcruickshank)
* Add warning about github actions annotations limit [5450](https://github.com/sqlfluff/sqlfluff/pull/5450) [alanmcruickshank](https://github.com/alanmcruickshank)
* chore: remove unused line initialization in ParseContext [5448](https://github.com/sqlfluff/sqlfluff/pull/5448) [gvozdvmozgu](https://github.com/gvozdvmozgu)
* Refine CLI testing fixture [5446](https://github.com/sqlfluff/sqlfluff/pull/5446) [alanmcruickshank](https://github.com/alanmcruickshank)
* Update black linting [5447](https://github.com/sqlfluff/sqlfluff/pull/5447) [alanmcruickshank](https://github.com/alanmcruickshank)

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)