Sqlfluff

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)

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)