Sqlfluff

Fixed some of our autofix rules where running `fix` sometimes made unintended changes. Added config to rules L011 and L012 to allow preferring implicit aliasing. Also further improved our Postgres support and documentation.

What’s Changed
* Rule L036 bug fixes [1427](https://github.com/sqlfluff/sqlfluff/pull/1427) [tunetheweb](https://github.com/tunetheweb)
* Added support for psql meta commands to Postgres [1423](https://github.com/sqlfluff/sqlfluff/pull/1423) [WittierDinosaur](https://github.com/WittierDinosaur)
* Remaining line endings [1415](https://github.com/sqlfluff/sqlfluff/pull/1415) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Remove match possibilities for segments with no T-SQL equivalent [1416](https://github.com/sqlfluff/sqlfluff/pull/1416) [jpers36](https://github.com/jpers36)
* Fix generate error on test file with just a comment [1413](https://github.com/sqlfluff/sqlfluff/pull/1413) [tunetheweb](https://github.com/tunetheweb)
* Misc fixes to workflow files [1412](https://github.com/sqlfluff/sqlfluff/pull/1412) [tunetheweb](https://github.com/tunetheweb)
* Added support for escape character strings to Postgres [1409](https://github.com/sqlfluff/sqlfluff/pull/1409) [WittierDinosaur](https://github.com/WittierDinosaur)
* Issue 845: L016 should compute line length prior to template expansion [1411](https://github.com/sqlfluff/sqlfluff/pull/1411) [barrywhart](https://github.com/barrywhart)
* Add .editorconfig config and enforce style rules [1410](https://github.com/sqlfluff/sqlfluff/pull/1410) [tunetheweb](https://github.com/tunetheweb)
* Allow optional enforcing of implicit aliasing of tables (L011) and columns (L012) [1402](https://github.com/sqlfluff/sqlfluff/pull/1402) [tunetheweb](https://github.com/tunetheweb)
* Better error messages on error [1407](https://github.com/sqlfluff/sqlfluff/pull/1407) [tunetheweb](https://github.com/tunetheweb)
* Add README on how to generate docs [1403](https://github.com/sqlfluff/sqlfluff/pull/1403) [tunetheweb](https://github.com/tunetheweb)
* Fix extra underscores in case rules (L010 and L014) [1396](https://github.com/sqlfluff/sqlfluff/pull/1396) [tunetheweb](https://github.com/tunetheweb)
* Remove unused deps in tox test docbuild [1406](https://github.com/sqlfluff/sqlfluff/pull/1406) [zhongjiajie](https://github.com/zhongjiajie)
* Prevent CodeCov commenting on coverage differences too early [1404](https://github.com/sqlfluff/sqlfluff/pull/1404) [tunetheweb](https://github.com/tunetheweb)
* Fix "sqlfluff fix compatible" rules indenting to much in documentation [1405](https://github.com/sqlfluff/sqlfluff/pull/1405) [tunetheweb](https://github.com/tunetheweb)
* Fix documentation SQL highlight error [1393](https://github.com/sqlfluff/sqlfluff/pull/1393) [zhongjiajie](https://github.com/zhongjiajie)
* Support TIMESTAMPTZ in TIME ZONE queries for Postgres [1398](https://github.com/sqlfluff/sqlfluff/pull/1398) [tunetheweb](https://github.com/tunetheweb)
* Improve datatypes: CHARACTER VARYING for ANSI, and Postgres and also TIMESTAMP AT TIME ZONE for Postgres [1378](https://github.com/sqlfluff/sqlfluff/pull/1378) [WittierDinosaur](https://github.com/WittierDinosaur)
* Improve rules L003 and L019 by processing multi-line fixes in one pass. [1391](https://github.com/sqlfluff/sqlfluff/pull/1391) [barrywhart](https://github.com/barrywhart)
* Correct codecov badge for Docs website [1390](https://github.com/sqlfluff/sqlfluff/pull/1390) [tunetheweb](https://github.com/tunetheweb)
* Change fix to use non-zero exit code if unfixable [1389](https://github.com/sqlfluff/sqlfluff/pull/1389) [tunetheweb](https://github.com/tunetheweb)
* Bugfix, frame clauses in window functions were not working [1381](https://github.com/sqlfluff/sqlfluff/pull/1381) [WittierDinosaur](https://github.com/WittierDinosaur)
* Handle template and unfixable errors when fixing stdin [1385](https://github.com/sqlfluff/sqlfluff/pull/1385) [nolanbconaway](https://github.com/nolanbconaway)
* CREATE, ALTER, DROP SEQUENCE support, with Postgres extensions [1380](https://github.com/sqlfluff/sqlfluff/pull/1380) [WittierDinosaur](https://github.com/WittierDinosaur)
* Postgres analyze [1377](https://github.com/sqlfluff/sqlfluff/pull/1377) [WittierDinosaur](https://github.com/WittierDinosaur)
* L016: "sqlfluff fix" adds too many newlines [1382](https://github.com/sqlfluff/sqlfluff/pull/1382) [barrywhart](https://github.com/barrywhart)
* L003 fix mixes hanging and clean indents [1383](https://github.com/sqlfluff/sqlfluff/pull/1383) [barrywhart](https://github.com/barrywhart)
* L034 should not fix inside "INSERT" or "CREATE TABLE AS SELECT" [1384](https://github.com/sqlfluff/sqlfluff/pull/1384) [barrywhart](https://github.com/barrywhart)

What’s Changed

This release includes initial support of Transact-SQL (T-SQL), much better Postgres and Snowflake support, improvements to our documentation, 100% coverage for Python code (with a small number of accepted exceptions), along with numerous other bug fixes and improvements.

Many thanks to all the [contributors](https://github.com/sqlfluff/sqlfluff/graphs/contributors) helping to improve SQLFluff!

Complete list of changes

* Simplify rule L030 and fix recursion bug ([1376](https://github.com/sqlfluff/sqlfluff/pull/1376)) ([tunetheweb](https://github.com/tunetheweb)
* Move from CircleCI to GitHub Actions for Continuous Integration ([1361](https://github.com/sqlfluff/sqlfluff/pull/1361)) ([tunetheweb](https://github.com/tunetheweb)
* Postgres enhance create index ([1375](https://github.com/sqlfluff/sqlfluff/pull/1375)) ([WittierDinosaur](https://github.com/WittierDinosaur)
* Initial support for Transact-SQL (T-SQL) dialect ([1313](https://github.com/sqlfluff/sqlfluff/pull/1313)) ([ericmuijs](https://github.com/ericmuijs)
* Handle initial whitespace lines in rule L001 ([1372](https://github.com/sqlfluff/sqlfluff/pull/1372)) ([tunetheweb](https://github.com/tunetheweb)
* Postgres Improved DEFAULT column constraint support ([1373](https://github.com/sqlfluff/sqlfluff/pull/1373)) ([WittierDinosaur](https://github.com/WittierDinosaur)
* Minor grammar, spelling, and readability fixes ([1370](https://github.com/sqlfluff/sqlfluff/pull/1370)) ([WittierDinosaur](https://github.com/Fdawgs)
* Issues 854, 1321: Handle Jinja leading whitespace-only lines ([1364](https://github.com/sqlfluff/sqlfluff/pull/1364)) ([barrywhart](https://github.com/barrywhart)
* Enhanced the Postgres grammar for create table ([1369](https://github.com/sqlfluff/sqlfluff/pull/1369)) ([WittierDinosaur](https://github.com/WittierDinosaur)
* Added ability to Grant and Revoke Grant to multiple users ([1367](https://github.com/sqlfluff/sqlfluff/pull/1367)) ([WittierDinosaur](https://github.com/WittierDinosaur)
* Add BigQuery Parameter Lexing and Parsing ([1363](https://github.com/sqlfluff/sqlfluff/pull/1363)) ([rileyrunnoe](https://github.com/rileyrunnoe)
* Rule L030 bugfix ([1360](https://github.com/sqlfluff/sqlfluff/pull/1360)) ([WittierDinosaur](https://github.com/WittierDinosaur)
* Add Postgres dialect for COMMENT ON ([1358](https://github.com/sqlfluff/sqlfluff/pull/1358)) ([miketheman](https://github.com/miketheman)
* Allow ORDER BY and LIMIT after QUALIFY in BigQuery ([1362](https://github.com/sqlfluff/sqlfluff/pull/1362)) ([tunetheweb](https://github.com/tunetheweb)
* Correct CircleCI badge reference ([1359](https://github.com/sqlfluff/sqlfluff/pull/1359)) [miketheman](https://github.com/miketheman)
* Minor grammar corrections to documentation ([1355](https://github.com/sqlfluff/sqlfluff/pull/1355)) [miketheman](https://github.com/miketheman)
* Pytest coverage exceptions to get us to 100% coverage! ([1346](https://github.com/sqlfluff/sqlfluff/pull/1346)) [tunetheweb](https://github.com/tunetheweb)
* Greatly improved Snowflake syntax support ([1353](https://github.com/sqlfluff/sqlfluff/pull/1353)) [tunetheweb](https://github.com/tunetheweb)
* Postgres keyword support ([1347](https://github.com/sqlfluff/sqlfluff/pull/1347)) [WittierDinosaur](https://github.com/WittierDinosaur)
* Added full support for postgres's ALTER DEFAULT PRIVILEGES. ([1350](https://github.com/sqlfluff/sqlfluff/pull/1350)) [creste](https://github.com/creste)
* Show all LintResult in Rule_L020 ([1348](https://github.com/sqlfluff/sqlfluff/pull/1348)) [zhongjiajie](https://github.com/zhongjiajie)
* Enhance error message L010 base on configure ([1351](https://github.com/sqlfluff/sqlfluff/pull/1351)) [zhongjiajie](https://github.com/zhongjiajie)
* Remove unused variable insert_str ([1352](https://github.com/sqlfluff/sqlfluff/pull/1352)) [zhongjiajie](https://github.com/zhongjiajie)
* Pytest coverage exceptions for Core code - part 1 ([1343](https://github.com/sqlfluff/sqlfluff/pull/1343)) [tunetheweb](https://github.com/tunetheweb)
* BigQuery: Allow Qualify Clause for UnorderedSelectStatements ([1341](https://github.com/sqlfluff/sqlfluff/pull/1341)) [tunetheweb](https://github.com/tunetheweb)
* Postgres "ALTER TABLE" enhancement, and timestamp bug fix ([1338](https://github.com/sqlfluff/sqlfluff/pull/1338)) [WittierDinosaur](https://github.com/WittierDinosaur)
* Improve pytest coverage for non-core code ([1319](https://github.com/sqlfluff/sqlfluff/pull/1319)) [tunetheweb](https://github.com/tunetheweb)
* Support additional GRANTs in Postgres ([1339](https://github.com/sqlfluff/sqlfluff/pull/1339)) [creste](https://github.com/creste)
* Allow optional alias for BigQuery WITH OFFSET ([1330](https://github.com/sqlfluff/sqlfluff/pull/1330)) [tunetheweb](https://github.com/tunetheweb)
* Improve function support in Postgres dialect ([1336](https://github.com/sqlfluff/sqlfluff/pull/1336)) [WittierDinosaur](https://github.com/WittierDinosaur)
* Using github star instead of watch in docs ([1337](https://github.com/sqlfluff/sqlfluff/pull/1337)) [zhongjiajie](https://github.com/zhongjiajie)
* Add unittest for rules docstring ([1335](https://github.com/sqlfluff/sqlfluff/pull/1335)) [zhongjiajie](https://github.com/zhongjiajie)
* Bugfix PR, fixes issue [1333](https://github.com/sqlfluff/sqlfluff/issues/#1333), wherein test___main___help() defaults to your default Python installation ([1334](https://github.com/sqlfluff/sqlfluff/pull/1334)) [WittierDinosaur](https://github.com/WittierDinosaur)
* Improve wording of L007 now the before/after is configurable ([1325](https://github.com/sqlfluff/sqlfluff/pull/1325)) [tunetheweb](https://github.com/tunetheweb)
* Fix a couple of small issues with CI jobs ([1326](https://github.com/sqlfluff/sqlfluff/pull/1326)) [tunetheweb](https://github.com/tunetheweb)
* Add updated sqlfluff graphics and source. ([1315](https://github.com/sqlfluff/sqlfluff/pull/1315)) [alanmcruickshank](https://github.com/alanmcruickshank)
* Issue 1277: Enforce that YML test files are computer generated and not edited ([1279](https://github.com/sqlfluff/sqlfluff/pull/1279)) [barrywhart](https://github.com/barrywhart)
* Fix typo in README ([1320](https://github.com/sqlfluff/sqlfluff/pull/1320)) [tunetheweb](https://github.com/tunetheweb)
* Fix link in README ([1316](https://github.com/sqlfluff/sqlfluff/pull/1316)) [jmks](https://github.com/jmks)
* Update documentation to make the project more discoverable ([1311](https://github.com/sqlfluff/sqlfluff/pull/1311)) [tunetheweb](https://github.com/tunetheweb)
* Show latest version number on unsupported Python error message ([1307](https://github.com/sqlfluff/sqlfluff/pull/1307)) [zhongjiajie](https://github.com/zhongjiajie)
* Fix typo in github PR template ([1308](https://github.com/sqlfluff/sqlfluff/pull/1308)) [zhongjiajie](https://github.com/zhongjiajie)

Added
* Added support for empty WINDOWS specifications ([1293](https://github.com/sqlfluff/sqlfluff/pull/1293)) [matthieucan](https://github.com/matthieucan)
* Added auto release drafter ([1287](https://github.com/sqlfluff/sqlfluff/pull/1287)) [tunetheweb](https://github.com/tunetheweb)

Changed
* Fix typo in the in the wild page ([1285](https://github.com/sqlfluff/sqlfluff/pull/1285)) [tunetheweb](https://github.com/tunetheweb)
* Fix spacing issue for BigQuery UNNEST statement for rules L003 and L025 ([1303](https://github.com/sqlfluff/sqlfluff/pull/1303)) [tunetheweb](https://github.com/tunetheweb)
* Update GitHub templates ([1297](https://github.com/sqlfluff/sqlfluff/pull/1297)) [tunetheweb](https://github.com/tunetheweb)
* Allow BigQuery UDF with triple quoted bodies to pass rule L048 ([1300](https://github.com/sqlfluff/sqlfluff/pull/1300)) [tunetheweb](https://github.com/tunetheweb)
* Add Parameterless Functions and more function names support to BigQuery ([1299](https://github.com/sqlfluff/sqlfluff/pull/1299)) [tunetheweb](https://github.com/tunetheweb)
* Add release drafter ([1295](https://github.com/sqlfluff/sqlfluff/pull/1295)) [tunetheweb](https://github.com/tunetheweb)
* Support empty OVER() clause in Window Specification ([1294](https://github.com/sqlfluff/sqlfluff/pull/1294)) [tunetheweb](https://github.com/tunetheweb)
* Fix typo on the In the Wild page ([1285](https://github.com/sqlfluff/sqlfluff/pull/1285)) [tunetheweb](https://github.com/tunetheweb)

Added

- Support for primary index name, collect stats improvement, COMMENT statement for teradata dialect [1232](https://github.com/sqlfluff/sqlfluff/issues/1232)
- Support config for L007 to prefer end of line operators [1261](https://github.com/sqlfluff/sqlfluff/issues/1261)
- Support for DETERMINISTIC user defined functions in BigQuery dialect [1251](https://github.com/sqlfluff/sqlfluff/issues/1251)
- Support more identifiers in BigQuery dialect [1253](https://github.com/sqlfluff/sqlfluff/issues/1253)
- Support function member field references in BigQuery dialect [1255](https://github.com/sqlfluff/sqlfluff/issues/1255)
- Support alternative indentation for USING and ON clauses [1250](https://github.com/sqlfluff/sqlfluff/issues/1250)
- Support COUNT(0) preference over COUNT(*) or COUNT(1) [1260](https://github.com/sqlfluff/sqlfluff/issues/1260)
- Support for BigQuery "CREATE table OPTIONS ( description = 'desc' )" [1205](https://github.com/sqlfluff/sqlfluff/issues/1205)
- Support wildcard member field references in BigQuery dialect [1269](https://github.com/sqlfluff/sqlfluff/issues/1269)
- Support ARRAYS of STRUCTs in BigQuery dialect [1271](https://github.com/sqlfluff/sqlfluff/issues/1271)
- Support fields of field references in BigQuery dialect [1276](https://github.com/sqlfluff/sqlfluff/issues/1276)
- Support OFFSET and ORDINAL clauses of Array Functions in BigQuery dialect [1171](https://github.com/sqlfluff/sqlfluff/issues/1171)
- Added check for generated YML files [1277](https://github.com/sqlfluff/sqlfluff/issues/1277)
- Support QUALIFY to BigQuery dialect [1242](https://github.com/sqlfluff/sqlfluff/issues/1242)

Changed

- Fix comma removed by L019 [939](https://github.com/sqlfluff/sqlfluff/issues/939)
- Update L019 (leading/trailng comma rule) so it doesn't run on unparsable code.
- The `--nocolor` command-line option should suppress emoji output [1246](https://github.com/sqlfluff/sqlfluff/issues/1246)
- Added HTTP Archive to the [In The Wild page](https://docs.sqlfluff.com/en/stable/inthewild.html)

Added

- Support for looping statements (loop, while, repeat) and supporting statements to mysql dialect [1180](https://github.com/sqlfluff/sqlfluff/issues/1180)

Changed

- Added dbt 0.20.* to the default test suite.
- Updated manifest loading in dbt 0.20.* to use the new `ManifestLoader` [1220](https://github.com/sqlfluff/sqlfluff/pull/1220)
- Handle newlines in rule list configuration in .sqlfluff [1215](https://github.com/sqlfluff/sqlfluff/issues/1215)
- Fix looping interaction between L008 and L030 [1207](https://github.com/sqlfluff/sqlfluff/issues/1207)

Added

- Linting output now supports GitHub Actions [1190](https://github.com/sqlfluff/sqlfluff/issues/1190)
- Support for QUALIFY syntax specific to teradata dialect [1184](https://github.com/sqlfluff/sqlfluff/issues/1184)
- Support for TRUNCATE statement [1194](https://github.com/sqlfluff/sqlfluff/pull/1194)
- Support for prepared statement syntaxes specific to mysql dialect [1147](https://github.com/sqlfluff/sqlfluff/issues/1147)
- Support for GET DIAGNOSTICS statement syntax specific to mysql dialect [1148](https://github.com/sqlfluff/sqlfluff/issues/1148)
- Support for cursor syntax specific to mysql dialect [1145](https://github.com/sqlfluff/sqlfluff/issues/1145)
- Support sequential shorthand casts [1178](https://github.com/sqlfluff/sqlfluff/pull/1178)
- Support for select statement syntax specific to mysql dialect [1175](https://github.com/sqlfluff/sqlfluff/issues/1175)
- Support for the CALL statement for the mysql dialect [1144](https://github.com/sqlfluff/sqlfluff/issues/1144)
- Support for OVERLAPS predicate [1091](https://github.com/sqlfluff/sqlfluff/issues/1091)
- Support for the CREATE/DROP PROCEDURE statement for the mysql dialect [901](https://github.com/sqlfluff/sqlfluff/issues/901)
- Specific allowed/required syntaxes for CREATE/DROP FUNCTION within the mysql dialect [901](https://github.com/sqlfluff/sqlfluff/issues/901)
- Support for DECLARE statement for the mysql dialect [1140](https://github.com/sqlfluff/sqlfluff/issues/1140)
- Support for the IF-THEN-ELSEIF-ELSE syntax for the mysql dialect [1140](https://github.com/sqlfluff/sqlfluff/issues/1140)
- Support for the DEFINER syntax for the mysql dialect [1131](https://github.com/sqlfluff/sqlfluff/issues/1131)
- Preserve existing file encoding in the "fix" command. Partially addresses [654](https://github.com/sqlfluff/sqlfluff/issues/654)
- Support for DECLARE and SET variable syntax for the BigQuery dialect [1127](https://github.com/sqlfluff/sqlfluff/issues/1127)
- Support for ALTER TASK statement on Snowflake [1211](https://github.com/sqlfluff/sqlfluff/pull/1211)

Changed

- Fix runtime error in diff-cover plugin caused by new diff-cover release 6.1.0 [1195](https://github.com/sqlfluff/sqlfluff/pull/1195)
- Resolved an issue with the snowflake dialect where backslash escaped single
quoted strings led to fatal lexing errors [1200](https://github.com/sqlfluff/sqlfluff/pull/1200)

Contributors

- [GitHub-Username](Link to GitHub profile) ([PR-Number](Link to PR))
- [dflss](https://github.com/dflss) ([#1154](https://github.com/sqlfluff/sqlfluff/pull/1154))
- [barrywhart](https://github.com/barrywhart) ([#1177](https://github.com/sqlfluff/sqlfluff/pull/1177), [#1195](https://github.com/sqlfluff/sqlfluff/pull/1195))
- [niallrees](https://github.com/niallrees) ([#1178](https://github.com/sqlfluff/sqlfluff/pull/1178))
- [barnabyshearer](https://github.com/barnabyshearer) ([#1194](https://github.com/sqlfluff/sqlfluff/pull/1194))
- [silverbullettruck2001](https://github.com/silverbullettruck2001) ([#1141](https://github.com/sqlfluff/sqlfluff/pull/1141), [#1159](https://github.com/sqlfluff/sqlfluff/pull/1159), [#1161](https://github.com/sqlfluff/sqlfluff/pull/1161), [#1176](https://github.com/sqlfluff/sqlfluff/pull/1176), [#1179](https://github.com/sqlfluff/sqlfluff/pull/1179), [#1181](https://github.com/sqlfluff/sqlfluff/pull/1181), [#1193](https://github.com/sqlfluff/sqlfluff/pull/1193), [#1203](https://github.com/sqlfluff/sqlfluff/pull/1203))