Sqlfluff

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)

Highlights
Major changes include:
* Improvements to rules L023, L045, L048, L052, L059 to make them more accurate.
* If `sqlfluff fix` cannot find a stable fix after `runaway_limit` iterations (default 10) then no fixes will be applied.
* Addition of `--write-output` config to command line so prevent errors corrupting output.
* Various dialect improvements


What’s Changed
* Redshift: Support DATETIME as a valid datatype [2665](https://github.com/sqlfluff/sqlfluff/pull/2665) [PLBMR](https://github.com/PLBMR)
* Support L033 for RedShift [2661](https://github.com/sqlfluff/sqlfluff/pull/2661) [tunetheweb](https://github.com/tunetheweb)
* Fix parsing types and add check to test in future [2652](https://github.com/sqlfluff/sqlfluff/pull/2652) [tunetheweb](https://github.com/tunetheweb)
* Spark3: Support for `SORT BY` Clause [2651](https://github.com/sqlfluff/sqlfluff/pull/2651) [R7L208](https://github.com/R7L208)
* Migrate issue template from markdown to yaml [2626](https://github.com/sqlfluff/sqlfluff/pull/2626) [zhongjiajie](https://github.com/zhongjiajie)
* L048 - handle more statements and exclude casting operators [2642](https://github.com/sqlfluff/sqlfluff/pull/2642) [tunetheweb](https://github.com/tunetheweb)
* MySQL support `CURRENT_TIMESTAMP()` in `CREATE TABLE` [2648](https://github.com/sqlfluff/sqlfluff/pull/2648) [tunetheweb](https://github.com/tunetheweb)
* Postgres enhanced `DELETE FROM` syntax [2643](https://github.com/sqlfluff/sqlfluff/pull/2643) [tunetheweb](https://github.com/tunetheweb)
* Bug fix: L025 should consider BigQuery `QUALIFY` clause [2647](https://github.com/sqlfluff/sqlfluff/pull/2647) [barrywhart](https://github.com/barrywhart)
* Bug fix: L025 overlooking `JOIN ON` clause if join expression in parentheses [2645](https://github.com/sqlfluff/sqlfluff/pull/2645) [barrywhart](https://github.com/barrywhart)
* L045 not reporting unused CTEs if the query uses templating [2641](https://github.com/sqlfluff/sqlfluff/pull/2641) [barrywhart](https://github.com/barrywhart)
* Fix IndexError in L001 [2640](https://github.com/sqlfluff/sqlfluff/pull/2640) [barrywhart](https://github.com/barrywhart)
* L052: If require_final_semicolon is set, ensure semicolon after ALL statements [2610](https://github.com/sqlfluff/sqlfluff/pull/2610) [barrywhart](https://github.com/barrywhart)
* L023 to also fix extra newlines in CTE [2623](https://github.com/sqlfluff/sqlfluff/pull/2623) [juhoautio](https://github.com/juhoautio)
* Spark3: Enhancements for Set Operators [2622](https://github.com/sqlfluff/sqlfluff/pull/2622) [R7L208](https://github.com/R7L208)
* Doc a better choice for default env [2630](https://github.com/sqlfluff/sqlfluff/pull/2630) [juhoautio](https://github.com/juhoautio)
* Ensure ordering of fix compatible and config in rules docs [2620](https://github.com/sqlfluff/sqlfluff/pull/2620) [zhongjiajie](https://github.com/zhongjiajie)
* Pin python version for tox -e mypy [2629](https://github.com/sqlfluff/sqlfluff/pull/2629) [juhoautio](https://github.com/juhoautio)
* Hitting the linter loop limit should be treated as an error [2628](https://github.com/sqlfluff/sqlfluff/pull/2628) [barrywhart](https://github.com/barrywhart)
* Allow file output directly from cli [2625](https://github.com/sqlfluff/sqlfluff/pull/2625) [alanmcruickshank](https://github.com/alanmcruickshank)
* BigQuery `UNPIVOT` and `PIVOT` fixes [2619](https://github.com/sqlfluff/sqlfluff/pull/2619) [tunetheweb](https://github.com/tunetheweb)
* L059 quoted identifiers bug [2614](https://github.com/sqlfluff/sqlfluff/pull/2614) [tunetheweb](https://github.com/tunetheweb)
* Snowflake dialect: Adjust snowflake array access [2621](https://github.com/sqlfluff/sqlfluff/pull/2621) [alanmcruickshank](https://github.com/alanmcruickshank)
* Spark3: Test Cases for `ORDER BY` in `SELECT` [2618](https://github.com/sqlfluff/sqlfluff/pull/2618) [R7L208](https://github.com/R7L208)
* Fix typos in 0.10.0 changelog [2605](https://github.com/sqlfluff/sqlfluff/pull/2605) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Indent `IF` clause expression segments [2615](https://github.com/sqlfluff/sqlfluff/pull/2615) [jpers36](https://github.com/jpers36)
* Spark3: Enhancements for `LIMIT` Clause [2612](https://github.com/sqlfluff/sqlfluff/pull/2612) [R7L208](https://github.com/R7L208)
* Allow Bare Functions in column constraints [2607](https://github.com/sqlfluff/sqlfluff/pull/2607) [tunetheweb](https://github.com/tunetheweb)
* Add Oracle at and double at sign (execution symbol) [2608](https://github.com/sqlfluff/sqlfluff/pull/2608) [r0fls](https://github.com/r0fls)
* Spark3: Enhancements to `LIKE` clause [2604](https://github.com/sqlfluff/sqlfluff/pull/2604) [R7L208](https://github.com/R7L208)

Highlights
Major changes include:

* Dropping support of DBT < 0.20 **BREAKING CHANGE**
* `sqlfluff fix` no will no longer fix SQL containing parsing or templating errors **BREAKING CHANGE**
* New rule L062 to allow blocking of list of configurable words (e.g. syntax, or schemas, or tables you do not want people to use)
* Lots and lots of docs improvements
* Looser requirements for `click` python package

What’s Changed
* L046: Detect Jinja spacing issues where segment begins with literal content [2603](https://github.com/sqlfluff/sqlfluff/pull/2603) [barrywhart](https://github.com/barrywhart)
* MySQL Add BINARY support [2602](https://github.com/sqlfluff/sqlfluff/pull/2602) [tunetheweb](https://github.com/tunetheweb)
* Support indenting WINDOWS clauses and (optionally) CTEs [2601](https://github.com/sqlfluff/sqlfluff/pull/2601) [tunetheweb](https://github.com/tunetheweb)
* Postgres: Support expressions in arrays [2599](https://github.com/sqlfluff/sqlfluff/pull/2599) [tunetheweb](https://github.com/tunetheweb)
* BigQuery support Array of Structs [2598](https://github.com/sqlfluff/sqlfluff/pull/2598) [tunetheweb](https://github.com/tunetheweb)
* Support wildcards in triggers [2597](https://github.com/sqlfluff/sqlfluff/pull/2597) [tunetheweb](https://github.com/tunetheweb)
* Support CTEs in CREATE VIEW statements [2596](https://github.com/sqlfluff/sqlfluff/pull/2596) [tunetheweb](https://github.com/tunetheweb)
* SQLite Support more CREATE TRIGGER options [2594](https://github.com/sqlfluff/sqlfluff/pull/2594) [tunetheweb](https://github.com/tunetheweb)
* Snowflake: Support Column Comments in Alter Table statements [2593](https://github.com/sqlfluff/sqlfluff/pull/2593) [tunetheweb](https://github.com/tunetheweb)
* Redshift: Add DATETIME as reserved keyword [2591](https://github.com/sqlfluff/sqlfluff/pull/2591) [tunetheweb](https://github.com/tunetheweb)
* Support LIMIT and ORDER BY clauses in Values clauses [2590](https://github.com/sqlfluff/sqlfluff/pull/2590) [tunetheweb](https://github.com/tunetheweb)
* L016: New option "ignore_comment_clause" to ignore column COMMENTs, etc. [2589](https://github.com/sqlfluff/sqlfluff/pull/2589) [barrywhart](https://github.com/barrywhart)
* Bug fix: L016 ("Line is too long") should consider length of prior fixes [2587](https://github.com/sqlfluff/sqlfluff/pull/2587) [barrywhart](https://github.com/barrywhart)
* Add mysql INSERT ON DUPLICATE KEY [2494](https://github.com/sqlfluff/sqlfluff/pull/2494) [rpr-ableton](https://github.com/rpr-ableton)
* Snowflake ALTER TABLE: Add multiple columns [2578](https://github.com/sqlfluff/sqlfluff/pull/2578) [erevear](https://github.com/erevear)
* MySQL: UNIQUE KEY in CREATE TABLE [2525](https://github.com/sqlfluff/sqlfluff/pull/2525) [jpy-git](https://github.com/jpy-git)
* Spark3: JOIN clause enhancements [2570](https://github.com/sqlfluff/sqlfluff/pull/2570) [R7L208](https://github.com/R7L208)
* Bug fix: L003 should fix indentation for templated code [2580](https://github.com/sqlfluff/sqlfluff/pull/2580) [barrywhart](https://github.com/barrywhart)
* Exasol: Improve `COMMENT` and `WITH [NO] DATA` clause usage. [2583](https://github.com/sqlfluff/sqlfluff/pull/2583) [sti0](https://github.com/sti0)
* Exasol: Allow multiple `LOCAL` keywords in `WHERE` clause [2582](https://github.com/sqlfluff/sqlfluff/pull/2582) [sti0](https://github.com/sti0)
* Exasol: Allow `LOCAL` keyword within `PREFERRING` clause [2579](https://github.com/sqlfluff/sqlfluff/pull/2579) [sti0](https://github.com/sti0)
* Add/Improve docs for config settings: "ignore", "ignore_templated_areas" [2574](https://github.com/sqlfluff/sqlfluff/pull/2574) [barrywhart](https://github.com/barrywhart)
* Look for .sqlfluffignore in current directory [2573](https://github.com/sqlfluff/sqlfluff/pull/2573) [barrywhart](https://github.com/barrywhart)
* Snowflake: L054 should ignore "WITHIN GROUP" clauses [2571](https://github.com/sqlfluff/sqlfluff/pull/2571) [barrywhart](https://github.com/barrywhart)
* Redshift: Support Redshift SUPER Data Types [2564](https://github.com/sqlfluff/sqlfluff/pull/2564) [PLBMR](https://github.com/PLBMR)
* Capitalization rules (L010, L014, L030, L040) should ignore templated code [2566](https://github.com/sqlfluff/sqlfluff/pull/2566) [barrywhart](https://github.com/barrywhart)
* T-SQL: Add Frame clause unreserved keywords [2562](https://github.com/sqlfluff/sqlfluff/pull/2562) [jpers36](https://github.com/jpers36)
* Simple API: Fix bug where omitted parameters still override .sqlfluff [2563](https://github.com/sqlfluff/sqlfluff/pull/2563) [barrywhart](https://github.com/barrywhart)
* Spark3: Add Direct File Query [2553](https://github.com/sqlfluff/sqlfluff/pull/2553) [R7L208](https://github.com/R7L208)
* Redshift dialect: replace AnyNumberOf with AnySetOf where it makes sense [2561](https://github.com/sqlfluff/sqlfluff/pull/2561) [rpr-ableton](https://github.com/rpr-ableton)
* jinja and dbt templaters: More robust handling of whitespace control [2559](https://github.com/sqlfluff/sqlfluff/pull/2559) [barrywhart](https://github.com/barrywhart)
* Improve how "sqlfluff fix" handles templating and parse errors [2546](https://github.com/sqlfluff/sqlfluff/pull/2546) [barrywhart](https://github.com/barrywhart)
* Jinja and dbt templater: Fix "list index out of range" error [2555](https://github.com/sqlfluff/sqlfluff/pull/2555) [barrywhart](https://github.com/barrywhart)
* Fix typo in sqlfluffignore docs [2551](https://github.com/sqlfluff/sqlfluff/pull/2551) [tunetheweb](https://github.com/tunetheweb)
* Correct parsing for BigQuery `SELECT REPLACE` clauses. [2550](https://github.com/sqlfluff/sqlfluff/pull/2550) [elyobo](https://github.com/elyobo)
* Rules documentation improvements [2542](https://github.com/sqlfluff/sqlfluff/pull/2542) [tunetheweb](https://github.com/tunetheweb)
* Remove requirement for Click>=8 [2547](https://github.com/sqlfluff/sqlfluff/pull/2547) [tunetheweb](https://github.com/tunetheweb)
* Allow L059 to be configured to always prefer quoted identifiers [2537](https://github.com/sqlfluff/sqlfluff/pull/2537) [niconoe-](https://github.com/niconoe-)
* Adds new rule L062 to allow blocking of certain words [2540](https://github.com/sqlfluff/sqlfluff/pull/2540) [tunetheweb](https://github.com/tunetheweb)
* Update to latest Black, drop support for dbt < 0.20 [2536](https://github.com/sqlfluff/sqlfluff/pull/2536) [barrywhart](https://github.com/barrywhart)
* dbt templater: Fix bug where profile wasn't found if DBT_PROFILES_DIR contained uppercase letters [2539](https://github.com/sqlfluff/sqlfluff/pull/2539) [barrywhart](https://github.com/barrywhart)
* Spark3: Added segments & grammar needed for hints [2528](https://github.com/sqlfluff/sqlfluff/pull/2528) [R7L208](https://github.com/R7L208)
* Spark3: parse some VALUES clauses [2245](https://github.com/sqlfluff/sqlfluff/pull/2245) [mcannamela](https://github.com/mcannamela)
* T-SQL: Allow multiple params in SET statements [2535](https://github.com/sqlfluff/sqlfluff/pull/2535) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Add indentation for SET statement [2531](https://github.com/sqlfluff/sqlfluff/pull/2531) [jpers36](https://github.com/jpers36)
* Add additional documentation on dbt-adapter in pre-commit [2530](https://github.com/sqlfluff/sqlfluff/pull/2530) [robertdefilippi](https://github.com/robertdefilippi)
* T-SQL: Add indentation for UPDATE statement [2532](https://github.com/sqlfluff/sqlfluff/pull/2532) [jpers36](https://github.com/jpers36)
* Fix Snowflake Unordered Select Clause [2529](https://github.com/sqlfluff/sqlfluff/pull/2529) [tunetheweb](https://github.com/tunetheweb)
* Fix Quoted Literals for Postgres and Redshift affecting rule L039 [2526](https://github.com/sqlfluff/sqlfluff/pull/2526) [tunetheweb](https://github.com/tunetheweb)
* Postgres specific CTEDefinitionSegment [2524](https://github.com/sqlfluff/sqlfluff/pull/2524) [jpy-git](https://github.com/jpy-git)

New Contributors
* [robertdefilippi](https://github.com/robertdefilippi) made their first contribution in [#2530](https://github.com/sqlfluff/sqlfluff/pull/2530)
* [niconoe-](https://github.com/niconoe-) made their first contribution in [#2537](https://github.com/sqlfluff/sqlfluff/pull/2537)
* [elyobo](https://github.com/elyobo) made their first contribution in [#2550](https://github.com/sqlfluff/sqlfluff/pull/2550)
* [erevear](https://github.com/erevear) made their first contribution in [#2578](https://github.com/sqlfluff/sqlfluff/pull/2578)

Highlights
Major changes include:

* dbt performance improvements
* Fix `click` dependency error.
* Better datepart versus identifier parsing.
* Fix some Jinja errors.
* Various grammar fixes and improvements

What’s Changed
* Spark3: test cases for HAVING clause in SELECT statement [2518](https://github.com/sqlfluff/sqlfluff/pull/2517) [R7L208](https://github.com/R7L208)
* Update click version requirement in setup.cfg to match that in requirements.txt [2518](https://github.com/sqlfluff/sqlfluff/pull/2518) [barrywhart](https://github.com/barrywhart)
* Postgres: Implement DO Statements + Refactored Language Clause [2511](https://github.com/sqlfluff/sqlfluff/pull/2511) [PLBMR](https://github.com/PLBMR)
* Spark3: Support for Grouping Sets, `CUBE` and `ROLLUP` in `GROUP BY` clause of `SELECT` statement [2505](https://github.com/sqlfluff/sqlfluff/pull/2505) [R7L208](https://github.com/R7L208)
* Refactor date part functions [2510](https://github.com/sqlfluff/sqlfluff/pull/2510) [tunetheweb](https://github.com/tunetheweb)
* Postgres: EXPLAIN ANALYSE allows British spelling [2507](https://github.com/sqlfluff/sqlfluff/pull/2507) [jpy-git](https://github.com/jpy-git)
* "noqa": Add support for ignoring template (TMP) and parse (PRS) errors [2509](https://github.com/sqlfluff/sqlfluff/pull/2509) [barrywhart](https://github.com/barrywhart)
* Freeze Black due to incompatibility between 22.1 and flake8-black [2513](https://github.com/sqlfluff/sqlfluff/pull/2513) [tunetheweb](https://github.com/tunetheweb)
* Support NATURAL JOINS [2506](https://github.com/sqlfluff/sqlfluff/pull/2506) [tunetheweb](https://github.com/tunetheweb)
* dbt Docker environment: Mount the test profiles.yml at ~/.dbt [2502](https://github.com/sqlfluff/sqlfluff/pull/2502) [barrywhart](https://github.com/barrywhart)
* Add dbt_artifacts package to in the wild docs [2504](https://github.com/sqlfluff/sqlfluff/pull/2504) [NiallRees](https://github.com/NiallRees)
* Spark3: Support `DISTRIBUTE BY` clause in `SELECT` statement [2503](https://github.com/sqlfluff/sqlfluff/pull/2503) [R7L208](https://github.com/R7L208)
* dbt templater: For performance reasons, cache the database connection across models [2498](https://github.com/sqlfluff/sqlfluff/pull/2498) [barrywhart](https://github.com/barrywhart)
* Bug fix: Defining and using Jinja macro in the same file causes runtime error [2499](https://github.com/sqlfluff/sqlfluff/pull/2499) [barrywhart](https://github.com/barrywhart)
* Spark3: Support `CLUSTER BY` clause in `SELECT` statement [2491](https://github.com/sqlfluff/sqlfluff/pull/2491) [R7L208](https://github.com/R7L208)
* Grammar: Adds support for COPY statement for Postgres dialect [2481](https://github.com/sqlfluff/sqlfluff/pull/2481) [derickl](https://github.com/derickl)
* Add raiserror for T-SQL [2490](https://github.com/sqlfluff/sqlfluff/pull/2490) [fdw](https://github.com/fdw)
* Enforce parentheses for function definitions in T-SQL [2489](https://github.com/sqlfluff/sqlfluff/pull/2489) [fdw](https://github.com/fdw)
* Add guards to prevent rule crashes [2488](https://github.com/sqlfluff/sqlfluff/pull/2488) [barrywhart](https://github.com/barrywhart)

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

Highlights
Major changes include:

* Add `ignore_words` option for rules L010, L014, L029, L030, L040
* Fix some issues in 0.9.2 preventing some queries linting

What’s Changed
* Prevent L031 throwing exception on unparsable code [2486](https://github.com/sqlfluff/sqlfluff/pull/2486) [tunetheweb](https://github.com/tunetheweb)
* Add linting of fixtures SQL for critical rules errors to tox [2473](https://github.com/sqlfluff/sqlfluff/pull/2473) [tunetheweb](https://github.com/tunetheweb)
* Fix L039 for T-SQL comparison operator using space [2485](https://github.com/sqlfluff/sqlfluff/pull/2485) [tunetheweb](https://github.com/tunetheweb)
* Fix bug in get_alias causing rule Critical errors for T-SQL [2479](https://github.com/sqlfluff/sqlfluff/pull/2479) [tunetheweb](https://github.com/tunetheweb)
* Tweak GitHub templates [2471](https://github.com/sqlfluff/sqlfluff/pull/2471) [tunetheweb](https://github.com/tunetheweb)
* Small speed improvement to L054 [2476](https://github.com/sqlfluff/sqlfluff/pull/2476) [tunetheweb](https://github.com/tunetheweb)
* L003: Revisit recent change to improve speed [2474](https://github.com/sqlfluff/sqlfluff/pull/2474) [barrywhart](https://github.com/barrywhart)
* Fix select_crawler issue with some Exasol statements [2470](https://github.com/sqlfluff/sqlfluff/pull/2470) [tunetheweb](https://github.com/tunetheweb)
* Cleanup date logic by removing DatePartClause and using DatetimeUnitSegment instead [2464](https://github.com/sqlfluff/sqlfluff/pull/2464) [tunetheweb](https://github.com/tunetheweb)
* Fix L044 exception when final statement has no SELECT [2468](https://github.com/sqlfluff/sqlfluff/pull/2468) [tunetheweb](https://github.com/tunetheweb)
* Support T-SQL system variables (e.g. rowcount) [2463](https://github.com/sqlfluff/sqlfluff/pull/2463) [tunetheweb](https://github.com/tunetheweb)
* Add base rule to developing rules page [2462](https://github.com/sqlfluff/sqlfluff/pull/2462) [tunetheweb](https://github.com/tunetheweb)
* L003: Ignore indentation of lines that only exist in templated space [2460](https://github.com/sqlfluff/sqlfluff/pull/2460) [barrywhart](https://github.com/barrywhart)
* Ignore words for various rules [2459](https://github.com/sqlfluff/sqlfluff/pull/2459) [tunetheweb](https://github.com/tunetheweb)
* Support Foreign Key options for MySQL [2461](https://github.com/sqlfluff/sqlfluff/pull/2461) [tunetheweb](https://github.com/tunetheweb)
* Exclude WINDOW clauses from L054 [2455](https://github.com/sqlfluff/sqlfluff/pull/2455) [tunetheweb](https://github.com/tunetheweb)
* Fix bug with L026 for simple deletes [2458](https://github.com/sqlfluff/sqlfluff/pull/2458) [tunetheweb](https://github.com/tunetheweb)
* Spark3: test cases for Common Table Expressions [2454](https://github.com/sqlfluff/sqlfluff/pull/2454) [R7L208](https://github.com/R7L208)
* Fix T-SQL's IDENTITY_INSERT syntax [2452](https://github.com/sqlfluff/sqlfluff/pull/2452) [fdw](https://github.com/fdw)
* T-SQL: Support stored procedures in insert statements [2451](https://github.com/sqlfluff/sqlfluff/pull/2451) [fdw](https://github.com/fdw)
* Spark3: Support for `LOAD DATA` statements [2450](https://github.com/sqlfluff/sqlfluff/pull/2450) [R7L208](https://github.com/R7L208)