Sqlfluff

What’s Changed

This release brings about several great new additions including:
- dbt 1.0.0 compatibility.
- CLI and Simple API parameters to provide custom paths to config files.
- Refinement to Simple API to return parse output in JSON format rather than as an internal SQLFluff object (**BREAKING CHANGE**).
- An [Official SQLFluff Docker Image](https://hub.docker.com/r/sqlfluff/sqlfluff).
- Grammar improvements across various dialects.
- A new rule (L057) to check for non-alphanumeric values in identifiers.

There have also been many bug fixes and improvements to the CI and development processes.

🚀 Enhancements

* T-SQL: Reserved Keyword cleanup [2100](https://github.com/sqlfluff/sqlfluff/pull/2100) [jpers36](https://github.com/jpers36)
* Add wiki links to CONTRIBUTING.md [2106](https://github.com/sqlfluff/sqlfluff/pull/2106) [tunetheweb](https://github.com/tunetheweb)
* Add snowflake create stage and alter stage statements + RegexParser case fix [2098](https://github.com/sqlfluff/sqlfluff/pull/2098) [chwiese](https://github.com/chwiese)
* Allow for more value types in ALTER TABLE ALTER COLUMN SET DEFAULT statement [2101](https://github.com/sqlfluff/sqlfluff/pull/2101) [derickl](https://github.com/derickl)
* Grammar: Adds support for ALTER VIEW statement for Postgres dialect [2096](https://github.com/sqlfluff/sqlfluff/pull/2096) [derickl](https://github.com/derickl)
* Add example for using JSON output of Simple API parse function [2099](https://github.com/sqlfluff/sqlfluff/pull/2099) [jpy-git](https://github.com/jpy-git)
* Allow optional keywords in create table unique constraints [2077](https://github.com/sqlfluff/sqlfluff/pull/2077) [kayman-mk](https://github.com/kayman-mk)
* Grammar: Adds support for ALTER FUNCTION statement for Postgres dialect [2090](https://github.com/sqlfluff/sqlfluff/pull/2090) [derickl](https://github.com/derickl)
* Grammar: adds support for CREATE/ALTER/DROP DATABASE for Postgres dialect [2081](https://github.com/sqlfluff/sqlfluff/pull/2081) [derickl](https://github.com/derickl)
* Update parse method of Simple API to output JSON parse tree [2082](https://github.com/sqlfluff/sqlfluff/pull/2082) [jpy-git](https://github.com/jpy-git)
* T-SQL dialect: add parsing for MERGE statement [2057](https://github.com/sqlfluff/sqlfluff/pull/2057) [tkachenkomaria244](https://github.com/tkachenkomaria244)
* Simple API config path [2080](https://github.com/sqlfluff/sqlfluff/pull/2080) [jpy-git](https://github.com/jpy-git)
* dbt 1.0.0 compatibility [2079](https://github.com/sqlfluff/sqlfluff/pull/2079) [alanmcruickshank](https://github.com/alanmcruickshank)
* Parse `on delete` and `on update` clause for create table constraints [2076](https://github.com/sqlfluff/sqlfluff/pull/2076) [kayman-mk](https://github.com/kayman-mk)
* Pre-commit: Add hook for doc8 [2074](https://github.com/sqlfluff/sqlfluff/pull/2074) [jpy-git](https://github.com/jpy-git)
* Grammar: Fix typo in Alter Table parser in Postgres dialect [2072](https://github.com/sqlfluff/sqlfluff/pull/2072) [derickl](https://github.com/derickl)
* Grammar: Adds support for materialized views for postgres dialect [2041](https://github.com/sqlfluff/sqlfluff/pull/2041) [derickl](https://github.com/derickl)
* Add basic pre-commit config [2067](https://github.com/sqlfluff/sqlfluff/pull/2067) [jpy-git](https://github.com/jpy-git)
* CLI: Add --ignore-local-config flag [2061](https://github.com/sqlfluff/sqlfluff/pull/2061) [jpy-git](https://github.com/jpy-git)
* T-SQL: INSERT INTO [2054](https://github.com/sqlfluff/sqlfluff/pull/2054) [jpers36](https://github.com/jpers36)
* Add --disable-noqa option to CLI and config [2043](https://github.com/sqlfluff/sqlfluff/pull/2043) [jpy-git](https://github.com/jpy-git)
* T-SQL: TRY/CATCH [2044](https://github.com/sqlfluff/sqlfluff/pull/2044) [jpers36](https://github.com/jpers36)
* enabled arrays support in `declare` and `set` statements for `bigquery` dialect [2038](https://github.com/sqlfluff/sqlfluff/pull/2038) [KulykDmytro](https://github.com/KulykDmytro)
* L008 refactor [2004](https://github.com/sqlfluff/sqlfluff/pull/2004) [jpy-git](https://github.com/jpy-git)
* Support __init__.py for library_path [1976](https://github.com/sqlfluff/sqlfluff/pull/1976) [Tonkonozhenko](https://github.com/Tonkonozhenko)
* L052: Redefine semi-colon newline to multiline newline [2022](https://github.com/sqlfluff/sqlfluff/pull/2022) [jpy-git](https://github.com/jpy-git)
* Grammar: Remove hash inline comment from Postgres [2035](https://github.com/sqlfluff/sqlfluff/pull/2035) [jpy-git](https://github.com/jpy-git)
* `noqa` enhancement: Enable glob rule matching for inline comments [2002](https://github.com/sqlfluff/sqlfluff/pull/2002) [jpy-git](https://github.com/jpy-git)
* T-SQL (ASA): Allow for table identifier in DELETE clause [2031](https://github.com/sqlfluff/sqlfluff/pull/2031) [jpers36](https://github.com/jpers36)
* T-SQL (ASA): Fix CTAS with WITH statement [2028](https://github.com/sqlfluff/sqlfluff/pull/2028) [jpers36](https://github.com/jpers36)
* Grammar: Parse multiple grants [2023](https://github.com/sqlfluff/sqlfluff/pull/2023) [jpy-git](https://github.com/jpy-git)
* Add tsql nested block comment support and add regex package dependency [2027](https://github.com/sqlfluff/sqlfluff/pull/2027) [jpy-git](https://github.com/jpy-git)
* Grammar: Add complete Snowflake datetime units [2026](https://github.com/sqlfluff/sqlfluff/pull/2026) [jpy-git](https://github.com/jpy-git)
* Grammar: Add DROP POLICY statement to postgres dialect [2024](https://github.com/sqlfluff/sqlfluff/pull/2024) [jpy-git](https://github.com/jpy-git)
* Grammar: Add complete datetime units to postgres dialect [2025](https://github.com/sqlfluff/sqlfluff/pull/2025) [jpy-git](https://github.com/jpy-git)
* Grammar: Postgres CREATE POLICY [2021](https://github.com/sqlfluff/sqlfluff/pull/2021) [jpy-git](https://github.com/jpy-git)
* Speed up CI [1957](https://github.com/sqlfluff/sqlfluff/pull/1957) [pwildenhain](https://github.com/pwildenhain)
* Add support for Snowflake create/alter SQL and js UDF [1993](https://github.com/sqlfluff/sqlfluff/pull/1993) [chwiese](https://github.com/chwiese)
* Add encoding CLI argument [1994](https://github.com/sqlfluff/sqlfluff/pull/1994) [jpy-git](https://github.com/jpy-git)
* T-SQL: Spaces allowed in comparison operators [1965](https://github.com/sqlfluff/sqlfluff/pull/1965) [jpers36](https://github.com/jpers36)
* Add Snowflake schema options [1950](https://github.com/sqlfluff/sqlfluff/pull/1950) [chwiese](https://github.com/chwiese)
* CLI/`.sqlfluff` enhancement: Rule globs [1972](https://github.com/sqlfluff/sqlfluff/pull/1972) [jpy-git](https://github.com/jpy-git)
* Add config CLI argument to lint, fix, and parse [1986](https://github.com/sqlfluff/sqlfluff/pull/1986) [jpy-git](https://github.com/jpy-git)
* Add type hints to simple API [1951](https://github.com/sqlfluff/sqlfluff/pull/1951) [jpy-git](https://github.com/jpy-git)
* New rule to flag special characters in identifiers [1958](https://github.com/sqlfluff/sqlfluff/pull/1958) [jpers36](https://github.com/jpers36)
* Allow column references in IN statement [1971](https://github.com/sqlfluff/sqlfluff/pull/1971) [tunetheweb](https://github.com/tunetheweb)
* Remove config.ini in favor of setup.cfg [1966](https://github.com/sqlfluff/sqlfluff/pull/1966) [jpy-git](https://github.com/jpy-git)
* Convert sqlfluff-templater-dbt setup.py to setup.cfg [1963](https://github.com/sqlfluff/sqlfluff/pull/1963) [jpy-git](https://github.com/jpy-git)
* Official Docker image: Dockerfile and Github Actions workflow [1945](https://github.com/sqlfluff/sqlfluff/pull/1945) [jpy-git](https://github.com/jpy-git)
* Move package metadata to setup.cfg [1960](https://github.com/sqlfluff/sqlfluff/pull/1960) [jpy-git](https://github.com/jpy-git)

🐛 Bug Fixes

* Fix tsql block comment close [2095](https://github.com/sqlfluff/sqlfluff/pull/2095) [jpy-git](https://github.com/jpy-git)
* Fix PlaceholderTemplater slice_type for templated code (substitutions) [2085](https://github.com/sqlfluff/sqlfluff/pull/2085) [barrywhart](https://github.com/barrywhart)
* Exasol: Fix UDF script syntax [2083](https://github.com/sqlfluff/sqlfluff/pull/2083) [sti0](https://github.com/sti0)
* Fix issues with placeholder templating docs [2078](https://github.com/sqlfluff/sqlfluff/pull/2078) [jpy-git](https://github.com/jpy-git)
* Update dbt templater docs to clarify that the profiles_dir setting is optional [2070](https://github.com/sqlfluff/sqlfluff/pull/2070) [barrywhart](https://github.com/barrywhart)
* Bug fix of L054 for Snowflake and Exasol [2069](https://github.com/sqlfluff/sqlfluff/pull/2069) [tunetheweb](https://github.com/tunetheweb)
* Fix L043 issue when trying to autofix functions [2059](https://github.com/sqlfluff/sqlfluff/pull/2059) [jpy-git](https://github.com/jpy-git)
* Add request for users dbt version in bug_report issue template [2058](https://github.com/sqlfluff/sqlfluff/pull/2058) [jpy-git](https://github.com/jpy-git)
* Fix parameters for Snowflake create tasks statement [2037](https://github.com/sqlfluff/sqlfluff/pull/2037) [chwiese](https://github.com/chwiese)
* Linguist: Include test/** in language statistics to better reflect use of SQL [2034](https://github.com/sqlfluff/sqlfluff/pull/2034) [jpy-git](https://github.com/jpy-git)
* L044 should handle nested CTEs [1991](https://github.com/sqlfluff/sqlfluff/pull/1991) [barrywhart](https://github.com/barrywhart)
* Add dbt adapter install advice to configuration documentation [2011](https://github.com/sqlfluff/sqlfluff/pull/2011) [jpy-git](https://github.com/jpy-git)
* Update pre-commit dbt instructions to reference separate dbt package [2005](https://github.com/sqlfluff/sqlfluff/pull/2005) [jpy-git](https://github.com/jpy-git)
* Fix config.get for iterable sections [2020](https://github.com/sqlfluff/sqlfluff/pull/2020) [jpy-git](https://github.com/jpy-git)
* Fix inline comment interactions with L052 [2019](https://github.com/sqlfluff/sqlfluff/pull/2019) [jpy-git](https://github.com/jpy-git)
* Make Snowflake tags DRY [1992](https://github.com/sqlfluff/sqlfluff/pull/1992) [chwiese](https://github.com/chwiese)
* Rename whitelist/blacklist to allowlist/denylist [1989](https://github.com/sqlfluff/sqlfluff/pull/1989) [jpy-git](https://github.com/jpy-git)
* Fix issue with inline ignores not respecting comment lines [1985](https://github.com/sqlfluff/sqlfluff/pull/1985) [jpy-git](https://github.com/jpy-git)
* Fix L009 FileSegment child + new create_before/create_after edit types [1979](https://github.com/sqlfluff/sqlfluff/pull/1979) [jpy-git](https://github.com/jpy-git)
* Adds extra check to L054 to avoid weird error messages [1988](https://github.com/sqlfluff/sqlfluff/pull/1988) [tunetheweb](https://github.com/tunetheweb)
* BigQuery: Allow keywords in column reference components [1987](https://github.com/sqlfluff/sqlfluff/pull/1987) [tunetheweb](https://github.com/tunetheweb)
* L027: Remove unnecessary crawl in get_select_statement_info [1974](https://github.com/sqlfluff/sqlfluff/pull/1974) [jpy-git](https://github.com/jpy-git)
* Add __all__ attributes to __init__.py files to resolve F401 [1949](https://github.com/sqlfluff/sqlfluff/pull/1949) [jpy-git](https://github.com/jpy-git)
* Fix incorrect comment on L055 [1967](https://github.com/sqlfluff/sqlfluff/pull/1967) [jpy-git](https://github.com/jpy-git)
* Docs: fix docker hub link to public URL [1964](https://github.com/sqlfluff/sqlfluff/pull/1964) [kevinmarsh](https://github.com/kevinmarsh)
* Fix issue releasing dbt package: tox commands run relative to repo root [1962](https://github.com/sqlfluff/sqlfluff/pull/1962) [jpy-git](https://github.com/jpy-git)

What’s Changed

One of the biggest new features in this release is the support for SQLAlchemy and other "placeholder" templating within SQL queries. Check out [the documentation on how to set it up](https://docs.sqlfluff.com/en/latest/configuration.html#placeholder-templating).

This release also adds **seven** new rules. Get some help with your leading whitespace, semi-colon placement, inconsistent column references in `GROUP BY/ORDER BY`, and getting rid of `RIGHT JOIN`'s among other useful lints with our new rules! See our [rules documentation](https://docs.sqlfluff.com/en/stable/rules.html) for more details.

On top of those, we have made loads of grammar improvements across many dialects, improvements to the dbt templater (including issues where `sqlfluff fix` would corrupt the code :scream:), more fix routines, and lots more improvements.

🚀 Enhancements

* [many dialects] Implement generic placeholder templating [1887](https://github.com/sqlfluff/sqlfluff/pull/1887) [jacopofar](https://github.com/jacopofar)
* [many dialects] Add support for SQLAlchemy templating [1878](https://github.com/sqlfluff/sqlfluff/pull/1878) [jacopofar](https://github.com/jacopofar)
* Add DROP PROCEDURE statement to T-SQL [1921](https://github.com/sqlfluff/sqlfluff/pull/1921) [jpy-git](https://github.com/jpy-git)
* T-SQL dialect: fix index/tables creation options [1955](https://github.com/sqlfluff/sqlfluff/pull/1955) [tkachenkomaria244](https://github.com/tkachenkomaria244)
* Add DROP TYPE statement to ANSI dialect [1919](https://github.com/sqlfluff/sqlfluff/pull/1919) [jpy-git](https://github.com/jpy-git)
* Add INSERT INTO statements to Redshift Dialect [1896](https://github.com/sqlfluff/sqlfluff/pull/1896) [tdstark](https://github.com/tdstark)
* Added TABLESAMPLE support to Bigquery [1897](https://github.com/sqlfluff/sqlfluff/pull/1897) [WittierDinosaur](https://github.com/WittierDinosaur)
* Add [LEFT] ANTI and [LEFT] SEMI joins to the Spark3 dialect [1942](https://github.com/sqlfluff/sqlfluff/pull/1942) [jpy-git](https://github.com/jpy-git)
* Parse UPDATE/INSERT within WITH clause [1889](https://github.com/sqlfluff/sqlfluff/pull/1889) [jpy-git](https://github.com/jpy-git)
* Add OVERRIDING SYSTEM/USER VALUE to insert statement in postgres dialect [1869](https://github.com/sqlfluff/sqlfluff/pull/1869) [jpy-git](https://github.com/jpy-git)
* Add support for DROP SCHEMA [IF EXISTS] name [ CASCADE | RESTRICT ] [1865](https://github.com/sqlfluff/sqlfluff/pull/1865) [gimmyxd](https://github.com/gimmyxd)
* Add CREATE TABLE Statement To Redshift [1855](https://github.com/sqlfluff/sqlfluff/pull/1855) [tdstark](https://github.com/tdstark)
* Add DROP TYPE statement in postgres dialect [1870](https://github.com/sqlfluff/sqlfluff/pull/1870) [jpy-git](https://github.com/jpy-git)
* Add SEQUENCE NAME to postgres sequence options [1866](https://github.com/sqlfluff/sqlfluff/pull/1866) [jpy-git](https://github.com/jpy-git)
* Added SET Statement to Postgres [1877](https://github.com/sqlfluff/sqlfluff/pull/1877) [WittierDinosaur](https://github.com/WittierDinosaur)
* Postgres: Allow use of quoted identifiers to ALTER TABLE OWNER TO [1856](https://github.com/sqlfluff/sqlfluff/pull/1856) [markpolyak](https://github.com/markpolyak)
* Updates to COPY INTO grammar in Snowflake [1884](https://github.com/sqlfluff/sqlfluff/pull/1884) [WittierDinosaur](https://github.com/WittierDinosaur)
* Postgres & T-SQL: Drop Function [1924](https://github.com/sqlfluff/sqlfluff/pull/1924) [WittierDinosaur](https://github.com/WittierDinosaur)
* Add Expressions to SET syntax [1852](https://github.com/sqlfluff/sqlfluff/pull/1852) [tunetheweb](https://github.com/tunetheweb)
* Update DbtTemplater to use JinjaTracer [1788](https://github.com/sqlfluff/sqlfluff/pull/1788) [barrywhart](https://github.com/barrywhart)
* L043 refinement: Add autofix for common use of CASE to fill NULL values. [1923](https://github.com/sqlfluff/sqlfluff/pull/1923) [jpy-git](https://github.com/jpy-git)
* New Rule L050: No leading whitespace [1840](https://github.com/sqlfluff/sqlfluff/pull/1840) [jpy-git](https://github.com/jpy-git)
* L050: updating to target jinja templates [1885](https://github.com/sqlfluff/sqlfluff/pull/1885) [jpy-git](https://github.com/jpy-git)
* New rule L051 to forbid lone JOIN [1879](https://github.com/sqlfluff/sqlfluff/pull/1879) [jpy-git](https://github.com/jpy-git)
* New Rule L052: Semi colon alignment [1902](https://github.com/sqlfluff/sqlfluff/pull/1902) [jpy-git](https://github.com/jpy-git)
* New Rule L053: Remove outer brackets from top-level statements. [1916](https://github.com/sqlfluff/sqlfluff/pull/1916) [jpy-git](https://github.com/jpy-git)
* New Rule L054: Inconsistent column references in GROUP BY/ORDER BY clauses. [1917](https://github.com/sqlfluff/sqlfluff/pull/1917) [jpy-git](https://github.com/jpy-git)
* New Rule L055: Use LEFT JOIN instead of RIGHT JOIN. [1931](https://github.com/sqlfluff/sqlfluff/pull/1931) [jpy-git](https://github.com/jpy-git)
* New Rule L056: 'SP_' prefix should not be used for user-defined stored procedures [1930](https://github.com/sqlfluff/sqlfluff/pull/1930) [jpy-git](https://github.com/jpy-git)
* Tsql partition by multiple columns [1906](https://github.com/sqlfluff/sqlfluff/pull/1906) [jpers36](https://github.com/jpers36)
* Added bare functions to values clause [1876](https://github.com/sqlfluff/sqlfluff/pull/1876) [WittierDinosaur](https://github.com/WittierDinosaur)
* Remove unnecessary context section, from code and the docs [1905](https://github.com/sqlfluff/sqlfluff/pull/1905) [jacopofar](https://github.com/jacopofar)
* L036 docstring refinements [1903](https://github.com/sqlfluff/sqlfluff/pull/1903) [jpy-git](https://github.com/jpy-git)
* Add `exclude_rules` option for the Simple API [1850](https://github.com/sqlfluff/sqlfluff/pull/1850) [tunetheweb](https://github.com/tunetheweb)
* Tox improvements: Streamline development/testing environments. [1860](https://github.com/sqlfluff/sqlfluff/pull/1860) [jpy-git](https://github.com/jpy-git)
* Add Tox publish commands [1853](https://github.com/sqlfluff/sqlfluff/pull/1853) [jpy-git](https://github.com/jpy-git)
* Documentation: Change inheritance dialect example to Redshift [1900](https://github.com/sqlfluff/sqlfluff/pull/1900) [chwiese](https://github.com/chwiese)
* Remove failing requires.io badge [1898](https://github.com/sqlfluff/sqlfluff/pull/1898) [jpy-git](https://github.com/jpy-git)
* [Snowflake] Allow naked AUTOINCREMENT [1883](https://github.com/sqlfluff/sqlfluff/pull/1883) [gordonhart](https://github.com/gordonhart)
* Add support for curly brackets in SnowSQL ampersand variables [1901](https://github.com/sqlfluff/sqlfluff/pull/1901) [chwiese](https://github.com/chwiese)
* Add short form help option (-h) [1947](https://github.com/sqlfluff/sqlfluff/pull/1947) [jpy-git](https://github.com/jpy-git)
* Remove plaintext API key from benchmark utility [1863](https://github.com/sqlfluff/sqlfluff/pull/1863) [jpy-git](https://github.com/jpy-git)
* Add `skip_install` to static analysis sections of tox.ini [1851](https://github.com/sqlfluff/sqlfluff/pull/1851) [jpy-git](https://github.com/jpy-git)
* Move typing_extensions from `requirements_dev.txt` to `requirements.txt` [1956](https://github.com/sqlfluff/sqlfluff/pull/1956) [jpy-git](https://github.com/jpy-git)

🐛 Bug Fixes

* Fix bug where "sqlfluff fix" deletes dbt "{% snapshot %}" line [1907](https://github.com/sqlfluff/sqlfluff/pull/1907) [barrywhart](https://github.com/barrywhart)
* Fix subquery bug in L026 [1948](https://github.com/sqlfluff/sqlfluff/pull/1948) [jpy-git](https://github.com/jpy-git)
* Fix bug where L041 was confused by L016's placement of newlines in the parse tree [1904](https://github.com/sqlfluff/sqlfluff/pull/1904) [barrywhart](https://github.com/barrywhart)
* Fix progressbar artifacts within linter errors [1873](https://github.com/sqlfluff/sqlfluff/pull/1873) [adam-tokarski](https://github.com/adam-tokarski)
* Correct Snowflake warehouse sizes [1872](https://github.com/sqlfluff/sqlfluff/pull/1872) [jpy-git](https://github.com/jpy-git)
* Fixed Delimited() logic, added T-SQL grammar [1894](https://github.com/sqlfluff/sqlfluff/pull/1894) [WittierDinosaur](https://github.com/WittierDinosaur)
* L036 refinement - FROM clause interaction [1893](https://github.com/sqlfluff/sqlfluff/pull/1893) [jpy-git](https://github.com/jpy-git)
* Add missing chardet install in setup.py [1928](https://github.com/sqlfluff/sqlfluff/pull/1928) [jpy-git](https://github.com/jpy-git)
* Fix misplaced TableAliasInfo in L031 documentation [1946](https://github.com/sqlfluff/sqlfluff/pull/1946) [jpy-git](https://github.com/jpy-git)
* Fix broken link to external SQL style guide [1918](https://github.com/sqlfluff/sqlfluff/pull/1918) [kevinmarsh](https://github.com/kevinmarsh)

What’s Changed

Fixes missing dependency issue with 0.8.0 for `tqdm`, plus add a test to ensure this does not happen again.

🐛 Bug Fixes

* Fix: add tqdm to setup.py installation requirements [1842](https://github.com/sqlfluff/sqlfluff/pull/1842) [skykasko](https://github.com/skykasko)
* Add test to ensure pip install works [1843](https://github.com/sqlfluff/sqlfluff/pull/1843) [tunetheweb](https://github.com/tunetheweb)

What’s Changed

This release brings an improvement to the performance of the parser, a rebuild of the Jinja Templater, and a progress bar for the CLI. Lots of dialect improvements have also been done. Full list of changes below:

🚀 Enhancements

* Updated L009 logic to only allow a single trailing newline. [1838](https://github.com/sqlfluff/sqlfluff/pull/1838) [jpy-git](https://github.com/jpy-git)
* Progressbar utility [1609](https://github.com/sqlfluff/sqlfluff/pull/1609) [adam-tokarski](https://github.com/adam-tokarski)
* Teradata dialect: Add support for SEL form of SELECT [1776](https://github.com/sqlfluff/sqlfluff/pull/1776) [samlader](https://github.com/samlader)
* Added trigger support in ANSI - and extended it in Postgres [1818](https://github.com/sqlfluff/sqlfluff/pull/1818) [WittierDinosaur](https://github.com/WittierDinosaur)
* Exasol: Make references more strict [1829](https://github.com/sqlfluff/sqlfluff/pull/1829) [sti0](https://github.com/sti0)
* Hive: INSERT statement support [1828](https://github.com/sqlfluff/sqlfluff/pull/1828) [mifercre](https://github.com/mifercre)
* ANSI: Add TABLESAMPLE support [1811](https://github.com/sqlfluff/sqlfluff/pull/1811) [CrossNox](https://github.com/CrossNox)
* T-SQL: Support trailing commas in CREATE TABLE [1817](https://github.com/sqlfluff/sqlfluff/pull/1817) [tommydb](https://github.com/tommydb)
* Spark3: Add CREATE VIEW support [1813](https://github.com/sqlfluff/sqlfluff/pull/1813) [DipeshCS](https://github.com/DipeshCS)
* BigQuery: Support PIVOT and UNPIVOT [1794](https://github.com/sqlfluff/sqlfluff/pull/1794) [tunetheweb](https://github.com/tunetheweb)
* L029: Optionally check quoted identifiers in addition to naked identifiers [1775](https://github.com/sqlfluff/sqlfluff/pull/1775) [jpers36](https://github.com/jpers36)
* Add sysdate to Redshift as a bare function [1789](https://github.com/sqlfluff/sqlfluff/pull/1789) [tdstark](https://github.com/tdstark)
* Robust Jinja raw/template mapping [1678](https://github.com/sqlfluff/sqlfluff/pull/1678) [barrywhart](https://github.com/barrywhart)
* Add CREATE TABLE AS to Postgres and Redshift [1785](https://github.com/sqlfluff/sqlfluff/pull/1785) [tdstark](https://github.com/tdstark)
* Improve Parser Performance By Caching Values [1744](https://github.com/sqlfluff/sqlfluff/pull/1744) [WittierDinosaur](https://github.com/WittierDinosaur)
* templater-dbt: Change dbt dependency to dbt-core [1786](https://github.com/sqlfluff/sqlfluff/pull/1786) [amardeep](https://github.com/amardeep)
* T-SQL: Create Schema definition [1773](https://github.com/sqlfluff/sqlfluff/pull/1773) [jpers36](https://github.com/jpers36)
* T-SQL: allow optional brackets for column default constraints [1760](https://github.com/sqlfluff/sqlfluff/pull/1760) [nevado](https://github.com/nevado)
* Postgres: Support parameters and identifiers prepended with _ and containing $ [1765](https://github.com/sqlfluff/sqlfluff/pull/1765) [WittierDinosaur](https://github.com/WittierDinosaur)
* Postgres: Added support for double precision [1764](https://github.com/sqlfluff/sqlfluff/pull/1764) [WittierDinosaur](https://github.com/WittierDinosaur)
* "sqlfluff fix": Write to a temporary .sql file first [1763](https://github.com/sqlfluff/sqlfluff/pull/1763) [barrywhart](https://github.com/barrywhart)
* Update older dbt dependency [1756](https://github.com/sqlfluff/sqlfluff/pull/1756) [alanmcruickshank](https://github.com/alanmcruickshank)
* T-SQL: add IDENTITY column constraint [1757](https://github.com/sqlfluff/sqlfluff/pull/1757) [nevado](https://github.com/nevado)
* Update CI to run under Python 3.10 [1739](https://github.com/sqlfluff/sqlfluff/pull/1739) [rooterkyberian](https://github.com/rooterkyberian)
* MySQL: Add drop index support [1738](https://github.com/sqlfluff/sqlfluff/pull/1738) [fatelei](https://github.com/fatelei)
* Snowflake dialect improvements [1737](https://github.com/sqlfluff/sqlfluff/pull/1737) [tunetheweb](https://github.com/tunetheweb)
* Add missing test case [1735](https://github.com/sqlfluff/sqlfluff/pull/1735) [tunetheweb](https://github.com/tunetheweb)

🐛 Bug Fixes

* Fix: Add missing init file to sqlfluff.core.templaters.slicers [1826](https://github.com/sqlfluff/sqlfluff/pull/1826) [CrossNox](https://github.com/CrossNox)
* Hive: Fix order of CREATE TEMPORARY EXTERNAL TABLE [1825](https://github.com/sqlfluff/sqlfluff/pull/1825) [mifercre](https://github.com/mifercre)
* T-SQL: add AS keyword as optional in PIVOT-UNPIVOT [1807](https://github.com/sqlfluff/sqlfluff/pull/1807) [tkachenkomaria244](https://github.com/tkachenkomaria244)
* Prevent L019 plus L034 corrupting SQL [1803](https://github.com/sqlfluff/sqlfluff/pull/1803) [barrywhart](https://github.com/barrywhart)
* L028 fix - Allow SELECT column alias in WHERE clauses for certain dialects [1796](https://github.com/sqlfluff/sqlfluff/pull/1796) [tunetheweb](https://github.com/tunetheweb)
* Comment out instructions in GitHub templates [1792](https://github.com/sqlfluff/sqlfluff/pull/1792) [tunetheweb](https://github.com/tunetheweb)
* Fix internal error in L016 when template/whitespace-only line too long [1795](https://github.com/sqlfluff/sqlfluff/pull/1795) [barrywhart](https://github.com/barrywhart)
* Fix L049 to allow = NULL in SET clauses [1791](https://github.com/sqlfluff/sqlfluff/pull/1791) [tunetheweb](https://github.com/tunetheweb)
* Hive: Fix bug in CREATE TABLE WITH syntax [1790](https://github.com/sqlfluff/sqlfluff/pull/1790) [iajoiner](https://github.com/iajoiner)
* Fixed encoding error when linting to file [1787](https://github.com/sqlfluff/sqlfluff/pull/1787) [WittierDinosaur](https://github.com/WittierDinosaur)
* Fix L012 documentation [1782](https://github.com/sqlfluff/sqlfluff/pull/1782) [jpers36](https://github.com/jpers36)
* T-SQL: fix quote alias [1766](https://github.com/sqlfluff/sqlfluff/pull/1766) [jpers36](https://github.com/jpers36)
* Fix incorrect indentation issue [1733](https://github.com/sqlfluff/sqlfluff/pull/1733) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Fix OVER functionality for functions [1731](https://github.com/sqlfluff/sqlfluff/pull/1731) [jpers36](https://github.com/jpers36)

What’s Changed

Highlights of this release contains a lot of T-SQL dialect improvements (shout out to jpers36 for most of these!). We also added Spark3 as a new dialect thanks to R7L208. The complete list of changes are shown below.

🚀 Enhancements

* T-SQL: Add rank functions [1725](https://github.com/sqlfluff/sqlfluff/pull/1725) [jpers36](https://github.com/jpers36)
* Spark3 Dialect Support [1706](https://github.com/sqlfluff/sqlfluff/pull/1706) [R7L208](https://github.com/R7L208)
* Postgres Array Support [1722](https://github.com/sqlfluff/sqlfluff/pull/1722) [WittierDinosaur](https://github.com/WittierDinosaur)
* Hive: Add LEFT SEMI JOIN support [1718](https://github.com/sqlfluff/sqlfluff/pull/1718) [fatelei](https://github.com/fatelei)
* MySQL: Change and drop column in alter table [1670](https://github.com/sqlfluff/sqlfluff/pull/1670) [MontealegreLuis](https://github.com/MontealegreLuis)
* Added type hints to some rule files [1616](https://github.com/sqlfluff/sqlfluff/pull/1616) [ttomasz](https://github.com/ttomasz)
* Added Redshift to README [1720](https://github.com/sqlfluff/sqlfluff/pull/1720) [WittierDinosaur](https://github.com/WittierDinosaur)
* Exasol: Fix create table statement [1700](https://github.com/sqlfluff/sqlfluff/pull/1700) [sti0](https://github.com/sti0)
* T-SQL: Add optional delimiter to SET [1717](https://github.com/sqlfluff/sqlfluff/pull/1717) [jpers36](https://github.com/jpers36)
* T-SQL: Escaped quotes [1715](https://github.com/sqlfluff/sqlfluff/pull/1715) [jpers36](https://github.com/jpers36)
* T-SQL: SELECT INTO [1714](https://github.com/sqlfluff/sqlfluff/pull/1714) [jpers36](https://github.com/jpers36)
* Postgres: Added support for psql variables [1709](https://github.com/sqlfluff/sqlfluff/pull/1709) [WittierDinosaur](https://github.com/WittierDinosaur)
* T-SQL: split location clause out from index clause [1711](https://github.com/sqlfluff/sqlfluff/pull/1711) [jpers36](https://github.com/jpers36)
* T-SQL: Override ANSI HAVING [1707](https://github.com/sqlfluff/sqlfluff/pull/1707) [jpers36](https://github.com/jpers36)
* T-SQL: Add UPDATE STATISTICS [1703](https://github.com/sqlfluff/sqlfluff/pull/1703) [jpers36](https://github.com/jpers36)
* T-SQL: CTAS Option Clause [1705](https://github.com/sqlfluff/sqlfluff/pull/1705) [jpers36](https://github.com/jpers36)
* T-SQL: DECLARE has optional AS [1704](https://github.com/sqlfluff/sqlfluff/pull/1704) [jpers36](https://github.com/jpers36)
* T-SQL: DROP STATISTICS and INDEX [1698](https://github.com/sqlfluff/sqlfluff/pull/1698) [jpers36](https://github.com/jpers36)
* T-SQL: CTAS select can be optionally bracketed [1697](https://github.com/sqlfluff/sqlfluff/pull/1697) [jpers36](https://github.com/jpers36)
* Exasol: Make function_script_terminator more strict [1696](https://github.com/sqlfluff/sqlfluff/pull/1696) [sti0](https://github.com/sti0)
* T-SQL distribution index location [1695](https://github.com/sqlfluff/sqlfluff/pull/1695) [jpers36](https://github.com/jpers36)
* T-SQL: allow for non-alphanumeric initial characters in delimited identifiers [1693](https://github.com/sqlfluff/sqlfluff/pull/1693) [jpers36](https://github.com/jpers36)
* T-SQL: allow for semi-colon after BEGIN in a BEGIN/END block [1694](https://github.com/sqlfluff/sqlfluff/pull/1694) [jpers36](https://github.com/jpers36)
* Exasol: Fix adapter script syntax [1692](https://github.com/sqlfluff/sqlfluff/pull/1692) [sti0](https://github.com/sti0)
* T-SQL: Basic EXECUTE functionality [1691](https://github.com/sqlfluff/sqlfluff/pull/1691) [jpers36](https://github.com/jpers36)
* T-SQL: Add , to valid identifier characters [1690](https://github.com/sqlfluff/sqlfluff/pull/1690) [jpers36](https://github.com/jpers36)
* T-SQL - add support for Filegroups in table create [1689](https://github.com/sqlfluff/sqlfluff/pull/1689) [nevado](https://github.com/nevado)
* Exclude Exasol scripts from rule L003 [1684](https://github.com/sqlfluff/sqlfluff/pull/1684) [tunetheweb](https://github.com/tunetheweb)
* Added PostGIS keyword data types to Postgres [1686](https://github.com/sqlfluff/sqlfluff/pull/1686) [WittierDinosaur](https://github.com/WittierDinosaur)
* Indent LIMIT values if on separate line [1683](https://github.com/sqlfluff/sqlfluff/pull/1683) [tunetheweb](https://github.com/tunetheweb)
* Postgres: Added support for SELECT INTO statements [1676](https://github.com/sqlfluff/sqlfluff/pull/1676) [WittierDinosaur](https://github.com/WittierDinosaur)
* Allow :: casting of CASE statements [1657](https://github.com/sqlfluff/sqlfluff/pull/1657) [tunetheweb](https://github.com/tunetheweb)
* Add more keywords to Redhift and BigQuery to avoid errors [1671](https://github.com/sqlfluff/sqlfluff/pull/1671) [tunetheweb](https://github.com/tunetheweb)
* T-SQL begin end delimiter [1664](https://github.com/sqlfluff/sqlfluff/pull/1664) [jpers36](https://github.com/jpers36)
* Teradata: Added date as bare function for [1663](https://github.com/sqlfluff/sqlfluff/pull/1663) [anzelpwj](https://github.com/anzelpwj)
* T-SQL: CREATE STATISTICS [1662](https://github.com/sqlfluff/sqlfluff/pull/1662) [jpers36](https://github.com/jpers36)
* T-SQL table and query hints [1661](https://github.com/sqlfluff/sqlfluff/pull/1661) [jpers36](https://github.com/jpers36)
* T-SQL: Allow spaces in qualified names [1654](https://github.com/sqlfluff/sqlfluff/pull/1654) [jpers36](https://github.com/jpers36)

🐛 Bug Fixes

* EXASOL: Fix typo in alter_table_statement [1726](https://github.com/sqlfluff/sqlfluff/pull/1726) [sti0](https://github.com/sti0)
* Fix markdown links in production.rst [1721](https://github.com/sqlfluff/sqlfluff/pull/1721) [asottile](https://github.com/asottile)
* Correct contributing testing information [1702](https://github.com/sqlfluff/sqlfluff/pull/1702) [adam-tokarski](https://github.com/adam-tokarski)
* More ORDER BY clarifications [1681](https://github.com/sqlfluff/sqlfluff/pull/1681) [tunetheweb](https://github.com/tunetheweb)
* Fix T-SQL L025 linter exception [1677](https://github.com/sqlfluff/sqlfluff/pull/1677) [tunetheweb](https://github.com/tunetheweb)
* Improve Jinja whitespace handling in rules [1647](https://github.com/sqlfluff/sqlfluff/pull/1647) [barrywhart](https://github.com/barrywhart)

**BREAKING CHANGE**

This release extracts the dbt templater to a separately installable plugin
[sqlfluff-templater-dbt](https://pypi.org/project/sqlfluff-templater-dbt/).
For users who take advantage of the dbt templater see the
[updated docs on how to migrate](https://docs.sqlfluff.com/en/latest/configuration.html#installation-configuration).
It also adds the `redshift` dialect and removes the `exasol_fs` dialect which has been merged
into the `exasol` dialect.

What’s Changed
* src/sqlfluff/core/linter: Improve ignore file processing [1650](https://github.com/sqlfluff/sqlfluff/pull/1650) [CyberShadow](https://github.com/CyberShadow)
* Misc documentation updates [1644](https://github.com/sqlfluff/sqlfluff/pull/1644) [tunetheweb](https://github.com/tunetheweb)
* Segregate dbt plugin tests [1610](https://github.com/sqlfluff/sqlfluff/pull/1610) [alanmcruickshank](https://github.com/alanmcruickshank)
* Add initial Redshift support [1641](https://github.com/sqlfluff/sqlfluff/pull/1641) [tunetheweb](https://github.com/tunetheweb)
* Update docs for dbt templater, improve error messages when not installed. [1583](https://github.com/sqlfluff/sqlfluff/pull/1583) [alanmcruickshank](https://github.com/alanmcruickshank)
* Make templaters pluggable and move the dbt templater into a plugin [1264](https://github.com/sqlfluff/sqlfluff/pull/1264) [alanmcruickshank](https://github.com/alanmcruickshank)

🚀 Enhancements

* T-SQL: CTAS delimiter [1652](https://github.com/sqlfluff/sqlfluff/pull/1652) [jpers36](https://github.com/jpers36)
* T-SQL: Allow for multiple variables DECLAREd in the same statement [1651](https://github.com/sqlfluff/sqlfluff/pull/1651) [jpers36](https://github.com/jpers36)
* T-SQL: Allow DECLARE/SET statements to parse using ExpressionStatement [1649](https://github.com/sqlfluff/sqlfluff/pull/1649) [jpers36](https://github.com/jpers36)
* T-SQL PRINT statement parsing [1648](https://github.com/sqlfluff/sqlfluff/pull/1648) [jpers36](https://github.com/jpers36)
* Better date function for tsql [1636](https://github.com/sqlfluff/sqlfluff/pull/1636) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Allow for multiple statements in a procedure [1637](https://github.com/sqlfluff/sqlfluff/pull/1637) [jpers36](https://github.com/jpers36)
* T-SQL: Allow for !>, !< operators [1640](https://github.com/sqlfluff/sqlfluff/pull/1640) [jpers36](https://github.com/jpers36)
* T-SQL: Fix GROUP BY delimiter [1635](https://github.com/sqlfluff/sqlfluff/pull/1635) [jpers36](https://github.com/jpers36)
* T-SQL: Fix DROP delimiter [1633](https://github.com/sqlfluff/sqlfluff/pull/1633) [jpers36](https://github.com/jpers36)
* T-SQL: +RENAME statement for Azure Synapse Analytics [1631](https://github.com/sqlfluff/sqlfluff/pull/1631) [jpers36](https://github.com/jpers36)
* T-SQL: Fix CASTing variables [1627](https://github.com/sqlfluff/sqlfluff/pull/1627) [jpers36](https://github.com/jpers36)
* Snowflake: Add implementation for CREATE TASK statement [1597](https://github.com/sqlfluff/sqlfluff/pull/1597) [#1603](https://github.com/sqlfluff/sqlfluff/pull/1603) [JoeHut](https://github.com/JoeHut)
* Allow global config for rule testcases [1580](https://github.com/sqlfluff/sqlfluff/pull/1580) [sti0](https://github.com/sti0)
* Snowflake dollar sign literals [1591](https://github.com/sqlfluff/sqlfluff/pull/1591) [myschkyna](https://github.com/myschkyna)
* Rename test/fixtures/parser directory to test/fixtures/dialects [1585](https://github.com/sqlfluff/sqlfluff/pull/1585) [tunetheweb](https://github.com/tunetheweb)
* Rename keyword files [1584](https://github.com/sqlfluff/sqlfluff/pull/1584) [tunetheweb](https://github.com/tunetheweb)
* Add some more unreserved keywords to BigQuery [1588](https://github.com/sqlfluff/sqlfluff/pull/1588) [tunetheweb](https://github.com/tunetheweb)
* Increase minimum runs before coverage report is issued [1596](https://github.com/sqlfluff/sqlfluff/pull/1596) [tunetheweb](https://github.com/tunetheweb)
* Snowflake: Support CURRENT_TIMESTAMP as a column default value [1578](https://github.com/sqlfluff/sqlfluff/pull/1578) [wong-codaio](https://github.com/wong-codaio)
* T-SQL temp tables [1574](https://github.com/sqlfluff/sqlfluff/pull/1574) [jpers36](https://github.com/jpers36)

🐛 Bug Fixes

* Fix NoneType exception in L031 [1643](https://github.com/sqlfluff/sqlfluff/pull/1643) [tunetheweb](https://github.com/tunetheweb)
* Stop rule L048 complaining if literal is followed by a semicolon [1638](https://github.com/sqlfluff/sqlfluff/pull/1638) [tunetheweb](https://github.com/tunetheweb)
* L031 desc updated to cover both 'from' and 'join' [1625](https://github.com/sqlfluff/sqlfluff/pull/1625) [nevado](https://github.com/nevado)
* Snowflake auto increments fixes [1620](https://github.com/sqlfluff/sqlfluff/pull/1620) [myschkyna](https://github.com/myschkyna)
* Fix DECLARE Delimitation [1615](https://github.com/sqlfluff/sqlfluff/pull/1615) [jpers36](https://github.com/jpers36)
* Snowflake drop column fixes [1618](https://github.com/sqlfluff/sqlfluff/pull/1618) [myschkyna](https://github.com/myschkyna)
* T-SQL: fix statement delimitation [1612](https://github.com/sqlfluff/sqlfluff/pull/1612) [jpers36](https://github.com/jpers36)
* Snowflake: Fixed data type casting not working in `SET` statement [1604](https://github.com/sqlfluff/sqlfluff/pull/1604) [wong-codaio](https://github.com/wong-codaio)
* Postgres dialect: Fix parse error for "on delete", "on update" clauses in column constraints [1586](https://github.com/sqlfluff/sqlfluff/pull/1586) [samlader](https://github.com/samlader)
* Fix AttributeError: 'NoneType' object has no attribute 'get_child' error with rule L031 [1595](https://github.com/sqlfluff/sqlfluff/pull/1595) [barrywhart](https://github.com/barrywhart)
* Fix zero length templated file bug. [1577](https://github.com/sqlfluff/sqlfluff/pull/1577) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fully remove exasol_fs dialect and bump version [1573](https://github.com/sqlfluff/sqlfluff/pull/1573) [alanmcruickshank](https://github.com/alanmcruickshank)