Highlights
This release brings support for dbt 1.5+. Some internals of dbt mean that SQFluff versions prior to this release may experience errors with dbt versions post 1.5. In addition to that there are some dialect and templating improvements bundled too:
- Support for custom Jinja filters.
- An additional configurable indent behaviour within
CASE WHENclauses. - Additional support for bracket quoted literals in TSQL and RF06.
- Dialect improvements to Snowflake, Hive, Redshift, Postgres, Clickhouse, Oracle and SQLite
What’s Changed
- Add support for Jinja filters #4810 @dmohns
- Postgres: Allow INSERT RETURNING #4820 @WittierDinosaur
- SQLite: Support partial index #4833 @WittierDinosaur
- Make SQLFluff compatible with DBT 1.5 #4828 @WittierDinosaur
- Snowflake dialect: Add support for comment clause in the create warehouse statement #4823 @moreaupascal56
- fix(dialect-clickhouse): Support DROP statements #4821 @germainlefebvre4
- Hive: INSERT INTO without TABLE keyword #4819 @greg-finley
- Fix: Small typo in error message #4814 @JavierMonton
- Redshift: Support with no schema binding #4813 @WittierDinosaur
- Detect tsql square bracket quotes for RF06 #4724 #4781 @daviewales
- Apply implicit indents to
WHENblocks and introduceindented_then_contents#4755 @borchero - Oracle: Update Drop Behaviour #4803 @WittierDinosaur
- Oracle: Update bare functions #4804 @WittierDinosaur
New Contributors
- @daviewales made their first contribution in #4781