sqlfluff/sqlfluff 0.6.9 on GitHub

What’s Changed

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

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

Fix broken block comments in exasol (#1565) @sti0
"Found unparsable section" instead of stack trace when multiple semicolons provided (#1517) @adam-tokarski
Fix test coverage (#1569) @tunetheweb
Remove lint_templated_tokens as no longer does anything (#1570) @tunetheweb
Rethink sequence_files in dbt templater. (#1563) @alanmcruickshank
TSQL: fix STRING_AGG() WITHIN GROUP clause (#1559) @jpers36
fix spelling: occurance>occurrence (#1507) @jpers36