·
3 commits
to refs/heads/main
since this release
Highlights
- This is primarily a bugfix, rule enhancement, and dialect enhancement release.
- We also have done some light refactoring of the internal codebase.
This release has 80 contributions in it!
Also, welcome to the fourteen new contributors! Thanks for your contributions!
What’s Changed
- Adds support for
RETURNING INTOclause inINSERT,UPDATE,DELETEandMERGEstatements in Oracle. (#6941) @joaostorrer - converted large_file_skip_byte_limit value to integer before comparison, fixes Issue #6847 (#6848) @M-van-alten-BW
- Feat: Support explode in sparksql lateral clauses (#6875) @ShaneMazur
- Trino: Support for INSERT, COMMIT, ROLLBACK and SET SESSION statements (#6928) @ykicisk
- feat(redshift): add support for ALTER TABLE SET LOCATION syntax (#6936) @studansp
- TSQL: fix
USER(bare function) unparsable (#6935) @keen85 - TSQL: add support for
SECURITY POLICY(CREATE, ALTER, DROP) (#6937) @keen85 - CI: update coverage paths for C:\ directory (#6938) @keraion
- Adds support for column list after table name in COLLECT STATISTICS (#6896) @thomascjohnson
- Adds support for trigger predicates in
IFstatements and:NEW.variables in assignment statements in Oracle. (#6930) @joaostorrer - Adds support for
<=>operator in MySQL. (#6929) @joaostorrer - CLI: Read inline configurations when using
--stdin-filename(#6900) @keraion - Refactor Bracketed (#6827) @WittierDinosaur
- cli: Enable
--disregard-sqlfluffignoresforfixandformat(#6885) @keraion - Improves support for
SETstatements in MySQL. (#6922) @joaostorrer - RF01: Fix quoted object references with dots (#6923) @keraion
- LT14: Add exclusion configuration option (#6909) @keraion
- Duckdb: Support double equals comparison (#6924) @keraion
- Fix mypy 1.16 issues (#6920) @keraion
- Databricks: Prevent parsing error when reading from a streaming file (#6910) @cpwithers
- dbup style variables into placeholder templater (#6852) @dreik
- Postgres: Add support for session authorization (#6903) @pierrand
- Redshift: Fix documentation link (#6901) @joaonunesk
- ST05: Ignore table_expressions that aren't bracketed (#6883) @keraion
- Pin to Click < 8.3.0 (#6892) @wyardley
- Fix RawFileSlice idx and tags in lexer_test (#6890) @keraion
- CV12: fix assertion on bracketed join (#6898) @keraion
- Redshift: Add support for Kafka external schema (#6899) @pierrand
- Adds support for variadic declarations in Postgres. (#6887) @joaostorrer
- Adds support for Teradata CREATE TABLE with MAP option (#6895) @thomascjohnson
- MySQL: Add collate expressions (#6886) @keraion
- Add support for PRIVATE MATERIALIZED VIEW syntax to databricks dialect (#6882) @TheCleric
- CI: Ignore mypy call-arg for CliRunner mix_stderr (#6884) @keraion
- Postgres / Redshift: Add support for prepared statement (#6874) @pierrand
- Add support for Snowflake
LOAD_UNCERTAIN_FILES(#6879) @mxr - Update the Dockerfile to use Python 3.12 (#6876) @keraion
- TSQL: Support named windows (#6869) @WittierDinosaur
- Postgres: Support Security Label (#6868) @WittierDinosaur
- Bigquery: Support Pipe statements (#6870) @WittierDinosaur
- LT01: Brackets should touch datatypes (#6867) @keraion
- chore: Clean up OptionallyDelimited workarounds in Snowflake (#6866) @WittierDinosaur
- Add pgvector operators (#6863) @reteps
- Add support for OFFSET to ANSI and POSTGRES dialect (#6862) @reteps
- Terminate SELECT with ON CONFLICT (#6864) @reteps
- feat(snowflake): add support for 'DROP ICEBERG TABLE' statement (#6860) @VishalSinha1103
- SQLite: allow trailing unsigned (#6856) @covracer
- Fixes Oracle parsing tree with
/operator. (#6853) @joaostorrer - OptionallyDelimited Grammar (#6837) @WittierDinosaur
- TSQL: Add support for JSON_ARRAY and JSON_OBJECT (#6845) @nathanthorell
- Optimise CI test performance (#6829) @WittierDinosaur
- Snowflake: add EXTERNAL VOLUME and EXECUTE MANAGED TASK parameters to GRANT clause (#6839) @moreaupascal56
- Adds support for
REMOVE DUPLICATESclause in merge statements in Redshift (#6841) @joaostorrer - Redshift: Add support for
select excludesyntax (#6838) @pierrand - Snowflake: Create Network Policy Network Rule List (#6835) @WittierDinosaur
- Snowflake: Full support of resource monitors (#6834) @WittierDinosaur
- Remove AliasedObjectReferenceSegment (#6833) @WittierDinosaur
- Postgres: Fix RETURNING Select terminator (#6832) @WittierDinosaur
- Trino: Better support for CreateTable (#6831) @WittierDinosaur
- Snowflake: Support use_privatelink_endpoint (#6830) @WittierDinosaur
- CV12 rule to exclude APPLY clause from the rule (#6828) @paysni
- Set up Docker development environment (#6826) @WittierDinosaur
- Feat: Snowflake, Add catalog integration & create iceberg table (#6793) @moreaupascal56
- Snowflake: Add create API INTEGRATION support (#6815) @moreaupascal56
Contributors
dreik, mxr, and 20 other contributors