Sqlfluff

Highlights
Major changes include:
* L066 - New rule to allow you to set min/max length requirements for aliases to ensure they are meaningful
* L062 - addition of `blocked_regex` as well as `blocked_words`
* L025 - fix several corner cases where aliases were removed inappropriately
* L059 is now disabled by default for Postgres
* Many more dialect improvements and bug fixes.

Highlights

What’s Changed

* L025: Derived query requires alias -- also handle UNION, etc. [3548](https://github.com/sqlfluff/sqlfluff/pull/3548) [barrywhart](https://github.com/barrywhart)
* L025 should not remove aliases from derived queries [3546](https://github.com/sqlfluff/sqlfluff/pull/3546) [barrywhart](https://github.com/barrywhart)
* T-SQL keyword functions should be treated as keywords [3540](https://github.com/sqlfluff/sqlfluff/pull/3540) [tunetheweb](https://github.com/tunetheweb)
* Fix issue where "--nocolor" is ignored [3536)(https://github.com/sqlfluff/sqlfluff/pull/3536) [barrywhart](https://github.com/barrywhart)
* Clickhouse: allow `FINAL` modifier [3534](https://github.com/sqlfluff/sqlfluff/pull/3534) [ThomAub](https://github.com/ThomAub)
* L018 change to just check for newlines rather than alignment [3499](https://github.com/sqlfluff/sqlfluff/pull/3499) [zidder](https://github.com/zidder)
* SparkSQL: Update terminator grammar for `HAVING`, `WHERE`, `GROUP BY` [3526](https://github.com/sqlfluff/sqlfluff/pull/3526) [R7L208](https://github.com/R7L208)
* Fix L025 false positive for T-SQL `VALUES` clause [3533](https://github.com/sqlfluff/sqlfluff/pull/3533) [barrywhart](https://github.com/barrywhart)
* New rule L066 for enforcing table alias lengths [3384](https://github.com/sqlfluff/sqlfluff/pull/3384) [f0rk](https://github.com/f0rk)
* Redshift: `CALL` statement [3529](https://github.com/sqlfluff/sqlfluff/pull/3529) [greg-finley](https://github.com/greg-finley)
* Core: Compile regexes at init time to avoid overhead [3511](https://github.com/sqlfluff/sqlfluff/pull/3511) [judahrand](https://github.com/judahrand)
* Disable L059 by default for Postgres [3528](https://github.com/sqlfluff/sqlfluff/pull/3528) [tunetheweb](https://github.com/tunetheweb)
* Core: Add `MultiStringParser` to match a collection of strings [3510](https://github.com/sqlfluff/sqlfluff/pull/3510) [judahrand](https://github.com/judahrand)
* SQLite: `PRIMARY KEY AUTOINCREMENT` [3527](https://github.com/sqlfluff/sqlfluff/pull/3527) [greg-finley](https://github.com/greg-finley)
* MySQL: Support `LOAD DATA` [3518](https://github.com/sqlfluff/sqlfluff/pull/3518) [greg-finley](https://github.com/greg-finley)
* Redshift: `GRANT EXECUTE ON PROCEDURES` [3516](https://github.com/sqlfluff/sqlfluff/pull/3516) [greg-finley](https://github.com/greg-finley)
* Allow `DEFAULT` expression in Redshift `ALTER TABLE ADD COLUMN` statements [3513](https://github.com/sqlfluff/sqlfluff/pull/3513) [menzenski](https://github.com/menzenski)
* BigQuery: Fix parsing of Array creation from full subquery [3502](https://github.com/sqlfluff/sqlfluff/pull/3502) [judahrand](https://github.com/judahrand)
* SparkSQL: Allow dateparts as table aliases [3500](https://github.com/sqlfluff/sqlfluff/pull/3500) [R7L208](https://github.com/R7L208)
* Fix `load_macros_from_path` to actually support multiple paths [3488](https://github.com/sqlfluff/sqlfluff/pull/3488) [emancu](https://github.com/emancu)
* Allow linter to apply fixes spanning more than 2 slices [3492](https://github.com/sqlfluff/sqlfluff/pull/3492) [barrywhart](https://github.com/barrywhart)
* Fix L022 false positive when the CTE definition has a column list [3490](https://github.com/sqlfluff/sqlfluff/pull/3490) [barrywhart](https://github.com/barrywhart)
* SparkSQL: Support for Delta `RESTORE` statement [3486](https://github.com/sqlfluff/sqlfluff/pull/3486) [R7L208](https://github.com/R7L208)
* Add values function to `SET` clause [3483](https://github.com/sqlfluff/sqlfluff/pull/3483) [hgranthorner](https://github.com/hgranthorner)
* SparkSQL: Support for `CONVERT TO DELTA` command [3482](https://github.com/sqlfluff/sqlfluff/pull/3482) [R7L208](https://github.com/R7L208)
* BigQuery: Remaining procedural statements [3473](https://github.com/sqlfluff/sqlfluff/pull/3473) [tunetheweb](https://github.com/tunetheweb)
* Postgres: support grouping sets [3477](https://github.com/sqlfluff/sqlfluff/pull/3477) [tunetheweb](https://github.com/tunetheweb)
* SparkSQL: Support for Delta syntax to create manifest files through the `GENERATE` command [3478](https://github.com/sqlfluff/sqlfluff/pull/3478) [R7L208](https://github.com/R7L208)
* Add config for optionally indenting contents of `ON` blocks [3471](https://github.com/sqlfluff/sqlfluff/pull/3471) [PeterBalsdon](https://github.com/PeterBalsdon)
* L026: check standalone aliases as well as table aliases [3470](https://github.com/sqlfluff/sqlfluff/pull/3470) [tunetheweb](https://github.com/tunetheweb)
* L045: Add handling for nested queries and CTEs [3468](https://github.com/sqlfluff/sqlfluff/pull/3468) [barrywhart](https://github.com/barrywhart)
* L062: add `blocked_regex` support [3467](https://github.com/sqlfluff/sqlfluff/pull/3467) [tunetheweb](https://github.com/tunetheweb)
* SparkSQL: Support for the Delta `DESCRIBE DETAIL` command [3465](https://github.com/sqlfluff/sqlfluff/pull/3465) [R7L208](https://github.com/R7L208)

New Contributors

* [PeterBalsdon](https://github.com/PeterBalsdon) made their first contribution in [#3471](https://github.com/sqlfluff/sqlfluff/pull/3471)
* [hgranthorner](https://github.com/hgranthorner) made their first contribution in [#3483](https://github.com/sqlfluff/sqlfluff/pull/3483)
* [emancu](https://github.com/emancu) made their first contribution in [#3488](https://github.com/sqlfluff/sqlfluff/pull/3488)
* [judahrand](https://github.com/judahrand) made their first contribution in [#3502](https://github.com/sqlfluff/sqlfluff/pull/3502)
* [f0rk](https://github.com/f0rk) made their first contribution in [#3384](https://github.com/sqlfluff/sqlfluff/pull/3384)
* [zidder](https://github.com/zidder) made their first contribution in [#3499](https://github.com/sqlfluff/sqlfluff/pull/3499)
* [ThomAub](https://github.com/ThomAub) made their first contribution in [#3534](https://github.com/sqlfluff/sqlfluff/pull/3534)

Highlights

This is the first _stable_ release of SQLFluff 🎉🎉🎉.

- _Does this mean there are no more bugs?_ **No.**
- _Does this mean we're going to stop developing new features?_ **No.**
- _Does this mean that this is a tool that is now broadly usable for many teams?_ **Yes.**

We've intentionally chosen to release 1.0.0 at a time of relative stability within SQLFluff and
not at a time when new big structural changes are being made. This means that there's a good
chance that this release is broadly usable. This also recognises that through the hard work
of a _huge_ number of contributors that we've built out this from a fringe tool, to something
which gets over 500k downloads a month and over 4k stars on Github.

There's still a lot to do, and some more exciting things on the horizon. If you want to be
part of this and join the team of contributors, come and hang out in our [slack community](https://join.slack.com/t/sqlfluff/shared_invite/zt-o1f4x0e8-pZzarAIlQmKj_6ZwD16w0g)
or on our [twitter account](https://twitter.com/SQLFluff) where people can help you get
started. If you're a long time user, keep submitting bug reports and inputting
on [issues on Github](https://github.com/sqlfluff/sqlfluff/issues).

If you've never used SQLFluff before, or are hesitant about starting to use it in your day
to day work, now might be a good time to try it. We have guides on how to [get started with the tool](https://docs.sqlfluff.com/en/stable/gettingstarted.html),
and how to [get started with rolling out to a team](https://docs.sqlfluff.com/en/stable/teamrollout.html) in our docs.

What’s Changed

* Swap to skip file if not found [3464](https://github.com/sqlfluff/sqlfluff/pull/3464) [alanmcruickshank](https://github.com/alanmcruickshank)
* Postgres: treat `GENERATE_SERIES` as a value table function [3463](https://github.com/sqlfluff/sqlfluff/pull/3463) [tunetheweb](https://github.com/tunetheweb)
* Postgres: Support multiple `CONSTRAINTS` in `CREATE DOMAIN` [3460](https://github.com/sqlfluff/sqlfluff/pull/3460) [tunetheweb](https://github.com/tunetheweb)
* Redshift: Add `ANYELEMENT` support [3458](https://github.com/sqlfluff/sqlfluff/pull/3458) [tunetheweb](https://github.com/tunetheweb)
* Postgres: Optional select clause elements and better `ON CONFLICT` support [3452](https://github.com/sqlfluff/sqlfluff/pull/3452) [tunetheweb](https://github.com/tunetheweb)
* Add ClickHouse as a dialect [3448](https://github.com/sqlfluff/sqlfluff/pull/3448) [tunetheweb](https://github.com/tunetheweb)
* Postgres: allow keywords in qualified column references [3450](https://github.com/sqlfluff/sqlfluff/pull/3450) [tunetheweb](https://github.com/tunetheweb)
* Remove Baron Schwatz Dead Link [3453](https://github.com/sqlfluff/sqlfluff/pull/3453) [tunetheweb](https://github.com/tunetheweb)
* Postgres: Finish `ALTER TYPE` [3451](https://github.com/sqlfluff/sqlfluff/pull/3451) [greg-finley](https://github.com/greg-finley)
* SparkSQL: Add Delta Syntax for `DESCRIBE HISTORY` statement [3447](https://github.com/sqlfluff/sqlfluff/pull/3447) [R7L208](https://github.com/R7L208)
* Snowflake: Support Stage data file parameters in `FROM` clauses [3446](https://github.com/sqlfluff/sqlfluff/pull/3446) [tunetheweb](https://github.com/tunetheweb)
* Redshift: Support Object unpivoting [3441](https://github.com/sqlfluff/sqlfluff/pull/3441) [tunetheweb](https://github.com/tunetheweb)
* Python script to automate release [3403](https://github.com/sqlfluff/sqlfluff/pull/3403) [greg-finley](https://github.com/greg-finley)
* Remove Delta Lake Reference in README.md [3444](https://github.com/sqlfluff/sqlfluff/pull/3444) [R7L208](https://github.com/R7L208)
* Add `databricks` dialect as an alias for `sparksql` dialect [3440](https://github.com/sqlfluff/sqlfluff/pull/3440) [R7L208](https://github.com/R7L208)
* Make all Postgres identifiers quotable [3442](https://github.com/sqlfluff/sqlfluff/pull/3442) [tunetheweb](https://github.com/tunetheweb)
* Update JinjaAnalyzer and JinjaTracer to handle `{% block %}` [3436](https://github.com/sqlfluff/sqlfluff/pull/3436) [barrywhart](https://github.com/barrywhart)
* SparkSQL: Add support for Delta `VACUUM` statement [3439](https://github.com/sqlfluff/sqlfluff/pull/3439) [R7L208](https://github.com/R7L208)
* Warning for parsing errors extended to all dialects [3411](https://github.com/sqlfluff/sqlfluff/pull/3411) [mdahlman](https://github.com/mdahlman)
* Handle templater validation errors more gracefully [3433](https://github.com/sqlfluff/sqlfluff/pull/3433) [alanmcruickshank](https://github.com/alanmcruickshank)
* MYSQL: allow for escaped single quotes [3424](https://github.com/sqlfluff/sqlfluff/pull/3424) [mdahlman](https://github.com/mdahlman)
* L027: Fix false positives by reverting the PR for issue 2992: Check table aliases exist [3435](https://github.com/sqlfluff/sqlfluff/pull/3435) [barrywhart](https://github.com/barrywhart)
* Allow `numeric_dollar` templater to have curly braces, update `dollar` + `numeric_dollar` templater examples in docs [3432](https://github.com/sqlfluff/sqlfluff/pull/3432) [menzenski](https://github.com/menzenski)
* Allow Redshift `IDENTITY` column `(seed, step)` to be optional [3430](https://github.com/sqlfluff/sqlfluff/pull/3430) [menzenski](https://github.com/menzenski)
* L036: Make wildcard behavior configurable [3426](https://github.com/sqlfluff/sqlfluff/pull/3426) [barrywhart](https://github.com/barrywhart)
* L034: Don't autofix if numeric column references [3423](https://github.com/sqlfluff/sqlfluff/pull/3423) [barrywhart](https://github.com/barrywhart)
* L036: Treat wildcard as multiple select targets (i.e. separate line) [3422](https://github.com/sqlfluff/sqlfluff/pull/3422) [barrywhart](https://github.com/barrywhart)
* Snowflake: IDENTIFIER pseudo-function [3409](https://github.com/sqlfluff/sqlfluff/pull/3409) [mdahlman](https://github.com/mdahlman)
* SNOWFLAKE: Fully referenced object names in clone statements [3414](https://github.com/sqlfluff/sqlfluff/pull/3414) [mdahlman](https://github.com/mdahlman)
* Unpin coverage now issue with 6.3 has been resolved [3393](https://github.com/sqlfluff/sqlfluff/pull/3393) [tunetheweb](https://github.com/tunetheweb)
* L045: handle `UPDATE` statements with CTEs [3397](https://github.com/sqlfluff/sqlfluff/pull/3397) [tunetheweb](https://github.com/tunetheweb)
* L027: Add support for `ignore_words` [3398](https://github.com/sqlfluff/sqlfluff/pull/3398) [dmohns](https://github.com/dmohns)
* Postgres: Allow `CREATE FUNCTION` to use Expressions in default values [3408](https://github.com/sqlfluff/sqlfluff/pull/3408) [tunetheweb](https://github.com/tunetheweb)
* Fix bug in `apply_fixes()` with leading/trailing whitespace [3407](https://github.com/sqlfluff/sqlfluff/pull/3407) [barrywhart](https://github.com/barrywhart)
* Redshift: Correct `ALTER TABLE` syntax [3395](https://github.com/sqlfluff/sqlfluff/pull/3395) [tunetheweb](https://github.com/tunetheweb)
* Postgres: Parse index with column sort [3405](https://github.com/sqlfluff/sqlfluff/pull/3405) [greg-finley](https://github.com/greg-finley)
* MySQL: Improve SET Syntax for Variable Assignment [3394](https://github.com/sqlfluff/sqlfluff/pull/3394) [mdahlman](https://github.com/mdahlman)
* Handle Postgres-style type casts when using the `colon_nospaces` templating style [3383](https://github.com/sqlfluff/sqlfluff/pull/3383) [benji-york](https://github.com/benji-york)
* Capitalization in help message [3385](https://github.com/sqlfluff/sqlfluff/pull/3385) [mdahlman](https://github.com/mdahlman)
* MySQL: Update keywords [3381](https://github.com/sqlfluff/sqlfluff/pull/3381) [mdahlman](https://github.com/mdahlman)
* Teradata: Database statement and Set Session Database [3382](https://github.com/sqlfluff/sqlfluff/pull/3382) [mdahlman](https://github.com/mdahlman)


New Contributors
* [benji-york](https://github.com/benji-york) made their first contribution in [#3383](https://github.com/sqlfluff/sqlfluff/pull/3383)
* [menzenski](https://github.com/menzenski) made their first contribution in [#3430](https://github.com/sqlfluff/sqlfluff/pull/3430)

Highlights
Major changes include:
* Fix bug causing L003 to report indentation errors for templated code - sorry we know that one's caused many of you some grief :-(
* Initial support of SOQL (Salesforce Object Query Language).
* Additional Placeholder templating options.
* Start of BigQuery procedural language support (starting simple `FOR` statements and `CREATE PROCEDURE` statements).
* New rule L065 to put set operators onto new lines.
* Many more dialect improvements and bug fixes.

What’s Changed

* All dialects: Allow `RESPECT NULLS`/`IGNORE NULLS` in window functions [3376](https://github.com/sqlfluff/sqlfluff/pull/3376) [tunetheweb](https://github.com/tunetheweb)
* Postgres: correct `RETURNS TABLE` column type [3379](https://github.com/sqlfluff/sqlfluff/pull/3379) [tunetheweb](https://github.com/tunetheweb)
* L065: Add rule for set operators surrounded by newlines [3330](https://github.com/sqlfluff/sqlfluff/pull/3330) [dmohns](https://github.com/dmohns)
* L064: Apply preferred quote-style for partially templated quoted literals [3300](https://github.com/sqlfluff/sqlfluff/pull/3300) [dmohns](https://github.com/dmohns)
* BigQuery: Support Stored Procedures [3369](https://github.com/sqlfluff/sqlfluff/pull/3369) [tunetheweb](https://github.com/tunetheweb)
* MySQL extra Boolean operators (`&&`, `||`, `!`) [3359](https://github.com/sqlfluff/sqlfluff/pull/3359) [mdahlman](https://github.com/mdahlman)
* Postgres and Redshift: Support `LOCK [TABLE]` [3350](https://github.com/sqlfluff/sqlfluff/pull/3350) [tunetheweb](https://github.com/tunetheweb)
* Placeholder updates: Allow optional braces in dollar placeholders, add `colon_nospaces`, and cast to string [3354](https://github.com/sqlfluff/sqlfluff/pull/3354) [tunetheweb](https://github.com/tunetheweb)
* BigQuery: Basic `FOR..IN..DO...END FOR` support [3340](https://github.com/sqlfluff/sqlfluff/pull/3340) [tunetheweb](https://github.com/tunetheweb)
* L025: exclude `VALUES` clauses [3358](https://github.com/sqlfluff/sqlfluff/pull/3358) [tunetheweb](https://github.com/tunetheweb)
* GitHub Actions: Update existing PR on new runs [3367](https://github.com/sqlfluff/sqlfluff/pull/3367) [greg-finley](https://github.com/greg-finley)
* GitHub Actions: Copy draft release notes to CHANGELOG [3360](https://github.com/sqlfluff/sqlfluff/pull/3360) [greg-finley](https://github.com/greg-finley)
* GitHub Action to set version number [3347](https://github.com/sqlfluff/sqlfluff/pull/3347) [greg-finley](https://github.com/greg-finley)
* Postgres and Redshift: support `ALTER SCHEMA` [3346](https://github.com/sqlfluff/sqlfluff/pull/3346) [mdahlman](https://github.com/mdahlman)
* MySQL: better `SELECT..INTO` support [3351](https://github.com/sqlfluff/sqlfluff/pull/3351) [tunetheweb](https://github.com/tunetheweb)
* Postgres: support better function calls in `CREATE TRIGGER` [3349](https://github.com/sqlfluff/sqlfluff/pull/3349) [tunetheweb](https://github.com/tunetheweb)
* Misc rule doc updates [3352](https://github.com/sqlfluff/sqlfluff/pull/3352) [tunetheweb](https://github.com/tunetheweb)
* Snowflake: Move `CASE` keyword to Unreserved list [3353](https://github.com/sqlfluff/sqlfluff/pull/3353) [tunetheweb](https://github.com/tunetheweb)
* MySQL: Added support for multiple variables in `SET` statement. [3328](https://github.com/sqlfluff/sqlfluff/pull/3328) [cgkoutzigiannis](https://github.com/cgkoutzigiannis)
* SOQL: Support `date_n_literal` [3344](https://github.com/sqlfluff/sqlfluff/pull/3344) [greg-finley](https://github.com/greg-finley)
* Update Docs: Getting Started and Index [3339](https://github.com/sqlfluff/sqlfluff/pull/3339) [mdahlman](https://github.com/mdahlman)
* SOQL: Disable L026 rule [3338](https://github.com/sqlfluff/sqlfluff/pull/3338) [greg-finley](https://github.com/greg-finley)
* Fix critical parse error logged after L003 fix [3337](https://github.com/sqlfluff/sqlfluff/pull/3337) [barrywhart](https://github.com/barrywhart)
* SOQL: Disallow non-`SELECT` statements [3329](https://github.com/sqlfluff/sqlfluff/pull/3329) [greg-finley](https://github.com/greg-finley)
* ci: bump github actions [3336](https://github.com/sqlfluff/sqlfluff/pull/3336) [Fdawgs](https://github.com/Fdawgs)
* Start SOQL dialect [3312](https://github.com/sqlfluff/sqlfluff/pull/3312) [greg-finley](https://github.com/greg-finley)
* Hive: support `CLUSTER`, `DISTRIBUTE`, `SORT BY` [3304](https://github.com/sqlfluff/sqlfluff/pull/3304) [barunpuri](https://github.com/barunpuri)
* Fix typo in Configuration documentation [3319](https://github.com/sqlfluff/sqlfluff/pull/3319) [mdahlman](https://github.com/mdahlman)
* L011: Support `MERGE` statements [3292](https://github.com/sqlfluff/sqlfluff/pull/3292) [tunetheweb](https://github.com/tunetheweb)
* BigQuery: Add workaround to fix false-positves of L063 [3306](https://github.com/sqlfluff/sqlfluff/pull/3306) [dmohns](https://github.com/dmohns)
* Snowflake: `REMOVE` statement rework [3308](https://github.com/sqlfluff/sqlfluff/pull/3308) [jmc-bbk](https://github.com/jmc-bbk)
* Snowflake: `PUT` statement [3307](https://github.com/sqlfluff/sqlfluff/pull/3307) [jmc-bbk](https://github.com/jmc-bbk)
* Snowflake: `GET` statement [3305](https://github.com/sqlfluff/sqlfluff/pull/3305) [jmc-bbk](https://github.com/jmc-bbk)
* Snowflake: Support `ALTER EXTERNAL TABLE` [3302](https://github.com/sqlfluff/sqlfluff/pull/3302) [jmc-bbk](https://github.com/jmc-bbk)
* T-SQL: Fix `PIVOT` placement [3298](https://github.com/sqlfluff/sqlfluff/pull/3298) [jpers36](https://github.com/jpers36)
* Cleanup role references [3287](https://github.com/sqlfluff/sqlfluff/pull/3287) [tunetheweb](https://github.com/tunetheweb)
* Adding Typeform and videoask into inthewild.rst [3296](https://github.com/sqlfluff/sqlfluff/pull/3296) [omonereo-tf](https://github.com/omonereo-tf)
* Snowflake: `LIST` statement enhancement [3295](https://github.com/sqlfluff/sqlfluff/pull/3295) [jmc-bbk](https://github.com/jmc-bbk)
* MySQL: Support `CREATE USER` [3289](https://github.com/sqlfluff/sqlfluff/pull/3289) [greg-finley](https://github.com/greg-finley)
* Snowflake: CREATE STAGE grammar enhancement for file formats [3293](https://github.com/sqlfluff/sqlfluff/pull/3293) [jmc-bbk](https://github.com/jmc-bbk)
* T-SQL: Complete support for `DELETE` statement [3285](https://github.com/sqlfluff/sqlfluff/pull/3285) [pguyot](https://github.com/pguyot)
* MySQL: Support account names [3286](https://github.com/sqlfluff/sqlfluff/pull/3286) [greg-finley](https://github.com/greg-finley)
* L028: In T-SQL dialect, table variables cannot be used to qualify references [3283](https://github.com/sqlfluff/sqlfluff/pull/3283) [barrywhart](https://github.com/barrywhart)
* L007: An operator on a line by itself is okay [3281](https://github.com/sqlfluff/sqlfluff/pull/3281) [barrywhart](https://github.com/barrywhart)
* L046 (spaces around Jinja tags) should check all slices in a segment [3279](https://github.com/sqlfluff/sqlfluff/pull/3279) [barrywhart](https://github.com/barrywhart)
* L003 bug fix: Not ignoring templated newline [3278](https://github.com/sqlfluff/sqlfluff/pull/3278) [barrywhart](https://github.com/barrywhart)

New Contributors

* [omonereo-tf](https://github.com/omonereo-tf) made their first contribution in [#3296](https://github.com/sqlfluff/sqlfluff/pull/3296)
* [mdahlman](https://github.com/mdahlman) made their first contribution in [#3319](https://github.com/sqlfluff/sqlfluff/pull/3319)
* [cgkoutzigiannis](https://github.com/cgkoutzigiannis) made their first contribution in [#3328](https://github.com/sqlfluff/sqlfluff/pull/3328)

Highlights
Major changes include:
* Addition of "rule groups" (currently `core` and `all`) to allow ease of turning on and off groups of rules.
* Addition of `db2` dialect
* PRS errors are now highlighted in red.
* Many bugs fixes and dialect improvements

What’s Changed
* Allow optional `AS` in `MERGE` statements using `SELECT` [3276](https://github.com/sqlfluff/sqlfluff/pull/3276) [tunetheweb](https://github.com/tunetheweb)
* Add groups each rule is in to Rules documentation [3272](https://github.com/sqlfluff/sqlfluff/pull/3272) [tunetheweb](https://github.com/tunetheweb)
* BigQuery: Enhanced `EXPORT DATA` statement [3267](https://github.com/sqlfluff/sqlfluff/pull/3267) [tunetheweb](https://github.com/tunetheweb)
* BigQuery: `CREATE TABLE` support for `COPY` and `LIKE` [3266](https://github.com/sqlfluff/sqlfluff/pull/3266) [tunetheweb](https://github.com/tunetheweb)
* Improve error on missing keywords [3268](https://github.com/sqlfluff/sqlfluff/pull/3268) [greg-finley](https://github.com/greg-finley)
* MySQL: Add `FLUSH` support [3269](https://github.com/sqlfluff/sqlfluff/pull/3269) [greg-finley](https://github.com/greg-finley)
* Postgres: Add `ALTER TYPE` support [3265](https://github.com/sqlfluff/sqlfluff/pull/3265) [greg-finley](https://github.com/greg-finley)
* Bug fix: L036 handle single-column `SELECT` with comment on same line as `SELECT` keyword [3259](https://github.com/sqlfluff/sqlfluff/pull/3259) [barrywhart](https://github.com/barrywhart)
* Put working example in the README [3261](https://github.com/sqlfluff/sqlfluff/pull/3261) [greg-finley](https://github.com/greg-finley)
* Snowflake: Add `CREATE FILE FORMAT` Support [3104](https://github.com/sqlfluff/sqlfluff/pull/3104) [jmc-bbk](https://github.com/jmc-bbk)
* Bug fix: Disable L059 in snowflake dialect [3260](https://github.com/sqlfluff/sqlfluff/pull/3260) [barrywhart](https://github.com/barrywhart)
* Remove redundant `Anything()` from `match_grammars` [3258](https://github.com/sqlfluff/sqlfluff/pull/3258) [tunetheweb](https://github.com/tunetheweb)
* Postgres: Add `DOMAIN` support [3257](https://github.com/sqlfluff/sqlfluff/pull/3257) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Allow optional brackets with `EXECUTE` [3255](https://github.com/sqlfluff/sqlfluff/pull/3255) [pguyot](https://github.com/pguyot)
* Add rule groups and a core rules group [3142](https://github.com/sqlfluff/sqlfluff/pull/3142) [pwildenhain](https://github.com/pwildenhain)
* MySQL: Better `UNSIGNED` support [3250](https://github.com/sqlfluff/sqlfluff/pull/3250) [tunetheweb](https://github.com/tunetheweb)
* MySQL (and others): Support `DROP TEMPORARY TABLE` [3251](https://github.com/sqlfluff/sqlfluff/pull/3251) [tunetheweb](https://github.com/tunetheweb)
* Add Db2 dialect [3231](https://github.com/sqlfluff/sqlfluff/pull/3231) [ddresslerlegalplans](https://github.com/ddresslerlegalplans)
* BigQuery: Add `CREATE EXTERNAL TABLE` statement [3241](https://github.com/sqlfluff/sqlfluff/pull/3241) [dmohns](https://github.com/dmohns)
* SQLite: Add support for expressions in `CREATE INDEX` columns [3240](https://github.com/sqlfluff/sqlfluff/pull/3240) [tunetheweb](https://github.com/tunetheweb)
* Fix exception in `check_still_complete` and matching in `StartsWith` [3236](https://github.com/sqlfluff/sqlfluff/pull/3236) [tunetheweb](https://github.com/tunetheweb)
* Snowflake: Add Support for `DROP` Statements [3238](https://github.com/sqlfluff/sqlfluff/pull/3238) [chrisalexeev](https://github.com/chrisalexeev)
* Allow YAML generation script to accept arguments when run through `tox` [3233](https://github.com/sqlfluff/sqlfluff/pull/3233) [tunetheweb](https://github.com/tunetheweb)
* Bug fix: Cleanly catch and report errors during `load_macros_from_path` [3239](https://github.com/sqlfluff/sqlfluff/pull/3239) [barrywhart](https://github.com/barrywhart)
* Indent procedure parameters [3234](https://github.com/sqlfluff/sqlfluff/pull/3234) [fdw](https://github.com/fdw)
* Enhance `apply_fixes()` to automatically fix violations of `can_start_end_non_code` [3232](https://github.com/sqlfluff/sqlfluff/pull/3232) [barrywhart](https://github.com/barrywhart)
* T-SQL: Fix `for xml path` identifier [3230](https://github.com/sqlfluff/sqlfluff/pull/3230) [fdw](https://github.com/fdw)
* SparkSQL: Additional Delta Merge Test Cases [3228](https://github.com/sqlfluff/sqlfluff/pull/3228) [R7L208](https://github.com/R7L208)
* Fix bug where L018 warns inappropriately if CTE definition includes a column list [3227](https://github.com/sqlfluff/sqlfluff/pull/3227) [barrywhart](https://github.com/barrywhart)
* BigQuery: Better `STRUCT` support [3217](https://github.com/sqlfluff/sqlfluff/pull/3217) [tunetheweb](https://github.com/tunetheweb)
* Fix bug where L003 and L036 fixes caused a parse error [3221](https://github.com/sqlfluff/sqlfluff/pull/3221) [barrywhart](https://github.com/barrywhart)
* Make `IF EXISTS` work with `UNION` selects [3218](https://github.com/sqlfluff/sqlfluff/pull/3218) [fdw](https://github.com/fdw)
* Fix bug where the `fix_even_unparsable` setting was not being respected in `.sqlfluff` [3220](https://github.com/sqlfluff/sqlfluff/pull/3220) [barrywhart](https://github.com/barrywhart)
* BigQuery: Better `DELETE` table support [3224](https://github.com/sqlfluff/sqlfluff/pull/3224) [tunetheweb](https://github.com/tunetheweb)
* Snowflake: `ALTER MATERIALIZED VIEW` statement [3215](https://github.com/sqlfluff/sqlfluff/pull/3215) [jmc-bbk](https://github.com/jmc-bbk)
* BigQuery: recognise `DATE`, `DATETIME` and `TIME` as a date parts for `EXTRACT` [3209](https://github.com/sqlfluff/sqlfluff/pull/3209) [tunetheweb](https://github.com/tunetheweb)
* Postgres: enhanced `UPDATE` statement support [3203](https://github.com/sqlfluff/sqlfluff/pull/3203) [tunetheweb](https://github.com/tunetheweb)
* Prevent Date Constructors from being changed to double quotes by L064 [3212](https://github.com/sqlfluff/sqlfluff/pull/3212) [tunetheweb](https://github.com/tunetheweb)
* Postgres: Fix `DROP EXTENSION` syntax [3213](https://github.com/sqlfluff/sqlfluff/pull/3213) [tunetheweb](https://github.com/tunetheweb)
* Snowflake: Handle `FLATTEN()` table function aliases correctly in L025, L027, L028 [3194](https://github.com/sqlfluff/sqlfluff/pull/3194) [barrywhart](https://github.com/barrywhart)
* Snowflake: Function `LANGUAGE SQL` [3202](https://github.com/sqlfluff/sqlfluff/pull/3202) [WittierDinosaur](https://github.com/WittierDinosaur)
* Postgres: Enhanced `CREATE MATERIALIZED VIEW` [3204](https://github.com/sqlfluff/sqlfluff/pull/3204) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Support basic `FOR XML` statements [3193](https://github.com/sqlfluff/sqlfluff/pull/3193) [fdw](https://github.com/fdw)
* T-SQL: Fix cursor syntax [3192](https://github.com/sqlfluff/sqlfluff/pull/3192) [fdw](https://github.com/fdw)
* Snowflake: `REMOVE` statement enhancement [3191](https://github.com/sqlfluff/sqlfluff/pull/3191) [jmc-bbk](https://github.com/jmc-bbk)
* Snowflake: Moved `VIEW` to unreserved keywords [3190](https://github.com/sqlfluff/sqlfluff/pull/3190) [WittierDinosaur](https://github.com/WittierDinosaur)
* BigQuery: Support `EXPORT DATA` [3177](https://github.com/sqlfluff/sqlfluff/pull/3177) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Fix exception when using variable names in `FROM` clause [3175](https://github.com/sqlfluff/sqlfluff/pull/3175) [tunetheweb](https://github.com/tunetheweb)
* Fix bug where `encoding` setting in .sqlfluff file was not being respected [3170](https://github.com/sqlfluff/sqlfluff/pull/3170) [barrywhart](https://github.com/barrywhart)
* Highlight `PRS` errors in red [3168](https://github.com/sqlfluff/sqlfluff/pull/3168) [OTooleMichael](https://github.com/OTooleMichael)
* Remove unnecessary `StartsWith` and make `terminator` mandatory when using it [3165](https://github.com/sqlfluff/sqlfluff/pull/3165) [tunetheweb](https://github.com/tunetheweb)
* Postgres: Support Composite Types [3167](https://github.com/sqlfluff/sqlfluff/pull/3167) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Support opening, closing, deallocating and fetching cursors [3166](https://github.com/sqlfluff/sqlfluff/pull/3166) [fdw](https://github.com/fdw)
* T-SQL: Add declaration of cursors [3164](https://github.com/sqlfluff/sqlfluff/pull/3164) [fdw](https://github.com/fdw)
* Missed 3151 from CHANGELOG [3163](https://github.com/sqlfluff/sqlfluff/pull/3163) [tunetheweb](https://github.com/tunetheweb)
* Bug fix: L028 sometimes makes incorrect fix when there are subqueries [3156](https://github.com/sqlfluff/sqlfluff/pull/3156) [barrywhart](https://github.com/barrywhart)
* T-SQL: Support `OUTPUT INTO` [3162](https://github.com/sqlfluff/sqlfluff/pull/3162) [fdw](https://github.com/fdw)
* T-SQL: Add `CREATE TYPE` statement [3154](https://github.com/sqlfluff/sqlfluff/pull/3154) [fdw](https://github.com/fdw)
* Hive: Support`TABLESAMPLE` [3159](https://github.com/sqlfluff/sqlfluff/pull/3159) [barunpuri](https://github.com/barunpuri)
* Hive: Support back quoted identifier and literal [3158](https://github.com/sqlfluff/sqlfluff/pull/3158) [barunpuri](https://github.com/barunpuri)
* T-SQL: Add table hints to `INSERT` and `DELETE` [3155](https://github.com/sqlfluff/sqlfluff/pull/3155) [fdw](https://github.com/fdw)


New Contributors
* [ddresslerlegalplans](https://github.com/ddresslerlegalplans) made their first contribution in [#3231](https://github.com/sqlfluff/sqlfluff/pull/3231)
* [greg-finley](https://github.com/greg-finley) made their first contribution in [#3261](https://github.com/sqlfluff/sqlfluff/pull/3261)

Highlights
Major changes include:
* New Rule (L064) for preferred quotes for quoted literals
* Rule speed improvements and fixing performance regression from 0.12.0
* Add configuration option to disallow hanging indents in L003
* Add `ignore_words_regex` configuration option for rules
* New GitHub Annotations option
* Many bug fixes and dialect improvements

What’s Changed
* Redshift: Fix CREATE TABLE column constraints and COPY [3151](https://github.com/sqlfluff/sqlfluff/pull/3151) [tunetheweb](https://github.com/tunetheweb)
* New Rule L064: Consistent usage of preferred quotes for quoted literals [3118](https://github.com/sqlfluff/sqlfluff/pull/3118) [dmohns](https://github.com/dmohns)
* L025 bug fix: stop incorrectly flagging on nested inner joins [3145](https://github.com/sqlfluff/sqlfluff/pull/3145) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Add labels, as well as `GRANT`/`DENY`/`REVOKE` [3149](https://github.com/sqlfluff/sqlfluff/pull/3149) [tunetheweb](https://github.com/tunetheweb)
* Snowflake: allow bracketless `VALUES` in `FROM` clauses [3141](https://github.com/sqlfluff/sqlfluff/pull/3141) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Support `TRY_CONVERT` [3143](https://github.com/sqlfluff/sqlfluff/pull/3143) [fdw](https://github.com/fdw)
* T-SQL: Support `NVARCHAR(MAX)` [3130](https://github.com/sqlfluff/sqlfluff/pull/3130) [fdw](https://github.com/fdw)
* Allow column-less `INSERT INTO` with bracketed `SELECT` in ANSI and BigQuery [3139](https://github.com/sqlfluff/sqlfluff/pull/3139) [tunetheweb](https://github.com/tunetheweb)
* Hive: Support dynamic partition insert [3126](https://github.com/sqlfluff/sqlfluff/pull/3126) [barunpuri](https://github.com/barunpuri)
* T-SQL - `ALTER TABLE` - add support for `WITH CHECK ADD CONSTRAINT` and `CHECK CONSTRAINT` [3132](https://github.com/sqlfluff/sqlfluff/pull/3132) [nevado](https://github.com/nevado)
* TSQL: Support names for transactions [3129](https://github.com/sqlfluff/sqlfluff/pull/3129) [fdw](https://github.com/fdw)
* Snowflake: `StartsWith()` in `FromExpressionElementSegment` caused performance issues for large queries [3128](https://github.com/sqlfluff/sqlfluff/pull/3128) [WittierDinosaur](https://github.com/WittierDinosaur)
* Fix parsing of Compound Statements [3121](https://github.com/sqlfluff/sqlfluff/pull/3121) [jonyscathe](https://github.com/jonyscathe)
* SparkSQL: Update to support all valid Literal Types [3102](https://github.com/sqlfluff/sqlfluff/pull/3102) [R7L208](https://github.com/R7L208)
* TSQL: Exclude non-function-name keywords from function names [3112](https://github.com/sqlfluff/sqlfluff/pull/3112) [jpers36](https://github.com/jpers36)
* ANSI `AT TIME ZONE` parsing improvements [3115](https://github.com/sqlfluff/sqlfluff/pull/3115) [tunetheweb](https://github.com/tunetheweb)
* When fixing a file, preserve the input file's permissions [3114](https://github.com/sqlfluff/sqlfluff/pull/3114) [barrywhart](https://github.com/barrywhart)
* Bug: L058 (flatten nested `CASE`) triggers incorrectly (the `ELSE` contains additional code) [3113](https://github.com/sqlfluff/sqlfluff/pull/3113) [barrywhart](https://github.com/barrywhart)
* Bug fix: Handle "lint" human-format file output correctly [3109](https://github.com/sqlfluff/sqlfluff/pull/3109) [barrywhart](https://github.com/barrywhart)
* L003: Add configuration option to disallow hanging indents [3063](https://github.com/sqlfluff/sqlfluff/pull/3063) [dmohns](https://github.com/dmohns)
* Add native Github-actions output [3107](https://github.com/sqlfluff/sqlfluff/pull/3107) [dmohns](https://github.com/dmohns)
* Improved signed literal parsing [3108](https://github.com/sqlfluff/sqlfluff/pull/3108) [tunetheweb](https://github.com/tunetheweb)
* Don't allow fixes to span template blocks [3105](https://github.com/sqlfluff/sqlfluff/pull/3105) [barrywhart](https://github.com/barrywhart)
* Add `ignore_words_regex` configuration option [3098](https://github.com/sqlfluff/sqlfluff/pull/3098) [dmohns](https://github.com/dmohns)
* Redshift: Better `AT TIME ZONE` support [3087](https://github.com/sqlfluff/sqlfluff/pull/3087) [tunetheweb](https://github.com/tunetheweb)
* Fix In The Wild typo [3100](https://github.com/sqlfluff/sqlfluff/pull/3100) [sivaraam](https://github.com/sivaraam)
* Snowflake: Add Create Storage Integration grammar. [3075](https://github.com/sqlfluff/sqlfluff/pull/3075) [jmc-bbk](https://github.com/jmc-bbk)
* ANSI: Allow `indented_using_on` in `MERGE` statements `ON` [3096](https://github.com/sqlfluff/sqlfluff/pull/3096) [dmohns](https://github.com/dmohns)
* Postgres: Support `COLLATE` in more clauses [3095](https://github.com/sqlfluff/sqlfluff/pull/3095) [tunetheweb](https://github.com/tunetheweb)
* BigQuery: Support `NORMALIZE` function [3086](https://github.com/sqlfluff/sqlfluff/pull/3086) [tunetheweb](https://github.com/tunetheweb)
* ANSI (and other dialects): Add `DROP FUNCTION` support [3082](https://github.com/sqlfluff/sqlfluff/pull/3082) [tunetheweb](https://github.com/tunetheweb)
* Postgres: Support `DROP EXTENSION` [3083](https://github.com/sqlfluff/sqlfluff/pull/3083) [tunetheweb](https://github.com/tunetheweb)
* Snowflake: Fix bug in Describe Statement [3076](https://github.com/sqlfluff/sqlfluff/pull/3076) [jmc-bbk](https://github.com/jmc-bbk)
* Update individual rules to take advantage of core rule processing changes [3041](https://github.com/sqlfluff/sqlfluff/pull/3041) [barrywhart](https://github.com/barrywhart)
* L003 forgives non misbalanced Jinja tags [3065](https://github.com/sqlfluff/sqlfluff/pull/3065) [OTooleMichael](https://github.com/OTooleMichael)
* Fix tsql dialect `EXEC = Variable StoredProc` Failed Parsing Bug (3070) [3077](https://github.com/sqlfluff/sqlfluff/pull/3077) [MartynJones87](https://github.com/MartynJones87)
* Snowflake Dialect: Add External Function DDL [3071](https://github.com/sqlfluff/sqlfluff/pull/3071) [chrisalexeev](https://github.com/chrisalexeev)
* SparkSQL: Support for Delta `UPDATE` statement syntax [3073](https://github.com/sqlfluff/sqlfluff/pull/3073) [R7L208](https://github.com/R7L208)
* SparkSQL: Test cases for Delta `DELETE FROM` syntax [3072](https://github.com/sqlfluff/sqlfluff/pull/3072) [R7L208](https://github.com/R7L208)
* Postgres: Support quoted `LANGUAGE` params [3068](https://github.com/sqlfluff/sqlfluff/pull/3068) [tunetheweb](https://github.com/tunetheweb)
* Fix bug handling Jinja set with multiple vars, e.g.: `{% set a, b = 1, 2 %}` [3066](https://github.com/sqlfluff/sqlfluff/pull/3066) [barrywhart](https://github.com/barrywhart)
* L007 should ignore templated newlines [3067](https://github.com/sqlfluff/sqlfluff/pull/3067) [barrywhart](https://github.com/barrywhart)
* Allow aliases to pass L028 [3062](https://github.com/sqlfluff/sqlfluff/pull/3062) [tunetheweb](https://github.com/tunetheweb)
* Refactor core rule processing for flexibility and speed [3061](https://github.com/sqlfluff/sqlfluff/pull/3061) [barrywhart](https://github.com/barrywhart)
* Add editorconfig and precommit for SQL and YML files [3058](https://github.com/sqlfluff/sqlfluff/pull/3058) [tunetheweb](https://github.com/tunetheweb)
* Rule L003 performance: Cache the line number and last newline position [3060](https://github.com/sqlfluff/sqlfluff/pull/3060) [barrywhart](https://github.com/barrywhart)
* Fixed documentation for `sql_file_exts` example [3059](https://github.com/sqlfluff/sqlfluff/pull/3059) [KulykDmytro](https://github.com/KulykDmytro)
* BigQuery: Support `SAFE` functions [3048](https://github.com/sqlfluff/sqlfluff/pull/3048) [tunetheweb](https://github.com/tunetheweb)
* Postgres: Fix `UNNEST` for L025 [3054](https://github.com/sqlfluff/sqlfluff/pull/3054) [tunetheweb](https://github.com/tunetheweb)
* Exasol: `CREATE/DROP/ALTER USER/ROLE` clean up for consistency [3045](https://github.com/sqlfluff/sqlfluff/pull/3045) [tunetheweb](https://github.com/tunetheweb)
* Postgres add `ALTER ROLE`/`ALTER USER` support [3043](https://github.com/sqlfluff/sqlfluff/pull/3043) [mrf](https://github.com/mrf)
* Add CarePay to SQLFluff in the wild [3038](https://github.com/sqlfluff/sqlfluff/pull/3038) [pvonglehn](https://github.com/pvonglehn)
* Postgres: Add `ON CONFLICT` Grammar [3027](https://github.com/sqlfluff/sqlfluff/pull/3027) [jmc-bbk](https://github.com/jmc-bbk)
* Add dialect to Docker test [3033](https://github.com/sqlfluff/sqlfluff/pull/3033) [tunetheweb](https://github.com/tunetheweb)

New Contributors
* [chrisalexeev](https://github.com/chrisalexeev) made their first contribution in [#3071](https://github.com/sqlfluff/sqlfluff/pull/3071)
* [MartynJones87](https://github.com/MartynJones87) made their first contribution in [#3077](https://github.com/sqlfluff/sqlfluff/pull/3077)
* [sivaraam](https://github.com/sivaraam) made their first contribution in [#3100](https://github.com/sqlfluff/sqlfluff/pull/3100)
* [jonyscathe](https://github.com/jonyscathe) made their first contribution in [#3121](https://github.com/sqlfluff/sqlfluff/pull/3121)
* [barunpuri](https://github.com/barunpuri) made their first contribution in [#3126](https://github.com/sqlfluff/sqlfluff/pull/3126)

Highlights
Major changes include:
* Dialect is now mandatory, either in command line, or in config **BREAKING CHANGE**
* Rename `spark3` dialect to `sparksql` **BREAKING CHANGE**
* L027 now checks tables references exist **BREAKING CHANGE**
* New rule L063 to allow Datatypes to have a different capitalisation policy from L010. **BREAKING CHANGE**
* Refactor and performance improvements of Delimited and L003
* Many dialect improvements and fixes

What’s Changed
* MySQL: Allow `JOIN`s in `UPDATE` expressions [3031](https://github.com/sqlfluff/sqlfluff/pull/3031) [zapion](https://github.com/zapion)
* Fix bug in patch generation for segments made of templated + literal fixes [3030](https://github.com/sqlfluff/sqlfluff/pull/3030) [barrywhart](https://github.com/barrywhart)
* Formatters code cleanup [3029](https://github.com/sqlfluff/sqlfluff/pull/3029) [barrywhart](https://github.com/barrywhart)
* Postgres better `CREATE USER`/`CREATE ROLE` support [3016](https://github.com/sqlfluff/sqlfluff/pull/3016) [mrf](https://github.com/mrf)
* SparkSQL: Add `MERGE` syntax [3025](https://github.com/sqlfluff/sqlfluff/pull/3025) [PhilippLange](https://github.com/PhilippLange)
* Remove Delimited workarounds [3024](https://github.com/sqlfluff/sqlfluff/pull/3024) [tunetheweb](https://github.com/tunetheweb)
* Add `exclude` option for `Ref` grammar [3028](https://github.com/sqlfluff/sqlfluff/pull/3028) [tunetheweb](https://github.com/tunetheweb)
* SparkSQL: Adding support for Delta Lake table schema updates [3013](https://github.com/sqlfluff/sqlfluff/pull/3013) [R7L208](https://github.com/R7L208)
* L027: Check table aliases exists [2998](https://github.com/sqlfluff/sqlfluff/pull/2998) [dmohns](https://github.com/dmohns)
* Snowflake: Added support for `REMOVE` statements [3026](https://github.com/sqlfluff/sqlfluff/pull/3026) [WittierDinosaur](https://github.com/WittierDinosaur)
* BigQuery: Support `WEEK` function with days of weeks [3021](https://github.com/sqlfluff/sqlfluff/pull/3021) [tunetheweb](https://github.com/tunetheweb)
* Sparksql quoted identifier in `STRUCT` [3023](https://github.com/sqlfluff/sqlfluff/pull/3023) [PhilippLange](https://github.com/PhilippLange)
* Force user to specify a dialect [2995](https://github.com/sqlfluff/sqlfluff/pull/2995) [barrywhart](https://github.com/barrywhart)
* BigQuery: Parse `CREATE TABLE` with trailing comma [3018](https://github.com/sqlfluff/sqlfluff/pull/3018) [dmohns](https://github.com/dmohns)
* Snowflake: Add `IS (NOT) DISTINCT FROM` test cases [3014](https://github.com/sqlfluff/sqlfluff/pull/3014) [kd2718](https://github.com/kd2718)
* BigQuery: Add support for column `OPTIONS` in `STRUCT` definitions [3017](https://github.com/sqlfluff/sqlfluff/pull/3017) [dmohns](https://github.com/dmohns)
* PostgreSQL: added support for `CREATE ROLE` and `DROP ROLE` statements [3010](https://github.com/sqlfluff/sqlfluff/pull/3010) [dnim](https://github.com/dnim)
* Separate slow CI job to it's own workflow [3012](https://github.com/sqlfluff/sqlfluff/pull/3012) [tunetheweb](https://github.com/tunetheweb)
* SparkSQL: Test cases for Delta Variation of Writing a table [3009](https://github.com/sqlfluff/sqlfluff/pull/3009) [R7L208](https://github.com/R7L208)
* Snowflake: Added support for `CLUSTER BY` and other `CREATE TABLE` improvements [3008](https://github.com/sqlfluff/sqlfluff/pull/3008) [WittierDinosaur](https://github.com/WittierDinosaur)
* Support `TRIM` function parameters [3007](https://github.com/sqlfluff/sqlfluff/pull/3007) [tunetheweb](https://github.com/tunetheweb)
* BigQuery: Support `AT TIME ZONE` in `EXTRACT` [3004](https://github.com/sqlfluff/sqlfluff/pull/3004) [tunetheweb](https://github.com/tunetheweb)
* BigQuery: Move some keywords to unreserved [3002](https://github.com/sqlfluff/sqlfluff/pull/3002) [tunetheweb](https://github.com/tunetheweb)
* BigQuery: Allow quoted variable names in `DECLARE` [3006](https://github.com/sqlfluff/sqlfluff/pull/3006) [dmohns](https://github.com/dmohns)
* T-SQL: allow optional `AS` keyword in parameters def [3001](https://github.com/sqlfluff/sqlfluff/pull/3001) [pguyot](https://github.com/pguyot)
* T-SQL: add support for `RETURNS var TABLE` syntax [3000](https://github.com/sqlfluff/sqlfluff/pull/3000) [pguyot](https://github.com/pguyot)
* T-SQL: add support for parenthesized nested joins [2993](https://github.com/sqlfluff/sqlfluff/pull/2993) [pguyot](https://github.com/pguyot)
* dbt: Read builtins from code [2988](https://github.com/sqlfluff/sqlfluff/pull/2988) [dmohns](https://github.com/dmohns)
* T-SQL: fix table type in `DECLARE` statements [2999](https://github.com/sqlfluff/sqlfluff/pull/2999) [pguyot](https://github.com/pguyot)
* T-SQL: allow leading `GO` [2997](https://github.com/sqlfluff/sqlfluff/pull/2997) [pguyot](https://github.com/pguyot)
* T-SQL: add support for assignment operators [2996](https://github.com/sqlfluff/sqlfluff/pull/2996) [pguyot](https://github.com/pguyot)
* BigQuery: Add more `MERGE` statement variants [2989](https://github.com/sqlfluff/sqlfluff/pull/2989) [dmohns](https://github.com/dmohns)
* L041: Fix bug when there is a newline after the select clause modifier [2981](https://github.com/sqlfluff/sqlfluff/pull/2981) [jmc-bbk](https://github.com/jmc-bbk)
* Rule L045 doesn't recognise CTE usage in a subquery when rule L042 is enabled [2980](https://github.com/sqlfluff/sqlfluff/pull/2980) [barrywhart](https://github.com/barrywhart)
* dbt: Make `is_incremental()` defaults consistent [2985](https://github.com/sqlfluff/sqlfluff/pull/2985) [dmohns](https://github.com/dmohns)
* Rename Grammars for consistency [2986](https://github.com/sqlfluff/sqlfluff/pull/2986) [tunetheweb](https://github.com/tunetheweb)
* Added support for MySQL `UPDATE` Statements [2982](https://github.com/sqlfluff/sqlfluff/pull/2982) [WittierDinosaur](https://github.com/WittierDinosaur)
* Redshift: Added `CREATE EXTERNAL SCHEMA`, bugfix in `PARTITION BY` [2983](https://github.com/sqlfluff/sqlfluff/pull/2983) [WittierDinosaur](https://github.com/WittierDinosaur)
* Added `ALTER INDEX` and `REINDEX` to Postgres, Some Grammar Cleaning [2979](https://github.com/sqlfluff/sqlfluff/pull/2979) [WittierDinosaur](https://github.com/WittierDinosaur)
* T-SQL grammar deduplication [2967](https://github.com/sqlfluff/sqlfluff/pull/2967) [tunetheweb](https://github.com/tunetheweb)
* L003 Refactor [2884](https://github.com/sqlfluff/sqlfluff/pull/2884) [OTooleMichael](https://github.com/OTooleMichael)
* Delimited Refactor [2831](https://github.com/sqlfluff/sqlfluff/pull/2831) [WittierDinosaur](https://github.com/WittierDinosaur)
* SparkSQL: Support for querying snapshots when reading data with Delta Lake [2972](https://github.com/sqlfluff/sqlfluff/pull/2972) [R7L208](https://github.com/R7L208)
* Fix bug in L063 for BigQuery `STRUCT` params [2975](https://github.com/sqlfluff/sqlfluff/pull/2975) [tunetheweb](https://github.com/tunetheweb)
* Fix assertion error in dbt templater when file ends with whitespace strip (`-%}`) [2976](https://github.com/sqlfluff/sqlfluff/pull/2976) [barrywhart](https://github.com/barrywhart)
* Pass dbt vars to dbt [2923](https://github.com/sqlfluff/sqlfluff/pull/2923) [tcholewik](https://github.com/tcholewik)
* BigQuery: Add support for column `OPTIONS` [2973](https://github.com/sqlfluff/sqlfluff/pull/2973) [dmohns](https://github.com/dmohns)
* BigQuery: Allow expressions in `OPTIONS` clauses [2971](https://github.com/sqlfluff/sqlfluff/pull/2971) [dmohns](https://github.com/dmohns)
* Bump black to 22.3.0 on pre-commit [2969](https://github.com/sqlfluff/sqlfluff/pull/2969) [pguyot](https://github.com/pguyot)
* T-SQL: Redefine `DatatypeIdentifierSegment` [2959](https://github.com/sqlfluff/sqlfluff/pull/2959) [alanmcruickshank](https://github.com/alanmcruickshank)
* T-SQL: Add support for `WAITFOR` statement [2968](https://github.com/sqlfluff/sqlfluff/pull/2968) [pguyot](https://github.com/pguyot)
* T-SQL: Add `WHILE` statement support [2966](https://github.com/sqlfluff/sqlfluff/pull/2966) [pguyot](https://github.com/pguyot)
* T-SQL: `INTO` is optional within `INSERT` statement [2963](https://github.com/sqlfluff/sqlfluff/pull/2963) [pguyot](https://github.com/pguyot)
* Add basic `IS (NOT) DISTINCT FROM` support in most dialects [2962](https://github.com/sqlfluff/sqlfluff/pull/2962) [tunetheweb](https://github.com/tunetheweb)
* SparkSQL: Create Table Delta Lake Variant [2954](https://github.com/sqlfluff/sqlfluff/pull/2954) [R7L208](https://github.com/R7L208)
* T-SQL: Add support for `CREATE`/`DROP`/`DISABLE` `TRIGGER` [2957](https://github.com/sqlfluff/sqlfluff/pull/2957) [tunetheweb](https://github.com/tunetheweb)
* Bug: L042 modifies parse tree even during "lint" [2955](https://github.com/sqlfluff/sqlfluff/pull/2955) [barrywhart](https://github.com/barrywhart)
* Allow multiple post function clauses in Postgres and Redshift [2952](https://github.com/sqlfluff/sqlfluff/pull/2952) [aviv](https://github.com/aviv)
* Fix bug in L022 for trailing comments in CTE [2946](https://github.com/sqlfluff/sqlfluff/pull/2946) [tunetheweb](https://github.com/tunetheweb)
* More dialect checking, fixes, inheritance cleanup [2942](https://github.com/sqlfluff/sqlfluff/pull/2942) [barrywhart](https://github.com/barrywhart)
* T-SQL: Support `OUTPUT` Params and `GOTO` Statements [2949](https://github.com/sqlfluff/sqlfluff/pull/2949) [tunetheweb](https://github.com/tunetheweb)
* BREAKING CHANGE: change existing dialect name from `spark3` to `sparksql` [2924](https://github.com/sqlfluff/sqlfluff/pull/2924) [R7L208](https://github.com/R7L208)
* Add Symend to SQLFluff In The Wild [2940](https://github.com/sqlfluff/sqlfluff/pull/2940) [HeyZiko](https://github.com/HeyZiko)
* Simplify segment creation and inheritance in dialects [2933](https://github.com/sqlfluff/sqlfluff/pull/2933) [barrywhart](https://github.com/barrywhart)
* Snowflake: Add `ALTER STREAM` support [2939](https://github.com/sqlfluff/sqlfluff/pull/2939) [HeyZiko](https://github.com/HeyZiko)
* T-SQL: Handle multiple nested joins [2938](https://github.com/sqlfluff/sqlfluff/pull/2938) [tunetheweb](https://github.com/tunetheweb)
* Snowflake: Add `CREATE STREAM` support [2936](https://github.com/sqlfluff/sqlfluff/pull/2936) [HeyZiko](https://github.com/HeyZiko)
* T-SQL: Support nested joins [2928](https://github.com/sqlfluff/sqlfluff/pull/2928) [tunetheweb](https://github.com/tunetheweb)
* To replace base dialect segment class, must subclass or provide same stuff [2930](https://github.com/sqlfluff/sqlfluff/pull/2930) [barrywhart](https://github.com/barrywhart)
* Add new rule L063 to allow separate capitalisation policy for Datatypes [2931](https://github.com/sqlfluff/sqlfluff/pull/2931) [tunetheweb](https://github.com/tunetheweb)
* Adds support for column definitions in table alias expressions [2932](https://github.com/sqlfluff/sqlfluff/pull/2932) [derickl](https://github.com/derickl)
* BigQuery: support numeric aliases in `UNPIVOT` clauses [2925](https://github.com/sqlfluff/sqlfluff/pull/2925) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Supported nested `MERGE` statements [2926](https://github.com/sqlfluff/sqlfluff/pull/2926) [tunetheweb](https://github.com/tunetheweb)

New Contributors
* [HeyZiko](https://github.com/HeyZiko) made their first contribution in [#2936](https://github.com/sqlfluff/sqlfluff/pull/2936)
* [aviv](https://github.com/aviv) made their first contribution in [#2952](https://github.com/sqlfluff/sqlfluff/pull/2952)
* [pguyot](https://github.com/pguyot) made their first contribution in [#2963](https://github.com/sqlfluff/sqlfluff/pull/2963)
* [dmohns](https://github.com/dmohns) made their first contribution in [#2971](https://github.com/sqlfluff/sqlfluff/pull/2971)
* [tcholewik](https://github.com/tcholewik) made their first contribution in [#2923](https://github.com/sqlfluff/sqlfluff/pull/2923)
* [jmc-bbk](https://github.com/jmc-bbk) made their first contribution in [#2981](https://github.com/sqlfluff/sqlfluff/pull/2981)
* [dnim](https://github.com/dnim) made their first contribution in [#3010](https://github.com/sqlfluff/sqlfluff/pull/3010)
* [kd2718](https://github.com/kd2718) made their first contribution in [#3014](https://github.com/sqlfluff/sqlfluff/pull/3014)
* [mrf](https://github.com/mrf) made their first contribution in [#3016](https://github.com/sqlfluff/sqlfluff/pull/3016)
* [zapion](https://github.com/zapion) made their first contribution in [#3031](https://github.com/sqlfluff/sqlfluff/pull/3031)