Sqlfluff

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)

What’s Changed
* Added Support For Snowflake Inline Comments [2919](https://github.com/sqlfluff/sqlfluff/pull/2919) [WittierDinosaur](https://github.com/WittierDinosaur)
* Spark3: Fix bug which did not allow multiple joins [2917](https://github.com/sqlfluff/sqlfluff/pull/2917) [tunetheweb](https://github.com/tunetheweb)
* Added Snowflake Alter View Support [2915](https://github.com/sqlfluff/sqlfluff/pull/2915) [WittierDinosaur](https://github.com/WittierDinosaur)
* Adjust L010 to ignore nulls and booleans covered by L040 [2913](https://github.com/sqlfluff/sqlfluff/pull/2913) [tunetheweb](https://github.com/tunetheweb)
* Fix bug where L043 corrupts SQL [2908](https://github.com/sqlfluff/sqlfluff/pull/2908) [barrywhart](https://github.com/barrywhart)
* Jinja: Add support for Block Assignments [2907](https://github.com/sqlfluff/sqlfluff/pull/2907) [barrywhart](https://github.com/barrywhart)
* L042 fix fails with missing function `get_identifier()` on Postgres, Redshift dialects [2899](https://github.com/sqlfluff/sqlfluff/pull/2899) [barrywhart](https://github.com/barrywhart)
* BigQuery: Better Set Operators support [2901](https://github.com/sqlfluff/sqlfluff/pull/2901) [tunetheweb](https://github.com/tunetheweb)
* Hive: support for complex types in `cast` `rowtype` definition [2896](https://github.com/sqlfluff/sqlfluff/pull/2896) [KulykDmytro](https://github.com/KulykDmytro)
* Hive: added `json` type support [2894](https://github.com/sqlfluff/sqlfluff/pull/2894) [KulykDmytro](https://github.com/KulykDmytro)
* Hive: fix incorrect L027 error for rowtype attribute name [2893](https://github.com/sqlfluff/sqlfluff/pull/2893) [KulykDmytro](https://github.com/KulykDmytro)
* Hive: Add `ARRAY` support [2891](https://github.com/sqlfluff/sqlfluff/pull/2891) [tunetheweb](https://github.com/tunetheweb)
* Implemented `PIVOT`/`UNPIVOT` Redshift + Fixed Snowflake Bug + Standardized `PIVOT`/`UNPIVOT` Parsing [2888](https://github.com/sqlfluff/sqlfluff/pull/2888) [PLBMR](https://github.com/PLBMR)
* Fix AssertionError in dbt templater when file ends with multiple newlines [2887](https://github.com/sqlfluff/sqlfluff/pull/2887) [barrywhart](https://github.com/barrywhart)
* Hive: Row typecasting in `cast` function [2889](https://github.com/sqlfluff/sqlfluff/pull/2889) [KulykDmytro](https://github.com/KulykDmytro)
* dbt templater should gracefully skip macro files [2886](https://github.com/sqlfluff/sqlfluff/pull/2886) [barrywhart](https://github.com/barrywhart)
* Disable L031 on BigQuery due to complex backtick / project name behavior [2882](https://github.com/sqlfluff/sqlfluff/pull/2882) [barrywhart](https://github.com/barrywhart)
* Documentation: Update dbt templater docs with more detail about pros and cons [2885](https://github.com/sqlfluff/sqlfluff/pull/2885) [barrywhart](https://github.com/barrywhart)
* BigQuery: Better `STRUCT` Array Support [2881](https://github.com/sqlfluff/sqlfluff/pull/2881) [tunetheweb](https://github.com/tunetheweb)
* L042: Detect violations when column is templated [2879](https://github.com/sqlfluff/sqlfluff/pull/2879) [barrywhart](https://github.com/barrywhart)
* Improve parsing of `BETWEEN` statements [2878](https://github.com/sqlfluff/sqlfluff/pull/2878) [MarcAntoineSchmidtQC](https://github.com/MarcAntoineSchmidtQC)

Highlights
Major changes include:
* A number of changes to `fix` code to make these more robust
* Improvements to templating blocks
* `generate_parse_fixture_yml` options to allow quicker, partial regeneration of YML files
* Numerous rule fixes including adding auto fix to L042
* Numerous grammar changes

What’s Changed
* Spark3: Support for `SHOW` statements [2864](https://github.com/sqlfluff/sqlfluff/pull/2864) [R7L208](https://github.com/R7L208)
* Add Markerr to list of organizations using SQLFluff in the wild [2874](https://github.com/sqlfluff/sqlfluff/pull/2874) [kdw2126](https://github.com/kdw2126)
* Refactor JinjaTracer: Split into two classes, break up `_slice_template()` function [2870](https://github.com/sqlfluff/sqlfluff/pull/2870) [barrywhart](https://github.com/barrywhart)
* BigQuery: support Parameterized Numeric Literals [2872](https://github.com/sqlfluff/sqlfluff/pull/2872) [tunetheweb](https://github.com/tunetheweb)
* L042 autofix [2860](https://github.com/sqlfluff/sqlfluff/pull/2860) [OTooleMichael](https://github.com/OTooleMichael)
* Redshift: transaction statement [2852](https://github.com/sqlfluff/sqlfluff/pull/2852) [rpr-ableton](https://github.com/rpr-ableton)
* JinjaTracer fix for endif/endfor inside "set" or "macro" blocks [2868](https://github.com/sqlfluff/sqlfluff/pull/2868) [barrywhart](https://github.com/barrywhart)
* L009: Handle adding newline after `{% endif %}` at end of file [2862](https://github.com/sqlfluff/sqlfluff/pull/2862) [barrywhart](https://github.com/barrywhart)
* Redshift: Add support for `AT TIME ZONE` [2863](https://github.com/sqlfluff/sqlfluff/pull/2863) [tunetheweb](https://github.com/tunetheweb)
* L032 bug fix and fix improvement [2859](https://github.com/sqlfluff/sqlfluff/pull/2859) [OTooleMichael](https://github.com/OTooleMichael)
* Refactor JinjaTracer; store lex output as individual strings where possible [2856](https://github.com/sqlfluff/sqlfluff/pull/2856) [barrywhart](https://github.com/barrywhart)
* Add ability to regenerate subsets of fixture YAMLs (by dialect, or new only) [2850](https://github.com/sqlfluff/sqlfluff/pull/2850) [OTooleMichael](https://github.com/OTooleMichael)
* Fix bug with Jinja and dbt `{% set %}` blocks [2849](https://github.com/sqlfluff/sqlfluff/pull/2849) [barrywhart](https://github.com/barrywhart)
* Bug fix: `ValueError: Position Not Found for lint/parse/fix` in JinjaTracer [2846](https://github.com/sqlfluff/sqlfluff/pull/2846) [barrywhart](https://github.com/barrywhart)
* Reduce unnecessary setting run ci [2847](https://github.com/sqlfluff/sqlfluff/pull/2847) [zhongjiajie](https://github.com/zhongjiajie)
* Spark3: statements to `SET` and `RESET` spark runtime configurations [2839](https://github.com/sqlfluff/sqlfluff/pull/2839) [R7L208](https://github.com/R7L208)
* BigQuery - prevent L006 flagging hyphenated table references [2842](https://github.com/sqlfluff/sqlfluff/pull/2842) [tunetheweb](https://github.com/tunetheweb)
* T-SQL fix `CONVERT` function definition [2843](https://github.com/sqlfluff/sqlfluff/pull/2843) [tunetheweb](https://github.com/tunetheweb)
* Change rule test script from bash to python [2840](https://github.com/sqlfluff/sqlfluff/pull/2840) [OTooleMichael](https://github.com/OTooleMichael)
* Spark3: Support `DESCRIBE` statement [2837](https://github.com/sqlfluff/sqlfluff/pull/2837) [R7L208](https://github.com/R7L208)
* Spark3: Refactor `REFRESH` statements into one class [2838](https://github.com/sqlfluff/sqlfluff/pull/2838) [R7L208](https://github.com/R7L208)
* Prevent rules incorrectly returning conflicting fixes to same position [2830](https://github.com/sqlfluff/sqlfluff/pull/2830) [barrywhart](https://github.com/barrywhart)
* Redshift and BigQuery: Update dateparts values and functions [2829](https://github.com/sqlfluff/sqlfluff/pull/2829) [rpr-ableton](https://github.com/rpr-ableton)
* MySQL add `NOW` support [2825](https://github.com/sqlfluff/sqlfluff/pull/2825) [tunetheweb](https://github.com/tunetheweb)
* MySQL `DELETE FROM` support [2823](https://github.com/sqlfluff/sqlfluff/pull/2823) [tunetheweb](https://github.com/tunetheweb)
* Rule L059 bug with `IF` [2824](https://github.com/sqlfluff/sqlfluff/pull/2824) [tunetheweb](https://github.com/tunetheweb)
* Prevent exceptions when running `fix` on dialect fixtures [2818](https://github.com/sqlfluff/sqlfluff/pull/2818) [tunetheweb](https://github.com/tunetheweb)
* Spark3: Support to handle `CACHE` AND `UNCACHE` auxiliary statements [2814](https://github.com/sqlfluff/sqlfluff/pull/2814) [R7L208](https://github.com/R7L208)
* Fix L036 error on `CREATE VIEW AS SELECT` [2816](https://github.com/sqlfluff/sqlfluff/pull/2816) [tunetheweb](https://github.com/tunetheweb)
* Fixes for the new post-fix parse check [2813](https://github.com/sqlfluff/sqlfluff/pull/2813) [barrywhart](https://github.com/barrywhart)
* Add initial `MERGE` syntax to most dialects [2807](https://github.com/sqlfluff/sqlfluff/pull/2807) [PhilippLange](https://github.com/PhilippLange)
* Automated tests should fail if a lint fix introduces a parse error [2809](https://github.com/sqlfluff/sqlfluff/pull/2809) [barrywhart](https://github.com/barrywhart)

New Contributors
* [kdw2126](https://github.com/kdw2126) made their first contribution in [#2874](https://github.com/sqlfluff/sqlfluff/pull/2874)

Highlights
Major changes include:
* Changes rule L030 to use `extended_capitalisation_policy` to support PascalCase **BREAKING CHANGE**
* Fixes dbt error on ephemeral models
* Log warnings for fixes that seem to corrupt the parse SQL as may cause incorrect fixes in other rules.
* Bug fix to rule L011 for `implicit` aliases
* Bug fix to rule L019 for commas besides templated code
* Rule L051 can now optionally be applied to `LEFT`/`RIGHT`/`OUTER JOIN`s
* Improvements to Test Suite
* Many dialect improvements

What’s Changed
* Exasol: Fix `INTERVAL` literals / expression [2804](https://github.com/sqlfluff/sqlfluff/pull/2804) [sti0](https://github.com/sti0)
* Exasol: Add `IDLE_TIMEOUT` and `SNAPSHOT_MODE` [2805](https://github.com/sqlfluff/sqlfluff/pull/2805) [sti0](https://github.com/sti0)
* Exasol: Support value range clause within `INSERT` statements (7.1+) [2802](https://github.com/sqlfluff/sqlfluff/pull/2802) [sti0](https://github.com/sti0)
* Exasol: Add lua adapter scripts (7.1+) [2801](https://github.com/sqlfluff/sqlfluff/pull/2801) [sti0](https://github.com/sti0)
* Exasol: Add openid support for create/alter user (7.1+) [2800](https://github.com/sqlfluff/sqlfluff/pull/2800) [sti0](https://github.com/sti0)
* Exasol: New consumer group params and unreserved keywords (7.1+) [2799](https://github.com/sqlfluff/sqlfluff/pull/2799) [sti0](https://github.com/sti0)
* Snowflake: Complete `INSERT` grammar [2798](https://github.com/sqlfluff/sqlfluff/pull/2798) [jpy-git](https://github.com/jpy-git)
* Fix Postgres `VALUES`, make Spark3 `VALUES` consistent [2797](https://github.com/sqlfluff/sqlfluff/pull/2797) [jpy-git](https://github.com/jpy-git)
* Postgres: `INSERT DEFAULT` value [2796](https://github.com/sqlfluff/sqlfluff/pull/2796) [jpy-git](https://github.com/jpy-git)
* Postgres: Make `AS` optional in Postgres `DELETE` [2794](https://github.com/sqlfluff/sqlfluff/pull/2794) [jpy-git](https://github.com/jpy-git)
* BigQuery support `UNEST` aliases [2793](https://github.com/sqlfluff/sqlfluff/pull/2793) [tunetheweb](https://github.com/tunetheweb)
* Postgres: Add all range operators [2789](https://github.com/sqlfluff/sqlfluff/pull/2789) [jpy-git](https://github.com/jpy-git)
* Snowflake: Complete `DELETE FROM` grammar [2792](https://github.com/sqlfluff/sqlfluff/pull/2792) [jpy-git](https://github.com/jpy-git)
* Postgres: Complete `DELETE FROM` grammar [2791](https://github.com/sqlfluff/sqlfluff/pull/2791) [jpy-git](https://github.com/jpy-git)
* Postgres: Add `RETURNING` grammar to `INSERT INTO` statement [2790](https://github.com/sqlfluff/sqlfluff/pull/2790) [jpy-git](https://github.com/jpy-git)
* Snowflake: Complete `PATTERN` grammar [2788](https://github.com/sqlfluff/sqlfluff/pull/2788) [jpy-git](https://github.com/jpy-git)
* Redshift: add `[ALTER/CREATE/DROP] PROCEDURE` segments [2774](https://github.com/sqlfluff/sqlfluff/pull/2774) [rpr-ableton](https://github.com/rpr-ableton)
* Spark3: Support for `ANALYZE TABLE` statement [2780](https://github.com/sqlfluff/sqlfluff/pull/2780) [R7L208](https://github.com/R7L208)
* Snowflake: Add `MATCH_RECOGNIZE` clause [2781](https://github.com/sqlfluff/sqlfluff/pull/2781) [jpy-git](https://github.com/jpy-git)
* Snowflake: Complete `LIMIT` grammar [2784](https://github.com/sqlfluff/sqlfluff/pull/2784) [jpy-git](https://github.com/jpy-git)
* Rough autofix for L028 [2757](https://github.com/sqlfluff/sqlfluff/pull/2757) [OTooleMichael](https://github.com/OTooleMichael)
* Spark3 bug: Create with complex data types (2761) [2782](https://github.com/sqlfluff/sqlfluff/pull/2782) [PhilippLange](https://github.com/PhilippLange)
* Snowflake: Complete `LIKE` grammar [2779](https://github.com/sqlfluff/sqlfluff/pull/2779) [jpy-git](https://github.com/jpy-git)
* Spark3: Auxiliary`FILE` and `JAR` statements [2778](https://github.com/sqlfluff/sqlfluff/pull/2778) [R7L208](https://github.com/R7L208)
* Snowflake: Refine `SET`/`UNSET` `MASKING POLICY` grammar [2775](https://github.com/sqlfluff/sqlfluff/pull/2775) [jpy-git](https://github.com/jpy-git)
* L049 bug: correct over zealous `=` --> `IS` [2760](https://github.com/sqlfluff/sqlfluff/pull/2760) [OTooleMichael](https://github.com/OTooleMichael)
* Make extension case insensitive [2773](https://github.com/sqlfluff/sqlfluff/pull/2773) [tunetheweb](https://github.com/tunetheweb)
* Snowflake: Add dollar quoted string literal [2770](https://github.com/sqlfluff/sqlfluff/pull/2770) [jpy-git](https://github.com/jpy-git)
* Bug fix: L036 corrupts `SELECT DISTINCT id` query [2768](https://github.com/sqlfluff/sqlfluff/pull/2768) [barrywhart](https://github.com/barrywhart)
* Snowflake: Add `CHANGES` clause [2764](https://github.com/sqlfluff/sqlfluff/pull/2764) [jpy-git](https://github.com/jpy-git)
* Spark3: Support for `EXPLAIN` statement [2767](https://github.com/sqlfluff/sqlfluff/pull/2767) [R7L208](https://github.com/R7L208)
* Snowflake: Add `CONNECT BY` clause [2763](https://github.com/sqlfluff/sqlfluff/pull/2763) [jpy-git](https://github.com/jpy-git)
* Spark3: Support for `TRANSFORM` clause [2762](https://github.com/sqlfluff/sqlfluff/pull/2762) [R7L208](https://github.com/R7L208)
* Snowflake: Fix `GROUP BY {CUBE|ROLLUP|GROUPING SETS}` parsing [2759](https://github.com/sqlfluff/sqlfluff/pull/2759) [jpy-git](https://github.com/jpy-git)
* BigQuery: allow identifiers starting with dash [2756](https://github.com/sqlfluff/sqlfluff/pull/2756) [tunetheweb](https://github.com/tunetheweb)
* Add `ignore_words` options to L057 and L059 [2753](https://github.com/sqlfluff/sqlfluff/pull/2753) [tunetheweb](https://github.com/tunetheweb)
* L012 bug fix for T-SQL alternative alias types [2750](https://github.com/sqlfluff/sqlfluff/pull/2750) [tunetheweb](https://github.com/tunetheweb)
* Spark3: Support for `PIVOT` clause [2752](https://github.com/sqlfluff/sqlfluff/pull/2752) [R7L208](https://github.com/R7L208)
* Update Redshift reserved keywords list [2751](https://github.com/sqlfluff/sqlfluff/pull/2751) [rpr-ableton](https://github.com/rpr-ableton)
* L007 autofix [2735](https://github.com/sqlfluff/sqlfluff/pull/2735) [OTooleMichael](https://github.com/OTooleMichael)
* L032 fixable in easy cases [2737](https://github.com/sqlfluff/sqlfluff/pull/2737) [OTooleMichael](https://github.com/OTooleMichael)
* Fix dbt templater runtime error in `inject_ctes_into_sql()` [2748](https://github.com/sqlfluff/sqlfluff/pull/2748) [barrywhart](https://github.com/barrywhart)
* L059: Exasol: Allow quotes around passwords in `CREATE USER` [2744](https://github.com/sqlfluff/sqlfluff/pull/2744) [sti0](https://github.com/sti0)
* Improve docs for `load_macros_from_path` [2743](https://github.com/sqlfluff/sqlfluff/pull/2743) [barrywhart](https://github.com/barrywhart)
* Make L045 (Query defines a CTE but does not use it) case insensitive [2746](https://github.com/sqlfluff/sqlfluff/pull/2746) [barrywhart](https://github.com/barrywhart)
* Add L049 test for T-SQL alternate alias syntax (`=`) [2745](https://github.com/sqlfluff/sqlfluff/pull/2745) [barrywhart](https://github.com/barrywhart)
* `BaseSegment.pos_marker` is typed as non optional but sometimes set to `None` [2741](https://github.com/sqlfluff/sqlfluff/pull/2741) [barrywhart](https://github.com/barrywhart)
* Support Pascal case for L030 [2739](https://github.com/sqlfluff/sqlfluff/pull/2739) [tunetheweb](https://github.com/tunetheweb)
* Postgres, Redshift: Support `SIMILAR TO` pattern matching expressions [2732](https://github.com/sqlfluff/sqlfluff/pull/2732) [PLBMR](https://github.com/PLBMR)
* Forgive shorthand cast only / bracket only expressions from L013 [2729](https://github.com/sqlfluff/sqlfluff/pull/2729) [OTooleMichael](https://github.com/OTooleMichael)
* L052: Refactor `_eval()` into individual functions to improve readability [2733](https://github.com/sqlfluff/sqlfluff/pull/2733) [barrywhart](https://github.com/barrywhart)
* L018: Move closing parenthesis to next line [2734](https://github.com/sqlfluff/sqlfluff/pull/2734) [barrywhart](https://github.com/barrywhart)
* Improve rule yaml tests: assert that `fix_str` passes the rule [2624](https://github.com/sqlfluff/sqlfluff/pull/2624) [juhoautio](https://github.com/juhoautio)
* Extend rule L051 to `LEFT`/`RIGHT`/`OUTER` `JOIN`s [2719](https://github.com/sqlfluff/sqlfluff/pull/2719) [rpr-ableton](https://github.com/rpr-ableton)
* T-SQL: Allow aliases with `=` [2727](https://github.com/sqlfluff/sqlfluff/pull/2727) [fdw](https://github.com/fdw)
* T-SQL: Support table variables [2728](https://github.com/sqlfluff/sqlfluff/pull/2728) [fdw](https://github.com/fdw)
* Support for checking violations in YAML rule tests [2718](https://github.com/sqlfluff/sqlfluff/pull/2718) [juhoautio](https://github.com/juhoautio)
* Roll back PR 2610 [2726](https://github.com/sqlfluff/sqlfluff/pull/2726) [barrywhart](https://github.com/barrywhart)
* Redshift: Allow whitespace around cast operators [2721](https://github.com/sqlfluff/sqlfluff/pull/2721) [PLBMR](https://github.com/PLBMR)
* Support database links in Oracle [2725](https://github.com/sqlfluff/sqlfluff/pull/2725) [tunetheweb](https://github.com/tunetheweb)
* Rule L019: Ignore comma placement violations if the adjacent code is templated [2717](https://github.com/sqlfluff/sqlfluff/pull/2717) [barrywhart](https://github.com/barrywhart)
* T-SQL: Add drop constraint syntax [2724](https://github.com/sqlfluff/sqlfluff/pull/2724) [fdw](https://github.com/fdw)
* ANSI: Support optionally bracketed CTE [2716](https://github.com/sqlfluff/sqlfluff/pull/2716) [OTooleMichael](https://github.com/OTooleMichael)
* Spark3: Test cases for `CASE` clause [2714](https://github.com/sqlfluff/sqlfluff/pull/2714) [R7L208](https://github.com/R7L208)
* Spark3: Support for `WINDOW` functions [2711](https://github.com/sqlfluff/sqlfluff/pull/2711) [R7L208](https://github.com/R7L208)
* T-SQL: Add variables as options for `RAISERROR` parameters [2709](https://github.com/sqlfluff/sqlfluff/pull/2709) [jpers36](https://github.com/jpers36)
* T-SQL: Add `OPTION` clause to `UPDATE` [2707](https://github.com/sqlfluff/sqlfluff/pull/2707) [jpers36](https://github.com/jpers36)
* Spark3: Test cases for `WHERE` clause [2704](https://github.com/sqlfluff/sqlfluff/pull/2704) [R7L208](https://github.com/R7L208)
* Spark3: test cases for Table-Valued Functions [2703](https://github.com/sqlfluff/sqlfluff/pull/2703) [R7L208](https://github.com/R7L208)
* T-SQL: Allow for optionally bracketed `PARTITION BY` elements [2702](https://github.com/sqlfluff/sqlfluff/pull/2702) [jpers36](https://github.com/jpers36)
* T-SQL: Fix `SET TRANSACTION ISOLATION LEVEL` parsing [2701](https://github.com/sqlfluff/sqlfluff/pull/2701) [jpers36](https://github.com/jpers36)
* Migrate tricky L004 tests to python [2681](https://github.com/sqlfluff/sqlfluff/pull/2681) [juhoautio](https://github.com/juhoautio)
* Core linter enhancement: Check for successful parse after applying fixes [2657](https://github.com/sqlfluff/sqlfluff/pull/2657) [barrywhart](https://github.com/barrywhart)
* Spark3: Support for `LATERAL VIEW` clause [2687](https://github.com/sqlfluff/sqlfluff/pull/2687) [R7L208](https://github.com/R7L208)
* Document python requirement for tox/mypy & remove basepython from conf [2644](https://github.com/sqlfluff/sqlfluff/pull/2644) [juhoautio](https://github.com/juhoautio)
* Fix rule L011 for implicit aliases [2683](https://github.com/sqlfluff/sqlfluff/pull/2683) [tunetheweb](https://github.com/tunetheweb)
* Pin markupsafe to prevent CI failures [2685](https://github.com/sqlfluff/sqlfluff/pull/2685) [tunetheweb](https://github.com/tunetheweb)
* Exasol: Allow `CROSS` joins [2680](https://github.com/sqlfluff/sqlfluff/pull/2680) [sti0](https://github.com/sti0)
* Exasol: Improve function formatting [2678](https://github.com/sqlfluff/sqlfluff/pull/2678) [sti0](https://github.com/sti0)
* T-SQL: Add indentation for `CREATE` `INDEX`/`STATISTICS` [2679](https://github.com/sqlfluff/sqlfluff/pull/2679) [jpers36](https://github.com/jpers36)
* Spark3: Support for `TABLESAMPLE` clause [2674](https://github.com/sqlfluff/sqlfluff/pull/2674) [R7L208](https://github.com/R7L208)
* T-SQL: Improve `RAISERROR` functionality [2672](https://github.com/sqlfluff/sqlfluff/pull/2672) [jpers36](https://github.com/jpers36)
* Snowflake dialect update for `MERGE INTO` predicates [2670](https://github.com/sqlfluff/sqlfluff/pull/2670) [The-Loud](https://github.com/The-Loud)
* Assert that fix_str is set [2663](https://github.com/sqlfluff/sqlfluff/pull/2663) [juhoautio](https://github.com/juhoautio)

New Contributors
* [The-Loud](https://github.com/The-Loud) made their first contribution in [#2670](https://github.com/sqlfluff/sqlfluff/pull/2670)
* [OTooleMichael](https://github.com/OTooleMichael) made their first contribution in [#2716](https://github.com/sqlfluff/sqlfluff/pull/2716)
* [PhilippLange](https://github.com/PhilippLange) made their first contribution in [#2782](https://github.com/sqlfluff/sqlfluff/pull/2782)