Sqlfluff

Highlights

This is a relatively swift bugfix to refine some of the changes made to
widow function indentation in `2.0.4`. In addition there are two dialect
refinements also made since that release.

What’s Changed

* Refactor PG segments to reuse new common segments [4726](https://github.com/sqlfluff/sqlfluff/pull/4726) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Recognize quoted data types [4747](https://github.com/sqlfluff/sqlfluff/pull/4747) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)

Highlights

This is primarily a _bugfix_ and _dialect_ release:
* Several bugfixes related to templating and indentation, in particular some
improvements to the indentation of aliases and window functions.
* Performance improvements to the parser.
* The `--persist-timing` option is now also available on `sqlfluff fix`.
* A refresh to getting started and rule documentation.
* Dialect improvements to PostgreSQL, Athena, SparkSQL, MySQL & Snowflake.

Thanks also to [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
and [Thashin](https://github.com/Thashin) who made their first contributions
in this release. In particular, [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
made **twenty one** contributions in their first month! 🎉🎉🎉

What’s Changed

* SparkSQL: Improvements to lateral view, hints, sort by [4731](https://github.com/sqlfluff/sqlfluff/pull/4731) [bmorck](https://github.com/bmorck)
* Add ExpressionSegment to CREATE TABLE ... DEFAULT / Fix multiple parse issues in Expression_A_Grammar [4717](https://github.com/sqlfluff/sqlfluff/pull/4717) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Add support for the PG VACUUM statement [4742](https://github.com/sqlfluff/sqlfluff/pull/4742) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Simplify and fix PG array accessor segment & support expressions [4748](https://github.com/sqlfluff/sqlfluff/pull/4748) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* SparkSQL: Allow for any ordering of create table clauses [4721](https://github.com/sqlfluff/sqlfluff/pull/4721) [bmorck](https://github.com/bmorck)
* Suggested started config file [4702](https://github.com/sqlfluff/sqlfluff/pull/4702) [alanmcruickshank](https://github.com/alanmcruickshank)
* Indents on window functions [4560](https://github.com/sqlfluff/sqlfluff/pull/4560) [alanmcruickshank](https://github.com/alanmcruickshank)
* SparkSQL: Fix Group By Clause [4732](https://github.com/sqlfluff/sqlfluff/pull/4732) [bmorck](https://github.com/bmorck)
* Improve support for EXCLUDE table constraints in PG [4725](https://github.com/sqlfluff/sqlfluff/pull/4725) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Add support for dropping multiple indexes in PG [4737](https://github.com/sqlfluff/sqlfluff/pull/4737) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Recognize "on" value and integers for PG SET statement [4740](https://github.com/sqlfluff/sqlfluff/pull/4740) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Improve interval expressions on MySQL [4746](https://github.com/sqlfluff/sqlfluff/pull/4746) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Keep out zero length keywords [4723](https://github.com/sqlfluff/sqlfluff/pull/4723) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Add PG support for CREATE SCHEMA AUTHORIZATION [4735](https://github.com/sqlfluff/sqlfluff/pull/4735) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Add support for dropping multiple views with PostgreSQL [4736](https://github.com/sqlfluff/sqlfluff/pull/4736) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Add CHAR VARYING data type for PG [4738](https://github.com/sqlfluff/sqlfluff/pull/4738) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* fix(athena): map type matching failed, array type only contains a datatype [4739](https://github.com/sqlfluff/sqlfluff/pull/4739) [timcosta](https://github.com/timcosta)
* Allow DML queries to be selectable in CTEs on PG [4741](https://github.com/sqlfluff/sqlfluff/pull/4741) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Add the CREATE/DROP CAST statements to ANSI and PG [4744](https://github.com/sqlfluff/sqlfluff/pull/4744) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Add support for PG SET ROLE / RESET ROLE [4734](https://github.com/sqlfluff/sqlfluff/pull/4734) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Support Spark Iceberg DDL [4690](https://github.com/sqlfluff/sqlfluff/pull/4690) [bmorck](https://github.com/bmorck)
* Fix 4680 [4707](https://github.com/sqlfluff/sqlfluff/pull/4707) [alanmcruickshank](https://github.com/alanmcruickshank)
* Indent Aliases [4706](https://github.com/sqlfluff/sqlfluff/pull/4706) [alanmcruickshank](https://github.com/alanmcruickshank)
* SparkSQL: Improve window frame bounds [4722](https://github.com/sqlfluff/sqlfluff/pull/4722) [bmorck](https://github.com/bmorck)
* Add support for PG CREATE/ALTER/DROP PUBLICATION stmts [4716](https://github.com/sqlfluff/sqlfluff/pull/4716) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* SparkSQL: Create external table support [4692](https://github.com/sqlfluff/sqlfluff/pull/4692) [bmorck](https://github.com/bmorck)
* SparkSQL: Fix file literal lexing [4718](https://github.com/sqlfluff/sqlfluff/pull/4718) [bmorck](https://github.com/bmorck)
* Add PG DROP/REASSIGN OWNED statements [4720](https://github.com/sqlfluff/sqlfluff/pull/4720) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* SparkSQL: Add distinct to comparison operator [4719](https://github.com/sqlfluff/sqlfluff/pull/4719) [bmorck](https://github.com/bmorck)
* Rethink Rule Docs [4695](https://github.com/sqlfluff/sqlfluff/pull/4695) [alanmcruickshank](https://github.com/alanmcruickshank)
* Performance: Reduce calls to _prune_options [4705](https://github.com/sqlfluff/sqlfluff/pull/4705) [alanmcruickshank](https://github.com/alanmcruickshank)
* Snowflake: Add ReferencedVariableNameSegment to sample function [4712](https://github.com/sqlfluff/sqlfluff/pull/4712) [WittierDinosaur](https://github.com/WittierDinosaur)
* Mark AM02 as fix compatible [4714](https://github.com/sqlfluff/sqlfluff/pull/4714) [yoichi](https://github.com/yoichi)
* Fix LT01 spacing check in templated areas [4698](https://github.com/sqlfluff/sqlfluff/pull/4698) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Don't do newline conversion on write [4703](https://github.com/sqlfluff/sqlfluff/pull/4703) [alanmcruickshank](https://github.com/alanmcruickshank)
* MySQL: CREATE/ALTER VIEW may take UNION [4713](https://github.com/sqlfluff/sqlfluff/pull/4713) [yoichi](https://github.com/yoichi)
* Preserve zero-length template segments [4708](https://github.com/sqlfluff/sqlfluff/pull/4708) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* CV06: don't flag files that don't have code [4709](https://github.com/sqlfluff/sqlfluff/pull/4709) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Add a no-output option [4704](https://github.com/sqlfluff/sqlfluff/pull/4704) [alanmcruickshank](https://github.com/alanmcruickshank)
* Jinja templater: treat "import" and "from" as templated [4696](https://github.com/sqlfluff/sqlfluff/pull/4696) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Capitalization rules ignore templated code only if configured to [4697](https://github.com/sqlfluff/sqlfluff/pull/4697) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Update getting started docs [4700](https://github.com/sqlfluff/sqlfluff/pull/4700) [alanmcruickshank](https://github.com/alanmcruickshank)
* Add a default for config_keywords and remove noisy error. [4701](https://github.com/sqlfluff/sqlfluff/pull/4701) [alanmcruickshank](https://github.com/alanmcruickshank)
* Snowflake Select System Functions [4687](https://github.com/sqlfluff/sqlfluff/pull/4687) [Thashin](https://github.com/Thashin)
* SparkSQL: Add using and options clause to create view statement [4691](https://github.com/sqlfluff/sqlfluff/pull/4691) [bmorck](https://github.com/bmorck)
* MySQL: Add RETURN Statement [4693](https://github.com/sqlfluff/sqlfluff/pull/4693) [yoichi](https://github.com/yoichi)
* Safety valve for fixes in CV03 [4685](https://github.com/sqlfluff/sqlfluff/pull/4685) [alanmcruickshank](https://github.com/alanmcruickshank)
* Allow persist timing on `fix` too. [4679](https://github.com/sqlfluff/sqlfluff/pull/4679) [alanmcruickshank](https://github.com/alanmcruickshank)
* fix{dialect-snowflake}:Alter Table Column Set/Unset Tag [4682](https://github.com/sqlfluff/sqlfluff/pull/4682) [Thashin](https://github.com/Thashin)
* fix{dialect-snowflake}:Execute Task [4683](https://github.com/sqlfluff/sqlfluff/pull/4683) [Thashin](https://github.com/Thashin)
* Make version number an argument not an option in release script. [4677](https://github.com/sqlfluff/sqlfluff/pull/4677) [alanmcruickshank](https://github.com/alanmcruickshank)


New Contributors
* [Thashin](https://github.com/Thashin) made their first contribution in [#4683](https://github.com/sqlfluff/sqlfluff/pull/4683)
* [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack) made their first contribution in [#4697](https://github.com/sqlfluff/sqlfluff/pull/4697)

Highlights

This is primarily a _bugfix_ and _dialect_ release:
* Several bugfixes related to templating and indentation.
* Configurable indentation before `THEN` in `CASE` statements
(see [4598](https://github.com/sqlfluff/sqlfluff/pull/4598)).
* Performance improvements to `TypedParser`, `LT03` & `LT04`.
* Rule timings now appear in the `--persist-timing` option for deeper
performance understanding.
* The introduction of a Greenplum dialect.
* Dialect improvements to TSQL, Athena, Snowflake, MySQL, SparkSQL
BigQuery, Databricks, Clickhouse & Postgres.

We also saw a _huge number of first time contributors_ with **9** contributing
in this release 🎉🏆🎉.

What’s Changed

* Better error message for missing keywords [4676](https://github.com/sqlfluff/sqlfluff/pull/4676) [tunetheweb](https://github.com/tunetheweb)
* Add performance shortcuts to LT03 & LT04 [4672](https://github.com/sqlfluff/sqlfluff/pull/4672) [alanmcruickshank](https://github.com/alanmcruickshank)
* Clickhouse: Add support for [LEFT] ARRAY JOIN [4618](https://github.com/sqlfluff/sqlfluff/pull/4618) [simpl1g](https://github.com/simpl1g)
* Postgres - allow untyped OVERLAPS clauses [4674](https://github.com/sqlfluff/sqlfluff/pull/4674) [tunetheweb](https://github.com/tunetheweb)
* Mark `is_alias_required` as a private class so it doesn't appear in docs [4673](https://github.com/sqlfluff/sqlfluff/pull/4673) [tunetheweb](https://github.com/tunetheweb)
* Fix bug in templated with clauses LT07 [4671](https://github.com/sqlfluff/sqlfluff/pull/4671) [alanmcruickshank](https://github.com/alanmcruickshank)
* TSQL: `OPENJSON()` [4652](https://github.com/sqlfluff/sqlfluff/pull/4652) [keen85](https://github.com/keen85)
* fix(RF06/L059): allows configuring prefer_quoted_keywords to deconflict with L029 [4396](https://github.com/sqlfluff/sqlfluff/pull/4396) [timcosta](https://github.com/timcosta)
* TSQL: `Create External Table` [4642](https://github.com/sqlfluff/sqlfluff/pull/4642) [aly76](https://github.com/aly76)
* Consistent indentation in `MERGE` `INSERT` clause [4666](https://github.com/sqlfluff/sqlfluff/pull/4666) [dmohns](https://github.com/dmohns)
* BigQuery: Fix null assignment in options segment [4669](https://github.com/sqlfluff/sqlfluff/pull/4669) [greg-finley](https://github.com/greg-finley)
* BigQuery: Delete table reference [4668](https://github.com/sqlfluff/sqlfluff/pull/4668) [greg-finley](https://github.com/greg-finley)
* TSQL: `CREATE EXTERNAL FILE FORMAT` [4647](https://github.com/sqlfluff/sqlfluff/pull/4647) [keen85](https://github.com/keen85)
* Remove TIME as reserved keyword in SparkSQL [4662](https://github.com/sqlfluff/sqlfluff/pull/4662) [bmorck](https://github.com/bmorck)
* Start of the Greenplum dialect implementation [4661](https://github.com/sqlfluff/sqlfluff/pull/4661) [JackWolverson](https://github.com/JackWolverson)
* Enable configuring whether to require indent before THEN [4598](https://github.com/sqlfluff/sqlfluff/pull/4598) [fredriv](https://github.com/fredriv)
* Sequence Meta Handling [4622](https://github.com/sqlfluff/sqlfluff/pull/4622) [alanmcruickshank](https://github.com/alanmcruickshank)
* Add support for non-quoted file paths in SparkSQL [4650](https://github.com/sqlfluff/sqlfluff/pull/4650) [bmorck](https://github.com/bmorck)
* Remove three RegexParsers [4658](https://github.com/sqlfluff/sqlfluff/pull/4658) [alanmcruickshank](https://github.com/alanmcruickshank)
* Make parse test readout more helpful [4657](https://github.com/sqlfluff/sqlfluff/pull/4657) [alanmcruickshank](https://github.com/alanmcruickshank)
* TSQL: support for `sqlcmd` commands `:r` and `:setvar` [4653](https://github.com/sqlfluff/sqlfluff/pull/4653) [keen85](https://github.com/keen85)
* Update README with Databricks note [4632](https://github.com/sqlfluff/sqlfluff/pull/4632) [liamperritt](https://github.com/liamperritt)
* Athena: Fix parsing error with aliases starting with underscore [4636](https://github.com/sqlfluff/sqlfluff/pull/4636) [maiarareinaldo](https://github.com/maiarareinaldo)
* Snowflake: Stop ever-increasing indent in CREATE USER [4638](https://github.com/sqlfluff/sqlfluff/pull/4638) [roman-ef](https://github.com/roman-ef)
* TSQL: `PERIOD FOR SYSTEM_TIME` (temporal tables) [4654](https://github.com/sqlfluff/sqlfluff/pull/4654) [keen85](https://github.com/keen85)
* MySQL: SelectStatementSegment in CREATE/ALTER VIEW may be bracketed [4655](https://github.com/sqlfluff/sqlfluff/pull/4655) [yoichi](https://github.com/yoichi)
* TSQL: `CREATE EXTERNAL DATA SOURCE` [4634](https://github.com/sqlfluff/sqlfluff/pull/4634) [keen85](https://github.com/keen85)
* Safety valve on source fixes [4640](https://github.com/sqlfluff/sqlfluff/pull/4640) [alanmcruickshank](https://github.com/alanmcruickshank)
* Add SparkSQL support for LONG primitive type [4639](https://github.com/sqlfluff/sqlfluff/pull/4639) [bmorck](https://github.com/bmorck)
* Fix PIVOT clauses for BigQuery and SparkSQL [4630](https://github.com/sqlfluff/sqlfluff/pull/4630) [tunetheweb](https://github.com/tunetheweb)
* Correct BigQuery WINDOW parsing [4629](https://github.com/sqlfluff/sqlfluff/pull/4629) [tunetheweb](https://github.com/tunetheweb)
* Add Databricks dialect support for Unity Catalog [4568](https://github.com/sqlfluff/sqlfluff/pull/4568) [liamperritt](https://github.com/liamperritt)
* .simple() matching for TypedMatcher [4612](https://github.com/sqlfluff/sqlfluff/pull/4612) [alanmcruickshank](https://github.com/alanmcruickshank)
* --bench output with rule timings [4601](https://github.com/sqlfluff/sqlfluff/pull/4601) [alanmcruickshank](https://github.com/alanmcruickshank)
* MySQL: Unnamed constraints [4616](https://github.com/sqlfluff/sqlfluff/pull/4616) [greg-finley](https://github.com/greg-finley)
* TSQL: Create database scoped credential [4615](https://github.com/sqlfluff/sqlfluff/pull/4615) [greg-finley](https://github.com/greg-finley)
* fix(dialect-clickhouse): Add materialized view statement [4605](https://github.com/sqlfluff/sqlfluff/pull/4605) [germainlefebvre4](https://github.com/germainlefebvre4)
* Nicer formatted dbt errors [4606](https://github.com/sqlfluff/sqlfluff/pull/4606) [alanmcruickshank](https://github.com/alanmcruickshank)
* add parse lambda function Clickhouse [4611](https://github.com/sqlfluff/sqlfluff/pull/4611) [konnectr](https://github.com/konnectr)
* Support `WITH ORDINALITY` clauses in Postgres [4599](https://github.com/sqlfluff/sqlfluff/pull/4599) [tunetheweb](https://github.com/tunetheweb)


New Contributors
* [germainlefebvre4](https://github.com/germainlefebvre4) made their first contribution in [#4605](https://github.com/sqlfluff/sqlfluff/pull/4605)
* [liamperritt](https://github.com/liamperritt) made their first contribution in [#4568](https://github.com/sqlfluff/sqlfluff/pull/4568)
* [bmorck](https://github.com/bmorck) made their first contribution in [#4639](https://github.com/sqlfluff/sqlfluff/pull/4639)
* [keen85](https://github.com/keen85) made their first contribution in [#4634](https://github.com/sqlfluff/sqlfluff/pull/4634)
* [roman-ef](https://github.com/roman-ef) made their first contribution in [#4638](https://github.com/sqlfluff/sqlfluff/pull/4638)
* [maiarareinaldo](https://github.com/maiarareinaldo) made their first contribution in [#4636](https://github.com/sqlfluff/sqlfluff/pull/4636)
* [fredriv](https://github.com/fredriv) made their first contribution in [#4598](https://github.com/sqlfluff/sqlfluff/pull/4598)
* [aly76](https://github.com/aly76) made their first contribution in [#4642](https://github.com/sqlfluff/sqlfluff/pull/4642)
* [simpl1g](https://github.com/simpl1g) made their first contribution in [#4618](https://github.com/sqlfluff/sqlfluff/pull/4618)

Highlights

This is primarily a _bugfix_ release. Most notably this solves some of the
issues introduced in 2.0.1 around spacing within datatypes. Expressions
like `1.0::double precision` should now be spaced correctly.

Beyond that, this contains a selection of smaller bugfixes and dialect
improvements. Even for a relatively small release we saw three new
contributors (thanks [aurany](https://github.com/aurany), [JackWolverson](https://github.com/JackWolverson)
& [mikaeltw](https://github.com/mikaeltw) 🎉).

The one new _feature_ (as such) is being able to now configure `LT05`
(aka `layout.long_lines`) to optionally move trailing comments _after_
the line they are found on, rather than the default behaviour of moving
them up and _before_. Users can enable this with the `trailing_comments`
configuration setting in the `indentation` section.

This release _also_ contains some performance optimisations in the parser,
especially on queries with heavily nested expressions. There will be more
to come in this space, but we hope this leads to a better experience for
many users. 🚀

What’s Changed

* Parse Caching [4576](https://github.com/sqlfluff/sqlfluff/pull/4576) [alanmcruickshank](https://github.com/alanmcruickshank)
* Data type spacing [4592](https://github.com/sqlfluff/sqlfluff/pull/4592) [alanmcruickshank](https://github.com/alanmcruickshank)
* MySQL: allow quoted literal in alias name [4591](https://github.com/sqlfluff/sqlfluff/pull/4591) [yoichi](https://github.com/yoichi)
* Make implicit indents visible in the parse tree [4584](https://github.com/sqlfluff/sqlfluff/pull/4584) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix 4559: TSQL implicit indents on WHERE [4583](https://github.com/sqlfluff/sqlfluff/pull/4583) [alanmcruickshank](https://github.com/alanmcruickshank)
* Added keywords to DB2 dialect from IBM docs [4575](https://github.com/sqlfluff/sqlfluff/pull/4575) [aurany](https://github.com/aurany)
* Remove matches_target_tuples (3873) [4561](https://github.com/sqlfluff/sqlfluff/pull/4561) [alanmcruickshank](https://github.com/alanmcruickshank)
* Use terminators in BaseExpression [4577](https://github.com/sqlfluff/sqlfluff/pull/4577) [alanmcruickshank](https://github.com/alanmcruickshank)
* Address 1630: Optionally move comments after long line [4558](https://github.com/sqlfluff/sqlfluff/pull/4558) [alanmcruickshank](https://github.com/alanmcruickshank)
* Added schema to set statement [4580](https://github.com/sqlfluff/sqlfluff/pull/4580) [JackWolverson](https://github.com/JackWolverson)
* Refactor lint_line_length and fix comma bug [4564](https://github.com/sqlfluff/sqlfluff/pull/4564) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix untaken indent bug [4562](https://github.com/sqlfluff/sqlfluff/pull/4562) [alanmcruickshank](https://github.com/alanmcruickshank)
* SQLite: Fix SELECT LIMIT [4566](https://github.com/sqlfluff/sqlfluff/pull/4566) [greg-finley](https://github.com/greg-finley)
* Fix 4453: Snowflake semi-stuctured casts in CV11 [4571](https://github.com/sqlfluff/sqlfluff/pull/4571) [alanmcruickshank](https://github.com/alanmcruickshank)
* Name of LT07 [4557](https://github.com/sqlfluff/sqlfluff/pull/4557) [alanmcruickshank](https://github.com/alanmcruickshank)
* Patch fetch and over [4555](https://github.com/sqlfluff/sqlfluff/pull/4555) [mikaeltw](https://github.com/mikaeltw)

New Contributors

* [mikaeltw](https://github.com/mikaeltw) made their first contribution in [#4555](https://github.com/sqlfluff/sqlfluff/pull/4555)
* [JackWolverson](https://github.com/JackWolverson) made their first contribution in [#4580](https://github.com/sqlfluff/sqlfluff/pull/4580)
* [aurany](https://github.com/aurany) made their first contribution in [#4575](https://github.com/sqlfluff/sqlfluff/pull/4575)

- Add a `sqlfluff.environmentVariables` configuration setting to allow users to set their own environment variables.
- Improve the `lintEntireProject` setup to limit the amount of files that are linted at any one time to 5 files.

- Spacing for (as applied by `LT01`) for datatypes, hyphenated identifiers and
casting operators.
- Several bugs in the indentation routines (`LT02`), in particular with implicit
indents.
- Fixing a conflict between `LT09` and `LT02`, by only limiting `LT09` to bringing
targets onto a single line if there is only one select target **and** that it
contains no newlines.
- Supporting arrays, and the new rules configuration more effectively in `pyproject.toml`.
- Configuring dialects on a file by file basis using inline comments now works.

This release also brings one small new feature in allowing additional flags to
be passed to SQLFluff when called as a `pre-commit` hook.

Thanks especially to [JavierMonton](https://github.com/JavierMonton) and
[LauraRichter](https://github.com/LauraRichter) who made their first contributions
to the project as part of this release! 🎉🏆

What’s Changed

* Add support for arrays in TOML configuration [4387](https://github.com/sqlfluff/sqlfluff/pull/4387) [AidanHarveyNelson](https://github.com/AidanHarveyNelson)
* Rethink test segregation in CI [4547](https://github.com/sqlfluff/sqlfluff/pull/4547) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix 4515 and add more test cases [4525](https://github.com/sqlfluff/sqlfluff/pull/4525) [alanmcruickshank](https://github.com/alanmcruickshank)
* Add additional flags to `sqlfluff` invocations in pre-commit hooks [4546](https://github.com/sqlfluff/sqlfluff/pull/4546) [borchero](https://github.com/borchero)
* Resolve 4484 (issues with indented_joins indents) [4544](https://github.com/sqlfluff/sqlfluff/pull/4544) [alanmcruickshank](https://github.com/alanmcruickshank)
* Per file dialect selection fix [4518](https://github.com/sqlfluff/sqlfluff/pull/4518) [LauraRichter](https://github.com/LauraRichter)
* MySQL: Add CREATE INDEX [4538](https://github.com/sqlfluff/sqlfluff/pull/4538) [yoichi](https://github.com/yoichi)
* Resolve implicit indent issues when catching negative indents [4543](https://github.com/sqlfluff/sqlfluff/pull/4543) [alanmcruickshank](https://github.com/alanmcruickshank)
* Github Action Deprecations [4545](https://github.com/sqlfluff/sqlfluff/pull/4545) [alanmcruickshank](https://github.com/alanmcruickshank)
* LT09 and multiline select targets [4529](https://github.com/sqlfluff/sqlfluff/pull/4529) [alanmcruickshank](https://github.com/alanmcruickshank)
* Remove Codecov from CI [4535](https://github.com/sqlfluff/sqlfluff/pull/4535) [alanmcruickshank](https://github.com/alanmcruickshank)
* Bigquery hyphentated identifiers [4530](https://github.com/sqlfluff/sqlfluff/pull/4530) [alanmcruickshank](https://github.com/alanmcruickshank)
* Attempt in-house coverage [4532](https://github.com/sqlfluff/sqlfluff/pull/4532) [alanmcruickshank](https://github.com/alanmcruickshank)
* Postgres datatype spacing issues [4528](https://github.com/sqlfluff/sqlfluff/pull/4528) [alanmcruickshank](https://github.com/alanmcruickshank)
* Support new rules config in toml files. [4526](https://github.com/sqlfluff/sqlfluff/pull/4526) [alanmcruickshank](https://github.com/alanmcruickshank)
* Resolve 1146 (log propagation) [4513](https://github.com/sqlfluff/sqlfluff/pull/4513) [alanmcruickshank](https://github.com/alanmcruickshank)
* Snowflake: Optional quotes for `create user` statement [4514](https://github.com/sqlfluff/sqlfluff/pull/4514) [JavierMonton](https://github.com/JavierMonton)

New Contributors

* [JavierMonton](https://github.com/JavierMonton) made their first contribution in [#4514](https://github.com/sqlfluff/sqlfluff/pull/4514)
* [LauraRichter](https://github.com/LauraRichter) made their first contribution in [#4518](https://github.com/sqlfluff/sqlfluff/pull/4518)