Highlights
This release primarily brings through a large set of dialect improvements and bugfixes from over the holiday period. Notably also:
- A change in the default behaviour for
convention.not_equals. The new default is to beconsistent, which is slightly more relaxed than the original behaviour. - A new rule (
aliasing.self_alias.column) which prevents aliasing a column as itself. - Disables
AL01(aliasing.table) by default for Oracle.
This release also saw ELEVEN new contributors in this release 🎉🎉🏆🏆🎉🎉. Great to see so many new people getting involved with the project. Thank You 🙏.
What’s Changed
- Add support & test for postgres alter policy with multiple clauses #5577 @fnimick
- Update github actions to latest versions #5584 @alanmcruickshank
- Allows using dbt cross project ref in jinja templater #5574 @alangner
- Improve support for Jinja templater plugins with custom tags #5543 @james-johnston-thumbtack
- Databricks: fix
EXCEPTwith qualified column reference #5557 @keraion - Stricter recommended config for not_equals convention #5580 @alanmcruickshank
- CV01: Add options for ANSI and consistent style. #5539 @keraion
- DuckDB: Fix
REPLACEafterEXCLUDE. Fix AL03 linting for wildcard like expression. #5556 @keraion - Clickhouse: Add
GLOBAL JOIN,GLOBAL IN, andPASTE JOIN#5560 @keraion - [Docs] Use extended policy for identifier capitalisation in starter config #5562 @j-svensmark
- Build: linting black 24.1.0 rules update #5573 @keraion
- Snowflake: Updating Snowflake dialect to pass acceptable RLS policy objects #5559 @k1drobot
- Redshift Syntax: ALTER APPEND #5545 @OTooleMichael
- DuckDB: Add ANTI, SEMI, ASOF, and POSITIONAL joins #5544 @keraion
- MySQL: fix FIRST keyword in ALTER ADD/MODIFY #5537 @archer62
- Postgres/DB2/Oracle: Fix comma join
LATERAL. #5533 @keraion - Add new Rule AL09: Avoid Self Alias #5528 @aayushr7
- Rule AL01: disabled for Oracle dialect #5517 @keraion
- Postgres ALTER EXTENSION support: dialect & tests #5527 @remy-gohiring
- SparkSQL: Add
UNPIVOTsyntax. FixTABLESAMPLEaliases. #5524 @keraion - DuckDB: Added support for
PIVOTandUNPIVOT#5514 @keraion - Fix parse error databricks window function starts with order by #5493 @snkekorfus
- Hive: allow UDTF to return multiple column aliases in SELECT #5495 @reata
- DB2: Add support for
DECLARE GLOBAL TEMPORARY TABLES,OFFSET,CALL, and non-bracketedVALUES#5508 @keraion - DuckDB: Add CREATE OR REPLACE TABLE syntax #5511 @keraion
- TSQL: Top and Distinct in same query #5491 @greg-finley
- [Spark/Databricks] Fix: make COLUMNS in APPLY CHANGES INTO optional #5498 @rocwang
- SparkSQL: exclamation mark as logical not #5500 @reata
- SparkSQL: allow value in set_statement to be Java class name #5504 @reata
- SparkSQL: allow distribute/sort/cluster by at end of set operation #5502 @reata
- [CI] Add a few more mypy ckecks #5505 @Koyaani
- Snowflake dialect: Add support for DATABASE ROLE in GRANT/REVOKE #5490 @sfc-gh-dgupta
- DuckDB: Qualify and From-First #5485 @keraion
- MySql: create table: allow null/not null in any position #5473 @archer62
- Snowflake dialect: Support for CREATE DATABASE ROLE #5475 @sfc-gh-dgupta
- Clickhouse Dialect - Support BackQuoted Identifiers #5457 @kaiyannameighu
- Change Color.lightgrey to have a white background - dark theme friendly #5458 @ryaminal
- Fix indentation for single cube clause #5462 @tunetheweb
New Contributors
- @ryaminal made their first contribution in #5458
- @sfc-gh-dgupta made their first contribution in #5475
- @archer62 made their first contribution in #5473
- @keraion made their first contribution in #5485
- @Koyaani made their first contribution in #5505
- @snkekorfus made their first contribution in #5493
- @remy-gohiring made their first contribution in #5527
- @aayushr7 made their first contribution in #5528
- @k1drobot made their first contribution in #5559
- @alangner made their first contribution in #5574
- @fnimick made their first contribution in #5577