·
33 commits
to refs/heads/main
since this release
Highlights
This release brings a couple of breaking changes:
- We have dropped support for Python 3.8
- We have a new rule:
LT15(layout.newlines). This rule allows you to control the number of consecutive
blank lines both inside, and outside of queries.
We also have a host of dialect improvements, bugfixes, and general code clean-up. This release has 79 contributions in it!
Also, welcome to the thirteen new contributors! Thanks for your contributions!
What’s Changed
- Clickhouse: support more complex types and functions in table definition (#6804) @LSturtew
- feat: Add possibility to set dbt project_dir as environment variable (#6737) @svdimchenko
- Add support for
ZEROFILLcolumns in MySQL. (#6735) @joaostorrer - RF02: Add config for ignoring external references found in subqueries (#6791) @keraion
- Fix
CREATE TABLEstatements in Redshift. (#6808) @joaostorrer - Improve support for
CREATE USERstatements in Oracle. (#6809) @joaostorrer - Add support for the WITH clause for an OPENROWSET in T-SQL (#6810) @rayz90
- Add hybrid tables to Snowflake dialect (#6812) @moreaupascal56
- Trino Dialect - Parse UNNEST (...) WITH ORDINALITY (#6813) @rileymcdowell
- Adds support for
varchar(max)in Redshift. (#6806) @joaostorrer - BigQuery: Make select replace
ASnot optional (#6780) @keraion - CI: Update add-to-release-notes to use ubuntu-latest (#6798) @keraion
- CI: mirror image deployment to ghcr.io (#6790) @keraion
- add ERROR_INTEGRATION to AlterPipeSegment (#6796) @moreaupascal56
- Housekeeping: snowflake use CommentEqualsClauseSegment everywhere (#6795) @moreaupascal56
- Allow quoted charset identifiers for MySQL/MariaDB (#6781) @pprkut
- Fix reserved keywords in Postgres. (#6782) @joaostorrer
- Adds support for user defined datatypes in Redshift. (#6783) @joaostorrer
- improve alter table statement handling for clickhouse dialect (#6787) @LSturtew
- Athena: Support some Trino-based v3 functions (#6788) @keraion
- SparkSQL/Databricks: Support dot sign operator (#6789) @keraion
- RF02: do not trigger on snowflake lambda anonymous parameters (#6689) @shervinmathieu
- Adding additional object to grant statement in snowflake dialect (#6779) @SteveFrensch
- Adds support for
+=,-=,*=,/=and%=operators in tsql. (#6756) @joaostorrer - ST11: Fix quoted table name comparisons (#6768) @keraion
- Formatter Stub Types (#6761) @alanmcruickshank
- CP02, LT01: Fix duplicated elements generated from a
FixPatchordering conflict (#6769) @keraion - Added support for geospatial data for MySQL (#6765) @AidanHarveyNelson
- Adds support for identity clause in
CREATE TABLEandALTER TABLEstatements in Oracle. (#6767) @joaostorrer - Fix
PivotSegmentto accept alias inFunctionSegmentin Oracle. (#6766) @joaostorrer - New Rule: LT15 (#6641) @WittierDinosaur
- Additional cleanup for python 3.9 (#6758) @keraion
- feat(snowflake): allow reference variables in create task (#6759) @mrlannigan
- Always use utf-8 encoding for toml files (#6760) @keraion
- Fix rule failures for MySQL/MariaDB with backticked identifiers (#6702) @pprkut
ON CONFLICTindentation for Postgres (#6660) @WillMatthews- Update release instructions (#6751) @alanmcruickshank
- Add support for Oracle PL/SQL (Procedures, Functions, Packages, Triggers, Types, Cursors, Loops) (#6635) @joaostorrer
- Tighter typing of Rule configs (#6750) @alanmcruickshank
- Fix: column aliases should find the topmost alias (#6755) @keraion
- AM08: Handle any-cased
UNNEST(#6757) @keraion - Python 3.9+ Type simplifications (#6745) @alanmcruickshank
- Snowflake dynamic table fixes (#6748) @ulixius9
- Update TSQL Execute Statement for Expressions (#6744) @nathanthorell
- Duckdb: Adding InsertStatementSegment for Duckdb specifics (#6740) @nathanthorell
- Drop support for Python 3.8 (#6743) @WittierDinosaur
- Fix tox config so that it supports spaces in the path name (#6726) (#6727) @maxgrenderjones
- BigQuery: support UNION ALL BY NAME and other new set operator modifiers (#6722) @Robin-C
- Fill in gap in parsing
create user rsa_public_key=.../ snowflake (#6731) @juli4nb4dillo - Adds support for partition options in
ALTER TABLEstatements in MySQL. (#6742) @joaostorrer - Update oracle reserved keywords. (#6730) @joaostorrer
- Add support in TSQL for Open Symmetric Key (#6736) @nathanthorell
- Cleaning: Remove Todo set tag from Snowflake ALTER TABLE statement (#6738) @moreaupascal56
- SparkSQL: Make colon optional in
STRUCTdatatype (#6739) @NormallyGaussian - Redshift: Support GROUP BY ALL (#6714) @WittierDinosaur
- Fix tests with Click 8.2 (#6706) @cjwatson
- Remove
USERfrom reserved words in Postgres. (#6707) @joaostorrer - Add support for
key: valuesyntax in functions in Postgres. (#6708) @joaostorrer - Fill in Gap in Snowflake
DROP DYNAMIC TABLE(#6673) @LoganPrice344 - Fill in Gap in Snowflake
ALTER TABLEParsing (#6654) @LoganPrice344 - Fill in Gap in Snowflake
CREATE AUTHENTICATION POLICYParsing (#6685) @LoganPrice344 - Adds support for
JoinClauseSegmentinDeleteStatementSegmentin Postgres (#6692) @joaostorrer - Fix check constraints in
ALTER TABLEstatements in Oracle. (#6661) @joaostorrer - Add support for Obevo annotations. (#6662) @joaostorrer
- Add support for
DEFAULTkeyword as function parameter in tsql. (#6663) @joaostorrer - Fill in gap in
DECLARESyntax (#6665) @LoganPrice344 - AL03: Lint for missing aliases on subqueries (#6666) @keraion
- IN TABLE/CTE and implicit Array, Tuple support for ClickHouse (#6667) @pheepa
- ST11: Fix rule name in documentation for
noqa(#6668) @keraion - Fill in Gap in Snowflake
ALTER TABLEParsing (#6671) @LoganPrice344 - Allows Snowflake
CREATE ROW ACCESS POLICYto Parse Quoted Policy Names (#6648) @LoganPrice344 - Add support for
EVENTstatements in MySQL. (#6646) @joaostorrer - Fill in Gap in Snowflake
ExceptionParsing (#6645) @LoganPrice344 - Snowflake: Add TITLE parameter support in CREATE STREAMLIT statement (#6642) @kawashiro
- TSQL: Add support for OPENQUERY (#6640) @nathanthorell
- Snowflake: Add support for CORTEX SEARCH SERVICE (#6639) @sfc-gh-amauser
- Add support for
WithCompoundStatementSegmentin procedures in Postgres (#6632) @joaostorrer - Add support for
SET NEW.<column>statements in MySQL. (#6634) @joaostorrer - feat: Add missing parquet file format keywords to SF dialect (#6638) @jjlkant
Contributors
pprkut, rayz90, and 25 other contributors