sqlfluff/sqlfluff 0.3.6

Incremental Release

on GitHub

No big things in the release, but loads of smaller bugfixes and quality of life fixes. Once again, thanks to so many people who've contributed to this release: @dmateusp, @sethwoodworth, @pwildenhain & @NiallRees.

Added

• sqlfluff dialects command to get a readout of available dialects [+ associated docs].
• More helpful error messages when trying to run in Python2.
• Window functions now parse with IGNORE/RESPECT NULLS.
• Parsing of current_timestamp and similar functions. Thanks @dmateusp.
• Snowflake QUALIFY clause.

Changed

• Respect user config directories. Thanks @sethwoodworth.
• Fix incorrect reporting of L013 with *. Thanks @dmateusp.
• Fix incorrect reporting of L027 with column aliases. Thanks @pwildenhain.
• Simplification of application of fixes and correction of a case where fixes could be depleted. Thanks @NiallRees.
• Fix functions with a similar structure to SUBSTRING.
• Refactor BigQuery REPLACE and EXCEPT clauses.
• Bigquery date parts corrected.
• Snowflake array accessors.
• Psotgres NOTNULL and ISNULL.
• Bugfix in snowflake for keywords used in semistructured queries.
• Nested WITH statements now parse.
• Performance improvements in the fix command.
• Numeric literals starting with a decimal now parse.
• Refactor the jinja templater.