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)