Highlights
This is primarily a release for dialect fixes and improvements with additions and changes to TSQL, Snowflake, MySQL & Redshift. The other changes of note are:
- Support for warnings when users set old removed config values. This supports future change work by allowing a mechanism to warn if they are used.
- Improvements to the fix routines for L014 and L042 to handle some trickier cases.
What’s Changed
- Add CreateUserSegment for Snowflake dialect (#3880) @Gal40n04ek
- raw_segments_with_ancestors (#3878) @alanmcruickshank
- Adjust TSQL Operators (#3877) @alanmcruickshank
- Refactor path_to (#3875) @alanmcruickshank
- Support Removed warning on configs (#3874) @alanmcruickshank
- MySQL: Support column-path operator for JSON type (#3864) @yoichi
- T-SQL: ALTER FUNCTION/PROCEDURE/VIEW parsing (#3867) @differgroup
- MySQL: Support hexadecimal literals and bit value literals (#3869) @yoichi
- MySQL: Treat double quotes the same as single quotes (#3871) @yoichi
- Snowflake: COMMIT WORK (#3862) @rglbr
- Snowflake: AlterShareStatementSegment and CreateDatabaseFromShareStatementSegment (#3858) @moreaupascal56
- MySQL: Add CREATE/ALTER VIEW (#3859) @wfelipew
- Redshift: CREATE TABLE LIKE enhancements (#3853) @greg-finley
- L014 leading underscore capitalization inference fix (#3841) @j-svensmark
- MySQL: Add extended DROP TRIGGER functionality (#3846) @yoichi
- Allow standalone aliases in L027 (#3848) @olagjo
- L042: Enable autofix for some tricky cases (#3700) @barrywhart
- Snowflake: CREATE FUNCTION IF NOT EXISTS (#3845) @greg-finley
- ignore functions with more than one element ... (#3792) @fmms
- MySQL: support remaining constraint parts of CREATE/ALTER TABLE (#3827) @yoichi
New Contributors
- @olagjo made their first contribution in #3848
- @j-svensmark made their first contribution in #3841
- @wfelipew made their first contribution in #3859
- @moreaupascal56 made their first contribution in #3858
- @rglbr made their first contribution in #3862
- @differgroup made their first contribution in #3867