sqlfluff/sqlfluff 1.1.0

SQLFluff 1.1.0

on GitHub

Highlights

Major changes include:

• L066 - New rule to allow you to set min/max length requirements for aliases to ensure they are meaningful
• L062 - addition of blocked_regex as well as blocked_words
• L025 - fix several corner cases where aliases were removed inappropriately
• L059 is now disabled by default for Postgres
• Many more dialect improvements and bug fixes.

What’s Changed

• L025: Derived query requires alias -- also handle UNION, etc. #3548 @barrywhart
• L025 should not remove aliases from derived queries #3546 @barrywhart
• T-SQL keyword functions should be treated as keywords #3540 @tunetheweb
• Fix issue where "--nocolor" is ignored [#3536)(https://github.com//pull/3536) @barrywhart
• Clickhouse: allow FINAL modifier #3534 @ThomAub
• L018 change to just check for newlines rather than alignment #3499 @zidder
• SparkSQL: Update terminator grammar for HAVING, WHERE, GROUP BY #3526 @R7L208
• Fix L025 false positive for T-SQL VALUES clause #3533 @barrywhart
• New rule L066 for enforcing table alias lengths #3384 @f0rk
• Redshift: CALL statement #3529 @greg-finley
• Core: Compile regexes at init time to avoid overhead #3511 @judahrand
• Disable L059 by default for Postgres #3528 @tunetheweb
• Core: Add MultiStringParser to match a collection of strings #3510 @judahrand
• SQLite: PRIMARY KEY AUTOINCREMENT #3527 @greg-finley
• MySQL: Support LOAD DATA #3518 @greg-finley
• Redshift: GRANT EXECUTE ON PROCEDURES #3516 @greg-finley
• Allow DEFAULT expression in Redshift ALTER TABLE ADD COLUMN statements #3513 @menzenski
• BigQuery: Fix parsing of Array creation from full subquery #3502 @judahrand
• SparkSQL: Allow dateparts as table aliases #3500 @R7L208
• Fix load_macros_from_path to actually support multiple paths #3488 @emancu
• Allow linter to apply fixes spanning more than 2 slices #3492 @barrywhart
• Fix L022 false positive when the CTE definition has a column list #3490 @barrywhart
• SparkSQL: Support for Delta RESTORE statement #3486 @R7L208
• Add values function to SET clause #3483 @hgranthorner
• SparkSQL: Support for CONVERT TO DELTA command #3482 @R7L208
• BigQuery: Remaining procedural statements #3473 @tunetheweb
• Postgres: support grouping sets #3477 @tunetheweb
• SparkSQL: Support for Delta syntax to create manifest files through the GENERATE command #3478 @R7L208
• Add config for optionally indenting contents of ON blocks #3471 @PeterBalsdon
• L026: check standalone aliases as well as table aliases #3470 @tunetheweb
• L045: Add handling for nested queries and CTEs #3468 @barrywhart
• L062: add blocked_regex support #3467 @tunetheweb
• SparkSQL: Support for the Delta DESCRIBE DETAIL command #3465 @R7L208

New Contributors

• @PeterBalsdon made their first contribution in #3471
• @hgranthorner made their first contribution in #3483
• @emancu made their first contribution in #3488
• @judahrand made their first contribution in #3502
• @f0rk made their first contribution in #3384
• @zidder made their first contribution in #3499
• @ThomAub made their first contribution in #3534