·
10 commits
to refs/heads/main
since this release
Highlights
This minor release has two breaking changes:
- The addition of camelCase in the extended capitalisation policy. This change removes the ability to
autodetect PascalCase, from now on PascalCase, and camelCase must be explicitly set in the config if desired. - The detection method for sqlfluff config has changed. It should now be more consistent, regardless of how deep if the directory
structure you run the command from.
This release also brings in support for the MariaDB dialect. As well as this, there are many bugfixes,
and dialect improvements.
Thanks also to the twelve new contributors whose work was included
in this release! 🎉🎉🏆🎉🎉
What’s Changed
- Snowflake: alter procedure & function updates #5997 @hawle
- Snowflake: fix connect by prior selects #5996 @hawle
- Snowflake: adds EVENT TABLE support #5995 @hawle
- Feature/MariaDB dialect #5856 @Xemptuous
- Postgres: Fix multiline concat for special literals #5965 @keraion
- ST05: Evaluate nested queries as a whole #5990 @keraion
- Naïve multi-variant jinja linting #5822 @alanmcruickshank
- Update Snowflake Unpivot Dialect to INCLUDE/EXCLUDE NULLs #5961 @danatmercury
- Snowflake: Adds parsing fixes for external access integrations in create procedure and function #5986 @hawle
- Select Analysis: Don't recursively crawl merge subselects #5981 @keraion
- Parent dir config search #5958 @j-svensmark
- Enable AM02 for bigquery, clickhouse, databricks, db2 #5979 @WittierDinosaur
- Add COMMENT ON support to Trino dialect #5984 @tunetheweb
- Snowflake: fix scriptless stored procedure parsing #5982 @hawle
- Add support for custom JinjaTracer implementations #5937 @james-johnston-thumbtack
- MySQL: Fix variable handlings inside expressions #5967 @kzosabe
- Allow anonymous PIVOTs in Databricks #5968 @TheCleric
- Rebreak: Fix meta dedent segment order #5972 @keraion
- Update athena dialect for CTAS #5974 @KulykDmytro
- fix(dialect-trino): Support Grouping Sets #5970 @eskabetxe
- BigQuery: Support various DROP statements #5966 @kzosabe
- AL07: Fix self-referencing table aliases #5963 @keraion
- Clickhouse 'create view' support #5910 @DimaSamodurov
- Capitalisation: Add camelCase #5777 @WittierDinosaur
- Exasol: Use ANSI value_clause to handle insert_stmts correctly #5959 @stephnan
- Support quoted psql parameters with
placeholdertemplater #5880 @fvankrieken - Don't indent invisible template slices #5938 @james-johnston-thumbtack
- 8634: Add support for databricks named parameters #8636 @TheCleric
- Add support for Databricks TRACK HISTORY #8638 @TheCleric
- BigQuery: Support various ALTER statements #8633 @kzosabe
- ClickHouse query-level SETTINGS support #8631 @pheepa
- MySQL: Add support for generated columns #5939 @pprkut
- Exasol: add REGEXP_LIKE #5936 @stephnan
- SQLite: Over clause support for window functions #5935 @atishay
- T-SQL: Parameter assignment in SELECT vs alias #5934 @drjwelch
- SQLite: Add named parameters support #5914 @atishay
- SQLite: Support with key as a column name (as needed by json_each) #5918 @atishay
- Add loader_search_path setting to Jinja templater #5930 @james-johnston-thumbtack
- SQLite: Add support for JSON functions. Fixes #5896 #5917 @atishay
- dbt Templater: Suppress dbt 1.8 log messages #5907 @keraion
- Clarify docs around subdir handling when loading macros #5924 @james-johnston-thumbtack
- fix: add missing comma in Snowflake file types list #5923 @gvozdvmozgu
- SQLite: Specialize create view with support for temporary views. #5919 @atishay
- BigQuery: Fix array type parsing #5912 @kzosabe
- BigQuery: Support unimplemented alter table and view statements #5911 @kzosabe
New Contributors
- @atishay made their first contribution in #5919
- @drjwelch made their first contribution in #5934
- @stephnan made their first contribution in #5936
- @pprkut made their first contribution in #5939
- @pheepa made their first contribution in #8631
- @TheCleric made their first contribution in #8638
- @fvankrieken made their first contribution in #5880
- @DimaSamodurov made their first contribution in #5910
- @eskabetxe made their first contribution in #5970
- @hawle made their first contribution in #5982
- @danatmercury made their first contribution in #5961
- @Xemptuous made their first contribution in #5856