[2.0.0a5] - 2023-02-24
NOTE: This is an alpha release for testing purposes. There are several new features
here, and breaking changes to configuration. We welcome testing feedback from the
community, but know that this release may feel less polished than usual.
Highlights
This is the fifth alpha release for 2.0.0. It contains:
- Significant rework to rule naming and categorisation.
- Several performance improvements.
- Many dialect improvements to several dialects.
- Bugfixes to many of the issues raised in 2.0.0a4.
There will likely be more changes to rule classification before a full release of 2.0.0, so anticipate that configuration files may change slightly again in future alpha releases.
What’s Changed
- Handle long lines without trailing newlines gracefully (#4386) #4423 @alanmcruickshank
- Resolve #4184 (index error in L007) #4422 @alanmcruickshank
- Handle untaken positive indents with taken negative pair. #4420 @alanmcruickshank
- Postgres: AS MATERIALIZED support #4417 @saintamh
- Align warnings config with example shown #4421 @briankravec
- BigQuery: parse "AS description" part of assert expressions #4418 @yoichi
- Deprecate doc decorators (replace with metaclass) #4415 @alanmcruickshank
- Enable noqa using aliases and groups #4414 @alanmcruickshank
- Add rule names to CLI outputs #4400 @alanmcruickshank
- Postgres: Remove execution keyword inherited from ANSI #4411 @WittierDinosaur
- Rule names, aliases and more complicated selection. #4399 @alanmcruickshank
- Postgres: Support Recursive View #4412 @WittierDinosaur
- T-SQL: Implement BULK INSERT statement #4381 @borchero
- L062: Add match_source (#4172) #4335 @vesatoivonen
- TSQL: Add SET to ALTER TABLE #4407 @jared-rimmer
- Snowflake: ALTER STORAGE INTEGRATION segment #4406 @jared-rimmer
- Fix incorrect link to pre-commit docs #4405 @pdebelak
- Add Snowflake dialect ALTER ROLE segment #4403 @jared-rimmer
- Improving Postgres create index statement #4356 @jmpfar
- Resolve #4291: Comments forcing unexpected indents. #4384 @alanmcruickshank
- Resolve #4294: Comments affecting indentation #4337 @alanmcruickshank
- Resolve #4292: Window function long line fixes #4383 @alanmcruickshank
- TSQL: ALTER INDEX #4364 @AidanHarveyNelson
- Added Varying Keyword to allowed data type segments #4375 @AidanHarveyNelson
- Add ruff linter #4372 @greg-finley
- Fix postgres column constraint default syntax #4379 @pdebelak
- Allow function names to have a leading underscore #4377 @gavin-tsang
- TSQL: Merge Hints #4354 @AidanHarveyNelson
- TSQL: Temporal Table #4358 @AidanHarveyNelson
- TSQL: ALTER TABLE #4369 @AidanHarveyNelson
- Bugfix: Duckdb SELECT * #4365 @WittierDinosaur
- Postgres: TABLESAMPLE query #4357 @greg-finley
- reindent refactor #4338 @alanmcruickshank
- Snowflake: INSERT INTO #4363 @AidanHarveyNelson
- Docs: correct toml syntax of pyproject.toml file config example #4361 @imrehg
- Allowed Naked Identifiers #4359 @AidanHarveyNelson
- TSQL: TABLESAMPLE #4353 @AidanHarveyNelson
- Tsql: Function Parameters #4352 @AidanHarveyNelson
- Postgres: Storage parameters #4350 @AidanHarveyNelson
- TSQL: Bare Function Set #4351 @AidanHarveyNelson
- Postgres: View options #4340 @AidanHarveyNelson
- BigQuery: SELECT DISTINCT AS STRUCT #4341 @joar
- Snowflake: Fix Alter Warehouse #4344 @AidanHarveyNelson
- Parser: Optimise lookahead_match #4327 @WittierDinosaur
- Add support for dbt test macros #4319 @pdebelak
- Bracket complex expressions before applying :: operator in Rule L067 #4326 @pdebelak
New Contributors
- @AidanHarveyNelson made their first contribution in #4344
- @joar made their first contribution in #4341
- @jmpfar made their first contribution in #4356
- @jared-rimmer made their first contribution in #4403
- @vesatoivonen made their first contribution in #4335
- @briankravec made their first contribution in #4421
- @saintamh made their first contribution in #4417