Highlights
- This release adds support for two new dialects: Apache Doris and FlinkSQL.
- It also has several CLI improvements, Dialect Improvements, and bugfixes
This release has 25 contributions in it!
Also, welcome to the five new contributors! Thanks for your contributions!
What’s Changed
- Postgres: Fix VARIADIC function call parsing (#7002) @franloza
- Postgres: Add IS JSON syntax support (#7001) @franloza
- feat(databricks): add support for single-line magics (#6999) @phant0mw0lf
- Trino: support ALTER TABLE (#6996) @ykicisk
- Snowflake: Support UNION (ALL) BY NAME (#6994) @WittierDinosaur
- [#6522] FlinkSQL Dialect Implementation (#6985) @kalanyuz
- Tsql align alias when using equal operator (#6786) @IngerMathilde
- TSQL: Rework the execute statement block to latest specs (#6953) @peterbud
- Add Apache Doris SQL dialect support to SQLFluff (#6979) @morningman
- ST05: Support dialects that use WITH, INSERT, SELECT order (#6982) @keraion
- CV12 and AL05: Prevent AL05 from deleting rewritten CV12 references (#6981) @keraion
- DuckDB: add support for additional star expressions (#6977) @keraion
- CLI: Add support for the
NO_COLORenvironment variable (#6976) @keraion - SQLite: Make
ACTIONa non-reserved keyword (#6970) @keraion - Snowflake: fix collate grammar with aliases (#6967) @keraion
- Adds support for
json_objectsyntax in Oracle. (#6973) @joaostorrer - Upgrade OverlapsClauseSegment (#6964) @kkozhakin
- ANSI: Support CTEs in Merge (#6972) @NormallyGaussian
- Fix ST09 rule not detecting violations in Jinja templated SQL (#6958) @kang8
- MariaDB: Allow CTEs in
INSERTstatements (#6955) @keraion - AliasInfo: handle quotes and special aliases in rules (#6954) @keraion
- API: prioritize configuration file's dialect (#6951) @keraion
- Tsql add alter constraint if exists (#6957) @IngerMathilde
- TSQL: add support for extended Unicode characters in identifiers (#6952) @peterbud
- TSQL: Add support for CREATE TABLE GRAPH statements (#6948) @peterbud