Release SQLFluff 1.2.0 · sqlfluff/sqlfluff

Highlights

Major changes include:

Adding AWS Athena as a dialect.
A fix routine for L046 (whitespace in jinja tags), and the mechanisms for
more source-only fixes in future.
By default, large files (over 20k characters) are now skipped by sqlfluff. This
limit is configurable and disable-able but exists as a sensible default to avoid
the performance overhead of linting very large files.
For the dbt templater, fatal compilation errors now lo longer stop linting, and
these files are now skipped instead. This enables projects to continue linting
beyond the offending file and much better logging information to enable better
debugging.

Add a skip and better logging for fatal dbt issues #3603 @alanmcruickshank
Add large file check #3600 @alanmcruickshank
Oracle: extend support for ALTER TABLE #3596 @davidfuhr
Immutability fixes #3428 @alanmcruickshank
Struct type should be a segment #3591 @alanmcruickshank
Fix Bracketed Struct issue #3590 @alanmcruickshank
Allow spaces and multiple signs for numeric literals #3581 @tunetheweb
Add source fixing capability and fix routines for L046 #3578 @alanmcruickshank
Small grammar cleanup in team rollout docs #3584 @theianrobertson
Postgres: CREATE COLLATION support #3571 @greg-finley
Redshift: Add TOP X to select clause modifiers #3582 @pdebelak
Postgres: Small fixes to COMMENT ON #3566 @greg-finley
Support MySQL system variables #3576 @qgallet
Allow no alias for selects in CTEs with a column list #3580 @pdebelak
New dialect AWS Athena #3551 @cmotta
Split apart fix_string(). #3568 @alanmcruickshank
Fix incorrect L022 with postgres dialect with CTE argument list #3570 @pdebelak
Simplify lint fixing (prep for source fixes) #3567 @alanmcruickshank
Exclude .coverage.py from linting #3564 @zidder
L016: ignore_comment_clauses not working for postgres dialect #3549 @barrywhart
Groundwork for a fix routine for L046 #3552 @alanmcruickshank
Add better handling for SQLFluffUserError when running core cli commands #3431 @alanmcruickshank