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