Sqlfluff

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)

Another dbt bugfix from 0.6.7 and 0.6.8, plus a host of dialect and syntax improvements.

🚀 Enhancements
* Correct and expand Snowflake CREATE TABLE syntax [1567] [tunetheweb](https://github.com/tunetheweb)
* Support brackets in Postgres Meta commands [1548](https://github.com/sqlfluff/sqlfluff/pull/1548) [tunetheweb](https://github.com/tunetheweb)
* added type hints to rule files [1515](https://github.com/sqlfluff/sqlfluff/pull/1515) [ttomasz](https://github.com/ttomasz)
* Update Rule L028 to handle T-SQL PIVOT columns [1545](https://github.com/sqlfluff/sqlfluff/pull/1545) [tunetheweb](https://github.com/tunetheweb)
* T-SQL IF/ELSE [1564](https://github.com/sqlfluff/sqlfluff/pull/1564) [jpers36](https://github.com/jpers36)
* Enums for format types and colors added [1558](https://github.com/sqlfluff/sqlfluff/pull/1558) [adam-tokarski](https://github.com/adam-tokarski)
* Add dbt 0.21.0 to the test suite [1566](https://github.com/sqlfluff/sqlfluff/pull/1566) [alanmcruickshank](https://github.com/alanmcruickshank)
* Merge EXASOL_FS dialect into EXASOL dialect [1498](https://github.com/sqlfluff/sqlfluff/pull/1498) [sti0](https://github.com/sti0)
* T-SQL - BEGIN/END blocks [1553](https://github.com/sqlfluff/sqlfluff/pull/1553) [jpers36](https://github.com/jpers36)
* Small refactor with type hints and string formatting [1525](https://github.com/sqlfluff/sqlfluff/pull/1525) [adam-tokarski](https://github.com/adam-tokarski)
* Add Github Preview Image [1557](https://github.com/sqlfluff/sqlfluff/pull/1557) [alanmcruickshank](https://github.com/alanmcruickshank)
* Support SETOF in Postgres [1522](https://github.com/sqlfluff/sqlfluff/pull/1522) [tunetheweb](https://github.com/tunetheweb)
* Support Double Precision in ANSI [1524](https://github.com/sqlfluff/sqlfluff/pull/1524) [tunetheweb](https://github.com/tunetheweb)
* Support LATERAL joins in Postgres [1519](https://github.com/sqlfluff/sqlfluff/pull/1519) [adam-tokarski](https://github.com/adam-tokarski)
* Add a rule to warn on "= NULL" or "<> NULL" comparisons [1527](https://github.com/sqlfluff/sqlfluff/pull/1527) [barrywhart](https://github.com/barrywhart)
* Support Group and Groups as table names [1546](https://github.com/sqlfluff/sqlfluff/pull/1546) [tunetheweb](https://github.com/tunetheweb)
* Support more complex IN (...) expressions [1550](https://github.com/sqlfluff/sqlfluff/pull/1550) [tunetheweb](https://github.com/tunetheweb)
* Support CROSS APPLY and OUTER APPLY and TOP in T-SQL [1551](https://github.com/sqlfluff/sqlfluff/pull/1551) [tunetheweb](https://github.com/tunetheweb)
* Add support for WITHOUT ROWID to SQLite [1531](https://github.com/sqlfluff/sqlfluff/pull/1531) [tunetheweb](https://github.com/tunetheweb)
* Postgres: add `CONCURRENTLY` and `FINALIZE` keywords to `DETACH PARTITION` [1529](https://github.com/sqlfluff/sqlfluff/pull/1529) [kevinmarsh](https://github.com/kevinmarsh)
* Better support of MySQL CREATE TABLE TIMESTAMP/DATESTAMP [1530](https://github.com/sqlfluff/sqlfluff/pull/1530) [tunetheweb](https://github.com/tunetheweb)
* "Found unparsable section" instead of stack trace when multiple semicolons provided [1517](https://github.com/sqlfluff/sqlfluff/pull/1517) [adam-tokarski](https://github.com/adam-tokarski)

🐛 Bug Fixes
* Fix test coverage [1569](https://github.com/sqlfluff/sqlfluff/pull/1569) [tunetheweb](https://github.com/tunetheweb)
* Remove lint_templated_tokens as no longer does anything [1570](https://github.com/sqlfluff/sqlfluff/pull/1570) [tunetheweb](https://github.com/tunetheweb)
* Fix broken block comments in exasol [1565](https://github.com/sqlfluff/sqlfluff/pull/1565) [sti0](https://github.com/sti0)
* Rethink sequence_files in dbt templater. [1563](https://github.com/sqlfluff/sqlfluff/pull/1563) [alanmcruickshank](https://github.com/alanmcruickshank)
* T-SQL: fix STRING_AGG() WITHIN GROUP clause [1559](https://github.com/sqlfluff/sqlfluff/pull/1559) [jpers36](https://github.com/jpers36)
* fix spelling: occurrence>occurrence [1507](https://github.com/sqlfluff/sqlfluff/pull/1507) [jpers36](https://github.com/jpers36)

Fixed a DBT bug introduced in 0.6.7 - apologies!

What’s Changed

SQLFluff can't find dbt models [1513](https://github.com/sqlfluff/sqlfluff/pull/1513) [barrywhart](https://github.com/barrywhart)
T-SQL: Support for unicode literals [1511](https://github.com/sqlfluff/sqlfluff/pull/1511) [adam-tokarski](https://github.com/adam-tokarski)

Lots of fixes to our rules (particularly when running `sqlfluff fix`, and particularly for Jinja and DBT templates). We also have good improvements to Exasol, Snowflake, and T-SQL dialects amongst others. Plus we added Hive and SQLite as supported dialects!

What’s Changed
* Snowflake better WAREHOUSE and CREATE (EXTERNAL) TABLES support [1508](https://github.com/sqlfluff/sqlfluff/pull/1508) [tunetheweb](https://github.com/tunetheweb)
* Exasol: Fix typo in `REORGANIZE` statement [1509](https://github.com/sqlfluff/sqlfluff/pull/1509) [sti0](https://github.com/sti0)
* Fix bug that can prevent linting ephemeral dbt models [1496](https://github.com/sqlfluff/sqlfluff/pull/1496) [barrywhart](https://github.com/barrywhart)
* Disable rules L026 and L028 for BigQuery by default, with option to re-enable [1504](https://github.com/sqlfluff/sqlfluff/pull/1504) [tunetheweb](https://github.com/tunetheweb)
* BigQuery keywords [1506](https://github.com/sqlfluff/sqlfluff/pull/1506) [tunetheweb](https://github.com/tunetheweb)
* Inline --noqa not always honoured by "sqlfluff fix" [1502](https://github.com/sqlfluff/sqlfluff/pull/1502) [barrywhart](https://github.com/barrywhart)
* Snowflake - fix parsing of UNPIVOT [1505](https://github.com/sqlfluff/sqlfluff/pull/1505) [michael-the1](https://github.com/michael-the1)
* Better parsing of DATEADD function [1486](https://github.com/sqlfluff/sqlfluff/pull/1486) [jpers36](https://github.com/jpers36)
* Fix handling of ISNULL and NOTNULL keywords [1483](https://github.com/sqlfluff/sqlfluff/pull/1483) [leamingrad](https://github.com/leamingrad)
* Improved test cases names [1501](https://github.com/sqlfluff/sqlfluff/pull/1501) [ttomasz](https://github.com/ttomasz)
* Exasol: Fix CREATE TABLE in-/outline constraint / Adjusted DISTRIBUTE/PARTITION clause [1491](https://github.com/sqlfluff/sqlfluff/pull/1491) [sti0](https://github.com/sti0)
* Add support for SnowSQL variables [1497](https://github.com/sqlfluff/sqlfluff/pull/1497) [samlader](https://github.com/samlader)
* Ignore erroneous newline segments in L016 (e.g. Jinja for loops) [1494](https://github.com/sqlfluff/sqlfluff/pull/1494) [tunetheweb](https://github.com/tunetheweb)
* Indentation error on Jinja templated test case [1444](https://github.com/sqlfluff/sqlfluff/pull/1444) [barrywhart](https://github.com/barrywhart)
* Improve EXASOL dialect [1484](https://github.com/sqlfluff/sqlfluff/pull/1484) [sti0](https://github.com/sti0)
* T-SQL dialect - +support for CONVERT() special function [1489](https://github.com/sqlfluff/sqlfluff/pull/1489) [jpers36](https://github.com/jpers36)
* Allow Postgres column references to use `AT TIME ZONE` [1485](https://github.com/sqlfluff/sqlfluff/pull/1485) [leamingrad](https://github.com/leamingrad)
* T-SQL dialect - provide alternate ASA PR incorporating ASA into T-SQL [1478](https://github.com/sqlfluff/sqlfluff/pull/1478) [jpers36](https://github.com/jpers36)
* Modest parser performance improvement [1475](https://github.com/sqlfluff/sqlfluff/pull/1475) [NathanHowell](https://github.com/NathanHowell)
* Disable rule L033 for dialects that do not support it (e.g. Exasol, Postgres) [1482](https://github.com/sqlfluff/sqlfluff/pull/1482) [tunetheweb](https://github.com/tunetheweb)
* Adding a new BaseFileSegment class for FileSegments to inherit from [1473](https://github.com/sqlfluff/sqlfluff/pull/1473) [sti0](https://github.com/sti0)
* EXASOL_FS: Fix adapter script type [1480](https://github.com/sqlfluff/sqlfluff/pull/1480) [sti0](https://github.com/sti0)
* Dialect/tsql update - added pivot / unpivot, view support, sequence support on table creation [1469](https://github.com/sqlfluff/sqlfluff/pull/1469) [ericmuijs](https://github.com/ericmuijs)
* Correct typo in SQLFluff name [1470](https://github.com/sqlfluff/sqlfluff/pull/1470) [tunetheweb](https://github.com/tunetheweb)
* Stop L008 from adding spaces for simple SELECTs [1461](https://github.com/sqlfluff/sqlfluff/pull/1461) [CyberShadow](https://github.com/CyberShadow)
* Add SQLite dialect [1453](https://github.com/sqlfluff/sqlfluff/pull/1453) [tunetheweb](https://github.com/tunetheweb)
* Fix Windows Clause for Exasol [1463](https://github.com/sqlfluff/sqlfluff/pull/1463) [tunetheweb](https://github.com/tunetheweb)
* Add CHECK constraint syntax to ANSI SQL [1451](https://github.com/sqlfluff/sqlfluff/pull/1451) [tunetheweb](https://github.com/tunetheweb)
* Move Exasol test statements fixtures from Python to SQL files [1449](https://github.com/sqlfluff/sqlfluff/pull/1449) [tunetheweb](https://github.com/tunetheweb)
* fix spelling of "preceding" [1455](https://github.com/sqlfluff/sqlfluff/pull/1455) [jpers36](https://github.com/jpers36)
* Add NORMALIZE to Teradata dialect [1448](https://github.com/sqlfluff/sqlfluff/pull/1448) [tunetheweb](https://github.com/tunetheweb)
* Add and $ symbols to Exasol to avoid lexing errors [1447](https://github.com/sqlfluff/sqlfluff/pull/1447) [tunetheweb](https://github.com/tunetheweb)
* Stop fix adding then removing whitespace [1443](https://github.com/sqlfluff/sqlfluff/pull/1443) [barrywhart](https://github.com/barrywhart)
* Stop exception in L016 for long Jinja comments [1440](https://github.com/sqlfluff/sqlfluff/pull/1440) [tunetheweb](https://github.com/tunetheweb)
* Fix some issues where the SQL file is corrupted by lint "fixes" in or near Jinja loops [1431](https://github.com/sqlfluff/sqlfluff/pull/1431) [barrywhart](https://github.com/barrywhart)
* T-SQL: Remove Limit and NamedWindow segments as not supported in T-SQL [1420](https://github.com/sqlfluff/sqlfluff/pull/1420) [jpers36](https://github.com/jpers36)
* Fix runtime error (IndexError ) when linting file with jinja "if" [1430](https://github.com/sqlfluff/sqlfluff/pull/1430) [barrywhart](https://github.com/barrywhart)
* Add Hive dialect (985) [satish-ravi](https://github.com/satish-ravi)
* Further fix for L036 [1428](https://github.com/sqlfluff/sqlfluff/pull/1428) [tunetheweb](https://github.com/tunetheweb)
* Add default parameter to dbt "var" macro stub [1426](https://github.com/sqlfluff/sqlfluff/pull/1426) [CyberShadow](https://github.com/CyberShadow)