[3.0.0a3] - 2023-11-29

Highlights

This brings no further breaking changes on top of 3.0.0a2, but instead releases a few of the more minor fixes flowing through while other breaking changes are staged in. In particular there are a few dialect improvements for Snowflake, TSQL, SQLite and Databricks alongside a few further improvements to deployment scripts off the back of earlier changes for 3.x.

What’s Changed

• fix assertion in test__api__lint_string_specific_exclude_single #5437 @gvozdvmozgu
• Databricks CLUSTER BY and OPTIMIZE #5436 @greg-finley
• TSQL: ON DELETE NO ACTION #5434 @greg-finley
• Snowflake dynamic table #5435 @greg-finley
• Support parsing CONSTRAINT definitions when creating Delta Live Tables in SparkSQL/Databricks #5438 @rocwang
• adds few fixes for databricks/sparksql #5431 @markbaas
• TSQL: CREATE USER {FOR|FROM} LOGIN #5426 @greg-finley
• Snowflake Create table order/noorder #5421 @greg-finley
• Simplify Snowflake regexes #5419 @greg-finley
• Permit .* after each tbl_name in multi-table delete syntax #5408 @yoichi
• Fix snowflake add search optimization grant #5412 @jongracecox
• ANSI: Allow combination of UNION clause and WITH clause #5413 @yoichi
• SQLite: Allow block comments to be terminated by end of input #5400 @WittierDinosaur
• Update publish github action to use kebab case #5392 @alanmcruickshank

New Contributors

• @jongracecox made their first contribution in #5412
• @markbaas made their first contribution in #5431
• @rocwang made their first contribution in #5438
• @gvozdvmozgu made their first contribution in #5437