sqlfluff/sqlfluff 0.9.3

on GitHub

[0.9.3] - 2022-01-26

Highlights

Major changes include:

• Add ignore_words option for rules L010, L014, L029, L030, L040
• Fix some issues in 0.9.2 preventing some queries linting

What’s Changed

• Prevent L031 throwing exception on unparsable code (#2486) @tunetheweb
• Add linting of fixtures SQL for critical rules errors to tox (#2473) @tunetheweb
• Fix L039 for T-SQL comparison operator using space (#2485) @tunetheweb
• Fix bug in get_alias causing rule Critical errors for T-SQL (#2479) @tunetheweb
• Tweak GitHub templates (#2471) @tunetheweb
• Small speed improvement to L054 (#2476) @tunetheweb
• L003: Revisit recent change to improve speed (#2474) @barrywhart
• Fix select_crawler issue with some Exasol statements (#2470) @tunetheweb
• Cleanup date logic by removing DatePartClause and using DatetimeUnitSegment instead (#2464) @tunetheweb
• Fix L044 exception when final statement has no SELECT (#2468) @tunetheweb
• Support T-SQL system variables (e.g. @@rowcount) (#2463) @tunetheweb
• Add base rule to developing rules page (#2462) @tunetheweb
• L003: Ignore indentation of lines that only exist in templated space (#2460) @barrywhart
• Ignore words for various rules (#2459) @tunetheweb
• Support Foreign Key options for MySQL (#2461) @tunetheweb
• Exclude WINDOW clauses from L054 (#2455) @tunetheweb
• Fix bug with L026 for simple deletes (#2458) @tunetheweb
• Spark3: test cases for Common Table Expressions (#2454) @R7L208
• Fix T-SQL's IDENTITY_INSERT syntax (#2452) @fdw
• T-SQL: Support stored procedures in insert statements (#2451) @fdw
• Spark3: Support for LOAD DATA statements (#2450) @R7L208