Highlights
This release brings a bumper lot of bugfixes, dialect improvements and other minor improvements across the board. Most notably:
- A rework of the structure of the docs. NOTE: This does change the url of some docs pages, but to prevent future moves, we’ve also provided permalinks to most important pages and rules. See the
conf.pyfile in thedocsfolder for a full list of permalinks. - Solving rule conflicts between LT02 & LT02.
- Bugfixes to AM07, CV11, ST03, ST05 & RF03,
- Removes some redundant dependencies in for the dbt templater (which haven’t been required for some time, but have been included in the install dependencies). Specifically:
markupsafe,ruamel.yaml,pydantic&rich. - And too many dialect improvements to summarise!
We’ve also seen fifteen new contributors to the project! Thanks to all of them for taking the time to contribute. 🎉🎉🏆🎉🎉
What’s Changed
- dbt Templater: Increase
dbt depstest fixture timeout (#6088) @keraion - SparkSQL + Databricks: Add support for raw string literals (#6089) @D-to-the-K
- fixes #4855 – Add DECLARE statement in snowflake dialect (#6059) @YungChunLu
- Adding CTE to mysql views (#6077) @gone
- Rationalise config discovery routines. (#6080) @alanmcruickshank
- fix(dialect-trino): Trino ROW datatype definition in queries (#6085) @bonisb
- Databricks: Add support for GROUP BY ALL (#6082) @D-to-the-K
- fix(clickhouse): add support for tuple() and ENGINE MergeTree (#6079) @ogirardot
- Add perma-links for rules (#6066) @alanmcruickshank
- fix(clickhouse): add support for rename statement (#6073) @ogirardot
- fix(clickhouse): add support for INTO OUTFILE and supported FORMATs (#6065) @ogirardot
- LT04: Fix indentation conflict with LT02 (#6068) @keraion
- pre-commit: Disable progress bar (#6069) @keraion
- feat(clickhouse): add support for decimal(x,y), decimal32(x) and match (#6063) @ogirardot
- Big docs refactor. (#6052) @alanmcruickshank
- ST05: Handle set statement’s subsequent queries (#6062) @keraion
- fix(clickhouse): add support for limit by and bracketed format (#6061) @ogirardot
- fix(clickhouse): add support for DateTime64(precision, tz) and Tuples() (#6060) @ogirardot
- Copy statement postgres v9 compatibility support (#5181) @Fullcure3
- Run dbt tests in py312 by default (#5861) @alanmcruickshank
- Extract path discovery routines from config and linter. (#6057) @alanmcruickshank
- MySQL: Added SET TRANSACTION parsing (#5781) @Xemptuous
- Support declare or replace variable statement for Databricks dialect (#6054) @urosstan-db
- Exclude Macros from a path provided (#6031) @culpgrant
- ST03: Detect CTE usage in nested
WITHclauses (#6017) @keraion - TRINO: support FILTER after WITHIN GROUP agg expression (#6056) @rileymcdowell
- Fix/snowflake double quotes (#5727) @Starstruckk
- bq_table_function : Added functionality to parse table functionsin BigQuery (#5480) @moh-lch
- Fix Athena Partitioned By format for iceberg tables (#5399) @jverhoeks
- fix: redshift dialect, EXTENSION added (#6025) @rafalbog
- Fix ignored inline rule overrides (#5697) (#6010) @alesbukovsky
- Update the docs on RF03 (#6051) @alanmcruickshank
- RF03: Fixed some subquery reference scenarios (#6046) @keraion
- CV11: Remove rogue print statement (#6047) @keraion
- Snowflake: fixes parsing for AGGREGATE in CREATE FUNCTION statement (#6049) @hawle
- Snowflake:adds optional IF NOT EXISTS to ADD COLUMN (#6050) @hawle
- Replace types-pkg-resources with types-setuptools (#6039) @keraion
- Remove old deps for dbt templater (#6028) @alanmcruickshank
- Added GENERATED AS IDENTITY support to DataBricks dialect (#6004) @nicolb2305
- Add support for Clickhouse ORDER BY WITH FILL (#6018) @snikch
- Parse API example (#6021) @alanmcruickshank
- Add additional dateparts from DATEPART() (#6012) @yorickbouma
- MariaDB: Add support for GROUP BY … ASC/DESC and GROUP BY … WITH ROLLUP (#6009) @pprkut
- AM07: Handle set expressions with bracketed selects (#6005) @keraion
- MariaDB: Add support for DELETE/INSERT/REPLACE … RETURNING (#6008) @pprkut
- MariaDB: Add mariadb specific syntax for generated columns (#6007) @pprkut
- Snowflake: fixes drop column if exists parsing rules (#5999) @hawle
- Fix TSQL Post Table Expr intrepreted as function (#6001) @ulixius9
New Contributors
- @yorickbouma made their first contribution in #6012
- @snikch made their first contribution in #6018
- @nicolb2305 made their first contribution in #6004
- @alesbukovsky made their first contribution in #6010
- @rafalbog made their first contribution in #6025
- @jverhoeks made their first contribution in #5399
- @moh-lch made their first contribution in #5480
- @Starstruckk made their first contribution in #5727
- @culpgrant made their first contribution in #6031
- @urosstan-db made their first contribution in #6054
- @ogirardot made their first contribution in #6060
- @D-to-the-K made their first contribution in #6082
- @bonisb made their first contribution in #6085
- @gone made their first contribution in #6077
- @YungChunLu made their first contribution in #6059
Source: https://github.com/sqlfluff/sqlfluff/releases/tag/3.1.1