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.py file in the docs folder 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 deps test 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 WITH clauses (#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