sqlfluff/sqlfluff 0.9.4

on GitHub

[0.9.4] - 2022-01-30

Highlights

Major changes include:

• dbt performance improvements
• Fix click dependency error.
• Better datepart versus identifier parsing.
• Fix some Jinja errors.
• Various grammar fixes and improvements

What’s Changed

• Spark3: test cases for HAVING clause in SELECT statement (#2517) @R7L208
• Update click version requirement in setup.cfg to match that in requirements.txt (#2518) @barrywhart
• Postgres: Implement DO Statements + Refactored Language Clause (#2511) @PLBMR
• Spark3: Support for Grouping Sets, CUBE and ROLLUP in GROUP BY clause of SELECT statement (#2505) @R7L208
• Refactor date part functions (#2510) @tunetheweb
• Postgres: EXPLAIN ANALYSE allows British spelling (#2507) @jpy-git
• "noqa": Add support for ignoring template (TMP) and parse (PRS) errors (#2509) @barrywhart
• Freeze Black due to incompatibility between 22.1 and flake8-black (#2513) @tunetheweb
• Support NATURAL JOINS (#2506) @tunetheweb
• dbt Docker environment: Mount the test profiles.yml at ~/.dbt (#2502) @barrywhart
• Add dbt_artifacts package to in the wild docs (#2504) @NiallRees
• Spark3: Support DISTRIBUTE BY clause in SELECT statement (#2503) @R7L208
• dbt templater: For performance reasons, cache the database connection across models (#2498) @barrywhart
• Bug fix: Defining and using Jinja macro in the same file causes runtime error (#2499) @barrywhart
• Spark3: Support CLUSTER BY clause in SELECT statement (#2491) @R7L208
• Grammar: Adds support for COPY statement for Postgres dialect (#2481) @derickl
• Add raiserror for T-SQL (#2490) @fdw
• Enforce parentheses for function definitions in T-SQL (#2489) @fdw
• Add guards to prevent rule crashes (#2488) @barrywhart

New Contributors

• @PLBMR made their first contribution in #2511

Full Changelog: 0.9.3...0.9.4