Lots of fixes to our rules (particularly when running sqlfluff fix, and particularly for Jinja and DBT templates). We also have good improvements to Exasol, Snowflake, and T-SQL dialects amongst others. Plus we added Hive and SQLite as supported dialects!
What’s Changed
- Snowflake better WAREHOUSE and CREATE (EXTERNAL) TABLES support (#1508) @tunetheweb
- Exasol: Fix typo in
REORGANIZEstatement (#1509) @sti0 - Fix bug that can prevent linting ephemeral dbt models (#1496) @barrywhart
- Disable rules L026 and L028 for BigQuery by default, with option to reenable (#1504) @tunetheweb
- BigQuery keywords (#1506) @tunetheweb
- Inline --noqa not always honoured by "sqlfluff fix" (#1502) @barrywhart
- Snowflake - fix parsing of UNPIVOT (#1505) @michael-the1
- Better parsing of DATEADD function (#1486) @jpers36
- Fix handling of
ISNULLandNOTNULLkeywords (#1483) @leamingrad - Improved test cases names (#1501) @ttomasz
- Exasol: Fix
CREATE TABLEin-/outline constraint / Adjusted DISTRIBUTE/PARTITION clause (#1491) @sti0 - Add support for SnowSQL variables (#1497) @samlader
- Ignore erroneous newline segments in L016 (e.g. Jinja for loops) (#1494) @tunetheweb
- Indentation error on Jinja templated test case (#1444) @barrywhart
- Improve EXASOL dialect (#1484) @sti0
- TSQL dialect - +support for CONVERT() special function (#1489) @jpers36
- Allow Postgres column references to use
AT TIME ZONE(#1485) @leamingrad - TSQL dialect - provide alternate ASA PR incorporating ASA into TSQL (#1478) @jpers36
- Modest parser performance improvement (#1475) @NathanHowell
- Disable rule L033 for dialects that do not support it (e.g. Exasol, Postgres) (#1482) @tunetheweb
- Adding a new BaseFileSegment class for FileSegments to inherit from (#1473) @sti0
- EXASOL_FS: Fix adapter script type (#1480) @sti0
- Dialect/tsql update - added pivot / unpivot, view support, sequence support on table creation (#1469) @ericmuijs
- Correct typo in SQLFluff name (#1470) @tunetheweb
- Stop L008 from adding spaces for simple SELECTs (#1461) @CyberShadow
- Add SQLite dialect (#1453) @tunetheweb
- Fix Windows Clause for Exasol (#1463) @tunetheweb
- Add CHECK constraint syntax to ANSI SQL (#1451) @tunetheweb
- Move Exasol test statements fixtures from Python to SQL files (#1449) @tunetheweb
- fix spelling of "preceding" (#1455) @jpers36
- Add NORMALIZE to Teradata dialect (#1448) @tunetheweb
- Add @ and $ symbols to Exasol to avoid lexing errors (#1447) @tunetheweb
- Stop fix adding then removing whitespace (#1443) @barrywhart
- Stop exception in L016 for long Jinja comments (#1440) @tunetheweb
- Fix some issues where the SQL file is corrupted by lint "fixes" in or near Jinja loops (#1431) @barrywhart
- TSQL: Remove Limit and NamedWindow segments as not supported in T-SQL (#1420) @jpers36
- Fix runtime error (IndexError ) when linting file with jinja "if" (#1430) @barrywhart
- Add Hive dialect (#985) @satish-ravi
- Further fix for L036 (#1428) @tunetheweb
- Add default parameter to dbt "var" macro stub (#1426) @CyberShadow