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