Highlights
This is a standard bugfix release bringing a bunch of dialect improvements and bugfixes. Almost every dialect sees some improvements and it also includes quality of life improvements to the CLI, pre-commit hooks, docs and several rules.
Thanks also to the eight new contributors whose first contributions are included in this release. 🎉🎉🏆🎉🎉
What’s Changed
- TSQL: Move PROPERTY to unreserved (#5759) @WittierDinosaur
- Mysql: Add Character Set Literals (#5755) @WittierDinosaur
- Snowflake: Support ASOF Joins (#5756) @WittierDinosaur
- Mysql: Support scoped function calls (#5757) @WittierDinosaur
- Postgres: Support pgvector vector type (#5758) @WittierDinosaur
- SQLite: Support RETURNING Clause (#5760) @WittierDinosaur
- Postgres: Allow return control structures in atomic functions (#5761) @WittierDinosaur
- ST04: Retain comments when flattening
CASE(#5753) @keraion - dbt templater: Raise UserError when using stdin (#5752) @keraion
- SQLite: Add
GLOB,MATCH. ImprovedREGEXP(#5745) @keraion - Databricks: Fix Aliases for Join-like objects (#5748) @keraion
- Add missing README ref, and issues labels (#5741) @WittierDinosaur
- Qual: Add pre-commit to CI (#5730) @mdeweerd
- Added support for 'greater/less than or equal' on ANSI CASE statement (#5728) @IliyanKostov9
- Remove
--forceflag from pre-commit hook definition (#5739) @borchero - adding snake_case to CP01 extended_capitalisation_policy (#5736) @alecsgonz
- ST04: Ignore simplifying
CASEs with different expressions (#5735) @keraion - Fix #5724 mysql: Allow Line comments without space after -- (#5731) @mdeweerd
- Fix spelling (#5729) @mdeweerd
- Fix implementation for view_column_name_list in BigQuery's CREATE VIEW (#5738) @kzosabe
- CLI: Suppress tracebacks on render/fix/format (#5734) @keraion
- Clickhouse: add parsing for select except clause (#5725) @tojahech
- Add array type support to Trino dialect (#5722) @kirkhansen
- Fix/snowflake unparsable tag in create stmt (#5720) @mariq41
- Fix/snowflake ext storage (#5714) @mariq41
- Clickhouse: add parsing for "distinct on" syntax (#5716) @tojahech
- added refresh mode init on create table statement (#5715) @IliyanKostov9
- added
ifNotExistsGrammarto Snowflake procedure (#5709) @IliyanKostov9 - Trino: 'TIMESTAMP(p)' no longer triggers LT01 (#5711) @rileymcdowell
- Snowflake: add support for streamlit (#5692) @vgw-chriskruger
New Contributors
- @vgw-chriskruger made their first contribution in #5692
- @IliyanKostov9 made their first contribution in #5709
- @tojahech made their first contribution in #5716
- @mariq41 made their first contribution in #5714
- @kirkhansen made their first contribution in #5722
- @kzosabe made their first contribution in #5738
- @mdeweerd made their first contribution in #5729
- @alecsgonz made their first contribution in #5736