Sqlfluff

Highlights

This release brings support for dbt 1.5+. Some internals of dbt mean
that SQFluff versions prior to this release may experience errors with
dbt versions post 1.5. In addition to that there are some dialect and
templating improvements bundled too:
* Support for custom Jinja filters.
* An additional configurable indent behaviour within `CASE WHEN` clauses.
* Additional support for bracket quoted literals in TSQL and RF06.
* Dialect improvements to Snowflake, Hive, Redshift, Postgres,
Clickhouse, Oracle and SQLite

What’s Changed

* Add support for Jinja filters [4810](https://github.com/sqlfluff/sqlfluff/pull/4810) [dmohns](https://github.com/dmohns)
* Postgres: Allow INSERT RETURNING [4820](https://github.com/sqlfluff/sqlfluff/pull/4820) [WittierDinosaur](https://github.com/WittierDinosaur)
* SQLite: Support partial index [4833](https://github.com/sqlfluff/sqlfluff/pull/4833) [WittierDinosaur](https://github.com/WittierDinosaur)
* Make SQLFluff compatible with DBT 1.5 [4828](https://github.com/sqlfluff/sqlfluff/pull/4828) [WittierDinosaur](https://github.com/WittierDinosaur)
* Snowflake dialect: Add support for comment clause in the create warehouse statement [4823](https://github.com/sqlfluff/sqlfluff/pull/4823) [moreaupascal56](https://github.com/moreaupascal56)
* fix(dialect-clickhouse): Support DROP statements [4821](https://github.com/sqlfluff/sqlfluff/pull/4821) [germainlefebvre4](https://github.com/germainlefebvre4)
* Hive: INSERT INTO without TABLE keyword [4819](https://github.com/sqlfluff/sqlfluff/pull/4819) [greg-finley](https://github.com/greg-finley)
* Fix: Small typo in error message [4814](https://github.com/sqlfluff/sqlfluff/pull/4814) [JavierMonton](https://github.com/JavierMonton)
* Redshift: Support with no schema binding [4813](https://github.com/sqlfluff/sqlfluff/pull/4813) [WittierDinosaur](https://github.com/WittierDinosaur)
* Detect tsql square bracket quotes for RF06 4724 [4781](https://github.com/sqlfluff/sqlfluff/pull/4781) [daviewales](https://github.com/daviewales)
* Apply implicit indents to `WHEN` blocks and introduce `indented_then_contents` [4755](https://github.com/sqlfluff/sqlfluff/pull/4755) [borchero](https://github.com/borchero)
* Oracle: Update Drop Behaviour [4803](https://github.com/sqlfluff/sqlfluff/pull/4803) [WittierDinosaur](https://github.com/WittierDinosaur)
* Oracle: Update bare functions [4804](https://github.com/sqlfluff/sqlfluff/pull/4804) [WittierDinosaur](https://github.com/WittierDinosaur)

New Contributors

* [daviewales](https://github.com/daviewales) made their first contribution in [#4781](https://github.com/sqlfluff/sqlfluff/pull/4781)

Highlights

This is a bugfix release to resolve two regressions included in 2.0.6
related to implicit indents. This also includes a bugfix for config
file on osx, contributed by first time contributor [jpuris](https://github.com/jpuris) 🎉.

What’s Changed

* Fix regression in implicit indents [4798](https://github.com/sqlfluff/sqlfluff/pull/4798) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix bug with brackets and implicit indents [4797](https://github.com/sqlfluff/sqlfluff/pull/4797) [alanmcruickshank](https://github.com/alanmcruickshank)
* fix: correct macos/osx config file location [4795](https://github.com/sqlfluff/sqlfluff/pull/4795) [jpuris](https://github.com/jpuris)

New Contributors

* [jpuris](https://github.com/jpuris) made their first contribution in [#4795](https://github.com/sqlfluff/sqlfluff/pull/4795)

Highlights

* Introduction of a `--quiet` option for the CLI for situations
where less output is useful.
* When using the `--force` option is used for `sqlfluff fix` each
file is fixed during the linting process rather than at the end.
* Bugfixes to comment and templated section indentation.
* Performance improvements to parsing.
* Bugfix to macros triggering LT01.
* Renaming `layout.end-of-file` to `layout.end_of_file` in line
with other rules.
* Dialect improvements to SparkSQL, BigQuery, Hive & Snowflake.


What’s Changed

* Snowflake: Support Temporary View [4789](https://github.com/sqlfluff/sqlfluff/pull/4789) [WittierDinosaur](https://github.com/WittierDinosaur)
* Inroduce `SAFE` prefix segment [4773](https://github.com/sqlfluff/sqlfluff/pull/4773) [dmohns](https://github.com/dmohns)
* Fix 4660: Better handling of empty files. [4780](https://github.com/sqlfluff/sqlfluff/pull/4780) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix 3538: (Fix files as we go) [4777](https://github.com/sqlfluff/sqlfluff/pull/4777) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix 2855: (Tech debt: check consistency in TemplatedFile init) [4776](https://github.com/sqlfluff/sqlfluff/pull/4776) [alanmcruickshank](https://github.com/alanmcruickshank)
* Add a --quiet option for fix [4764](https://github.com/sqlfluff/sqlfluff/pull/4764) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix 4603 indent after Jinja 'do' directive [4778](https://github.com/sqlfluff/sqlfluff/pull/4778) [fredriv](https://github.com/fredriv)
* Snowflake Execute Task with Schema [4771](https://github.com/sqlfluff/sqlfluff/pull/4771) [Thashin](https://github.com/Thashin)
* SQLite: Support CreateTrigger [4767](https://github.com/sqlfluff/sqlfluff/pull/4767) [WittierDinosaur](https://github.com/WittierDinosaur)
* Fix 2865 (AL05 exception for Redshift Semi-structured) [4775](https://github.com/sqlfluff/sqlfluff/pull/4775) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix 4540: Untaken indents evaluation order. [4768](https://github.com/sqlfluff/sqlfluff/pull/4768) [alanmcruickshank](https://github.com/alanmcruickshank)
* Use the new CollationReferenceSegment everywhere [4770](https://github.com/sqlfluff/sqlfluff/pull/4770) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* SQLite: Fix multiple parse issues in Expression_A_Grammar [4769](https://github.com/sqlfluff/sqlfluff/pull/4769) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* SQLite: Remove refs to RESPECT and QUALIFY [4765](https://github.com/sqlfluff/sqlfluff/pull/4765) [WittierDinosaur](https://github.com/WittierDinosaur)
* SQLite: Support STRICT [4766](https://github.com/sqlfluff/sqlfluff/pull/4766) [WittierDinosaur](https://github.com/WittierDinosaur)
* Support hive set syntax [4763](https://github.com/sqlfluff/sqlfluff/pull/4763) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix 4582: Comments after end of line [4760](https://github.com/sqlfluff/sqlfluff/pull/4760) [alanmcruickshank](https://github.com/alanmcruickshank)
* Allow comment match with preceding line [4758](https://github.com/sqlfluff/sqlfluff/pull/4758) [alanmcruickshank](https://github.com/alanmcruickshank)
* Remove the majority of greedy matchers [4761](https://github.com/sqlfluff/sqlfluff/pull/4761) [WittierDinosaur](https://github.com/WittierDinosaur)
* Fix 4745: (max() error in reindent) [4752](https://github.com/sqlfluff/sqlfluff/pull/4752) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix issue with macros triggering LT01 [4757](https://github.com/sqlfluff/sqlfluff/pull/4757) [alanmcruickshank](https://github.com/alanmcruickshank)
* end-of-file > end_of_file [4753](https://github.com/sqlfluff/sqlfluff/pull/4753) [alanmcruickshank](https://github.com/alanmcruickshank)

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)