Highlights
Much of this release is internal optimisations and refactoring. We're in the process of upgrading some quite old code in the parser, most of which should not be visible to end users (apart from perhaps some performance improvements!).
This release also allows missing template variables in the placeholder templater to be automatically filled with the name of the variable rather than raising an error (see: #5101).
Beyond that this includes some dialect improvements for DuckDB, SparkSQL, Snowflake, Redshift & Postgres.
Thanks particularly to @shyaginuma, @Fullcure3, @adilkhanekt & @pilou-komoot who made their first contributions as part of this release. 🎉🎉🎉
What’s Changed
- Allow not specifying parameters names when using placeholder templater #5101 @shyaginuma
- Update coverage job to run in the right conditions #5183 @alanmcruickshank
- Duckdb: UNION BY NAME #5176 @greg-finley
- Output coverage report direct to PR #5180 @alanmcruickshank
- Upgrades to the parse fixture generation script #5182 @alanmcruickshank
- Refactor of Sequence match #5177 @alanmcruickshank
- Simplify Greedy Match #5178 @alanmcruickshank
- Quality of life improvements on parse fixture script #5179 @alanmcruickshank
- Lift and shift matching algorithms #5170 @alanmcruickshank
- Capitalise boolean values in example configs, for consistency #5175 @pilou-komoot
- Pull terminator setting up into the base grammar #5172 @alanmcruickshank
- Flip the if in sequence and un-nest #5171 @alanmcruickshank
- SparkSQL: Support CACHE TABLE without query #5165 @reata
- Remove configurable
enforce_whitespace_preceding_terminator#5162 @alanmcruickshank - Adding optional sequence block for columns parsing in Snowflake external tables #5157 @adilkhanekt
- SparkSQL: Support ALTER TABLE SET LOCATION without partition spec #5168 @reata
- Tighten terminators on
Delimited#5161 @alanmcruickshank terminator>terminatorson StartsWith #5152 @alanmcruickshank- Redshift: Support SELECT INTO #5159 @reata
- Duckdb: Integer division #5154 @greg-finley
terminator>terminatorson Delimited grammar #5150 @alanmcruickshank- Tests for unparsable sections #5149 @alanmcruickshank
- Un-nest the delimited match method #5147 @alanmcruickshank
- Grammar .copy() assert no unexpected kwargs #5148 @alanmcruickshank
- Postgres: CLUSTER #5146 @greg-finley
- Postgres alter policy #5138 @Fullcure3
New Contributors
- @Fullcure3 made their first contribution in #5138
- @adilkhanekt made their first contribution in #5157
- @pilou-komoot made their first contribution in #5175
- @shyaginuma made their first contribution in #5101