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