[3.0.4] - 2024-04-09

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. Improved REGEXP (#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 --force flag 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 ifNotExistsGrammar to 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