Sqlfluff

Latest version: v3.0.7

Safety actively analyzes 638388 Python packages for vulnerabilities to keep your Python projects secure.

Scan your dependencies

Page 16 of 24

0.7.0

Not secure
**BREAKING CHANGE**

This release extracts the dbt templater to a separately installable plugin
[sqlfluff-templater-dbt](https://pypi.org/project/sqlfluff-templater-dbt/).
For users who take advantage of the dbt templater see the
[updated docs on how to migrate](https://docs.sqlfluff.com/en/latest/configuration.html#installation-configuration).
It also adds the `redshift` dialect and removes the `exasol_fs` dialect which has been merged
into the `exasol` dialect.

What’s Changed
* src/sqlfluff/core/linter: Improve ignore file processing [1650](https://github.com/sqlfluff/sqlfluff/pull/1650) [CyberShadow](https://github.com/CyberShadow)
* Misc documentation updates [1644](https://github.com/sqlfluff/sqlfluff/pull/1644) [tunetheweb](https://github.com/tunetheweb)
* Segregate dbt plugin tests [1610](https://github.com/sqlfluff/sqlfluff/pull/1610) [alanmcruickshank](https://github.com/alanmcruickshank)
* Add initial Redshift support [1641](https://github.com/sqlfluff/sqlfluff/pull/1641) [tunetheweb](https://github.com/tunetheweb)
* Update docs for dbt templater, improve error messages when not installed. [1583](https://github.com/sqlfluff/sqlfluff/pull/1583) [alanmcruickshank](https://github.com/alanmcruickshank)
* Make templaters pluggable and move the dbt templater into a plugin [1264](https://github.com/sqlfluff/sqlfluff/pull/1264) [alanmcruickshank](https://github.com/alanmcruickshank)

🚀 Enhancements

* T-SQL: CTAS delimiter [1652](https://github.com/sqlfluff/sqlfluff/pull/1652) [jpers36](https://github.com/jpers36)
* T-SQL: Allow for multiple variables DECLAREd in the same statement [1651](https://github.com/sqlfluff/sqlfluff/pull/1651) [jpers36](https://github.com/jpers36)
* T-SQL: Allow DECLARE/SET statements to parse using ExpressionStatement [1649](https://github.com/sqlfluff/sqlfluff/pull/1649) [jpers36](https://github.com/jpers36)
* T-SQL PRINT statement parsing [1648](https://github.com/sqlfluff/sqlfluff/pull/1648) [jpers36](https://github.com/jpers36)
* Better date function for tsql [1636](https://github.com/sqlfluff/sqlfluff/pull/1636) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Allow for multiple statements in a procedure [1637](https://github.com/sqlfluff/sqlfluff/pull/1637) [jpers36](https://github.com/jpers36)
* T-SQL: Allow for !>, !< operators [1640](https://github.com/sqlfluff/sqlfluff/pull/1640) [jpers36](https://github.com/jpers36)
* T-SQL: Fix GROUP BY delimiter [1635](https://github.com/sqlfluff/sqlfluff/pull/1635) [jpers36](https://github.com/jpers36)
* T-SQL: Fix DROP delimiter [1633](https://github.com/sqlfluff/sqlfluff/pull/1633) [jpers36](https://github.com/jpers36)
* T-SQL: +RENAME statement for Azure Synapse Analytics [1631](https://github.com/sqlfluff/sqlfluff/pull/1631) [jpers36](https://github.com/jpers36)
* T-SQL: Fix CASTing variables [1627](https://github.com/sqlfluff/sqlfluff/pull/1627) [jpers36](https://github.com/jpers36)
* Snowflake: Add implementation for CREATE TASK statement [1597](https://github.com/sqlfluff/sqlfluff/pull/1597) [#1603](https://github.com/sqlfluff/sqlfluff/pull/1603) [JoeHut](https://github.com/JoeHut)
* Allow global config for rule testcases [1580](https://github.com/sqlfluff/sqlfluff/pull/1580) [sti0](https://github.com/sti0)
* Snowflake dollar sign literals [1591](https://github.com/sqlfluff/sqlfluff/pull/1591) [myschkyna](https://github.com/myschkyna)
* Rename test/fixtures/parser directory to test/fixtures/dialects [1585](https://github.com/sqlfluff/sqlfluff/pull/1585) [tunetheweb](https://github.com/tunetheweb)
* Rename keyword files [1584](https://github.com/sqlfluff/sqlfluff/pull/1584) [tunetheweb](https://github.com/tunetheweb)
* Add some more unreserved keywords to BigQuery [1588](https://github.com/sqlfluff/sqlfluff/pull/1588) [tunetheweb](https://github.com/tunetheweb)
* Increase minimum runs before coverage report is issued [1596](https://github.com/sqlfluff/sqlfluff/pull/1596) [tunetheweb](https://github.com/tunetheweb)
* Snowflake: Support CURRENT_TIMESTAMP as a column default value [1578](https://github.com/sqlfluff/sqlfluff/pull/1578) [wong-codaio](https://github.com/wong-codaio)
* T-SQL temp tables [1574](https://github.com/sqlfluff/sqlfluff/pull/1574) [jpers36](https://github.com/jpers36)

🐛 Bug Fixes

* Fix NoneType exception in L031 [1643](https://github.com/sqlfluff/sqlfluff/pull/1643) [tunetheweb](https://github.com/tunetheweb)
* Stop rule L048 complaining if literal is followed by a semicolon [1638](https://github.com/sqlfluff/sqlfluff/pull/1638) [tunetheweb](https://github.com/tunetheweb)
* L031 desc updated to cover both 'from' and 'join' [1625](https://github.com/sqlfluff/sqlfluff/pull/1625) [nevado](https://github.com/nevado)
* Snowflake auto increments fixes [1620](https://github.com/sqlfluff/sqlfluff/pull/1620) [myschkyna](https://github.com/myschkyna)
* Fix DECLARE Delimitation [1615](https://github.com/sqlfluff/sqlfluff/pull/1615) [jpers36](https://github.com/jpers36)
* Snowflake drop column fixes [1618](https://github.com/sqlfluff/sqlfluff/pull/1618) [myschkyna](https://github.com/myschkyna)
* T-SQL: fix statement delimitation [1612](https://github.com/sqlfluff/sqlfluff/pull/1612) [jpers36](https://github.com/jpers36)
* Snowflake: Fixed data type casting not working in `SET` statement [1604](https://github.com/sqlfluff/sqlfluff/pull/1604) [wong-codaio](https://github.com/wong-codaio)
* Postgres dialect: Fix parse error for "on delete", "on update" clauses in column constraints [1586](https://github.com/sqlfluff/sqlfluff/pull/1586) [samlader](https://github.com/samlader)
* Fix AttributeError: 'NoneType' object has no attribute 'get_child' error with rule L031 [1595](https://github.com/sqlfluff/sqlfluff/pull/1595) [barrywhart](https://github.com/barrywhart)
* Fix zero length templated file bug. [1577](https://github.com/sqlfluff/sqlfluff/pull/1577) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fully remove exasol_fs dialect and bump version [1573](https://github.com/sqlfluff/sqlfluff/pull/1573) [alanmcruickshank](https://github.com/alanmcruickshank)

0.6.9

Not secure
Another dbt bugfix from 0.6.7 and 0.6.8, plus a host of dialect and syntax improvements.

🚀 Enhancements
* Correct and expand Snowflake CREATE TABLE syntax [1567] [tunetheweb](https://github.com/tunetheweb)
* Support brackets in Postgres Meta commands [1548](https://github.com/sqlfluff/sqlfluff/pull/1548) [tunetheweb](https://github.com/tunetheweb)
* added type hints to rule files [1515](https://github.com/sqlfluff/sqlfluff/pull/1515) [ttomasz](https://github.com/ttomasz)
* Update Rule L028 to handle T-SQL PIVOT columns [1545](https://github.com/sqlfluff/sqlfluff/pull/1545) [tunetheweb](https://github.com/tunetheweb)
* T-SQL IF/ELSE [1564](https://github.com/sqlfluff/sqlfluff/pull/1564) [jpers36](https://github.com/jpers36)
* Enums for format types and colors added [1558](https://github.com/sqlfluff/sqlfluff/pull/1558) [adam-tokarski](https://github.com/adam-tokarski)
* Add dbt 0.21.0 to the test suite [1566](https://github.com/sqlfluff/sqlfluff/pull/1566) [alanmcruickshank](https://github.com/alanmcruickshank)
* Merge EXASOL_FS dialect into EXASOL dialect [1498](https://github.com/sqlfluff/sqlfluff/pull/1498) [sti0](https://github.com/sti0)
* T-SQL - BEGIN/END blocks [1553](https://github.com/sqlfluff/sqlfluff/pull/1553) [jpers36](https://github.com/jpers36)
* Small refactor with type hints and string formatting [1525](https://github.com/sqlfluff/sqlfluff/pull/1525) [adam-tokarski](https://github.com/adam-tokarski)
* Add Github Preview Image [1557](https://github.com/sqlfluff/sqlfluff/pull/1557) [alanmcruickshank](https://github.com/alanmcruickshank)
* Support SETOF in Postgres [1522](https://github.com/sqlfluff/sqlfluff/pull/1522) [tunetheweb](https://github.com/tunetheweb)
* Support Double Precision in ANSI [1524](https://github.com/sqlfluff/sqlfluff/pull/1524) [tunetheweb](https://github.com/tunetheweb)
* Support LATERAL joins in Postgres [1519](https://github.com/sqlfluff/sqlfluff/pull/1519) [adam-tokarski](https://github.com/adam-tokarski)
* Add a rule to warn on "= NULL" or "<> NULL" comparisons [1527](https://github.com/sqlfluff/sqlfluff/pull/1527) [barrywhart](https://github.com/barrywhart)
* Support Group and Groups as table names [1546](https://github.com/sqlfluff/sqlfluff/pull/1546) [tunetheweb](https://github.com/tunetheweb)
* Support more complex IN (...) expressions [1550](https://github.com/sqlfluff/sqlfluff/pull/1550) [tunetheweb](https://github.com/tunetheweb)
* Support CROSS APPLY and OUTER APPLY and TOP in T-SQL [1551](https://github.com/sqlfluff/sqlfluff/pull/1551) [tunetheweb](https://github.com/tunetheweb)
* Add support for WITHOUT ROWID to SQLite [1531](https://github.com/sqlfluff/sqlfluff/pull/1531) [tunetheweb](https://github.com/tunetheweb)
* Postgres: add `CONCURRENTLY` and `FINALIZE` keywords to `DETACH PARTITION` [1529](https://github.com/sqlfluff/sqlfluff/pull/1529) [kevinmarsh](https://github.com/kevinmarsh)
* Better support of MySQL CREATE TABLE TIMESTAMP/DATESTAMP [1530](https://github.com/sqlfluff/sqlfluff/pull/1530) [tunetheweb](https://github.com/tunetheweb)
* "Found unparsable section" instead of stack trace when multiple semicolons provided [1517](https://github.com/sqlfluff/sqlfluff/pull/1517) [adam-tokarski](https://github.com/adam-tokarski)

🐛 Bug Fixes
* Fix test coverage [1569](https://github.com/sqlfluff/sqlfluff/pull/1569) [tunetheweb](https://github.com/tunetheweb)
* Remove lint_templated_tokens as no longer does anything [1570](https://github.com/sqlfluff/sqlfluff/pull/1570) [tunetheweb](https://github.com/tunetheweb)
* Fix broken block comments in exasol [1565](https://github.com/sqlfluff/sqlfluff/pull/1565) [sti0](https://github.com/sti0)
* Rethink sequence_files in dbt templater. [1563](https://github.com/sqlfluff/sqlfluff/pull/1563) [alanmcruickshank](https://github.com/alanmcruickshank)
* T-SQL: fix STRING_AGG() WITHIN GROUP clause [1559](https://github.com/sqlfluff/sqlfluff/pull/1559) [jpers36](https://github.com/jpers36)
* fix spelling: occurrence>occurrence [1507](https://github.com/sqlfluff/sqlfluff/pull/1507) [jpers36](https://github.com/jpers36)

0.6.8

Not secure
Fixed a DBT bug introduced in 0.6.7 - apologies!

What’s Changed

SQLFluff can't find dbt models [1513](https://github.com/sqlfluff/sqlfluff/pull/1513) [barrywhart](https://github.com/barrywhart)
T-SQL: Support for unicode literals [1511](https://github.com/sqlfluff/sqlfluff/pull/1511) [adam-tokarski](https://github.com/adam-tokarski)

0.6.7

Not secure
Lots of fixes to our rules (particularly when running `sqlfluff fix`, and particularly for Jinja and DBT templates). We also have good improvements to Exasol, Snowflake, and T-SQL dialects amongst others. Plus we added Hive and SQLite as supported dialects!

What’s Changed
* Snowflake better WAREHOUSE and CREATE (EXTERNAL) TABLES support [1508](https://github.com/sqlfluff/sqlfluff/pull/1508) [tunetheweb](https://github.com/tunetheweb)
* Exasol: Fix typo in `REORGANIZE` statement [1509](https://github.com/sqlfluff/sqlfluff/pull/1509) [sti0](https://github.com/sti0)
* Fix bug that can prevent linting ephemeral dbt models [1496](https://github.com/sqlfluff/sqlfluff/pull/1496) [barrywhart](https://github.com/barrywhart)
* Disable rules L026 and L028 for BigQuery by default, with option to re-enable [1504](https://github.com/sqlfluff/sqlfluff/pull/1504) [tunetheweb](https://github.com/tunetheweb)
* BigQuery keywords [1506](https://github.com/sqlfluff/sqlfluff/pull/1506) [tunetheweb](https://github.com/tunetheweb)
* Inline --noqa not always honoured by "sqlfluff fix" [1502](https://github.com/sqlfluff/sqlfluff/pull/1502) [barrywhart](https://github.com/barrywhart)
* Snowflake - fix parsing of UNPIVOT [1505](https://github.com/sqlfluff/sqlfluff/pull/1505) [michael-the1](https://github.com/michael-the1)
* Better parsing of DATEADD function [1486](https://github.com/sqlfluff/sqlfluff/pull/1486) [jpers36](https://github.com/jpers36)
* Fix handling of ISNULL and NOTNULL keywords [1483](https://github.com/sqlfluff/sqlfluff/pull/1483) [leamingrad](https://github.com/leamingrad)
* Improved test cases names [1501](https://github.com/sqlfluff/sqlfluff/pull/1501) [ttomasz](https://github.com/ttomasz)
* Exasol: Fix CREATE TABLE in-/outline constraint / Adjusted DISTRIBUTE/PARTITION clause [1491](https://github.com/sqlfluff/sqlfluff/pull/1491) [sti0](https://github.com/sti0)
* Add support for SnowSQL variables [1497](https://github.com/sqlfluff/sqlfluff/pull/1497) [samlader](https://github.com/samlader)
* Ignore erroneous newline segments in L016 (e.g. Jinja for loops) [1494](https://github.com/sqlfluff/sqlfluff/pull/1494) [tunetheweb](https://github.com/tunetheweb)
* Indentation error on Jinja templated test case [1444](https://github.com/sqlfluff/sqlfluff/pull/1444) [barrywhart](https://github.com/barrywhart)
* Improve EXASOL dialect [1484](https://github.com/sqlfluff/sqlfluff/pull/1484) [sti0](https://github.com/sti0)
* T-SQL dialect - +support for CONVERT() special function [1489](https://github.com/sqlfluff/sqlfluff/pull/1489) [jpers36](https://github.com/jpers36)
* Allow Postgres column references to use `AT TIME ZONE` [1485](https://github.com/sqlfluff/sqlfluff/pull/1485) [leamingrad](https://github.com/leamingrad)
* T-SQL dialect - provide alternate ASA PR incorporating ASA into T-SQL [1478](https://github.com/sqlfluff/sqlfluff/pull/1478) [jpers36](https://github.com/jpers36)
* Modest parser performance improvement [1475](https://github.com/sqlfluff/sqlfluff/pull/1475) [NathanHowell](https://github.com/NathanHowell)
* Disable rule L033 for dialects that do not support it (e.g. Exasol, Postgres) [1482](https://github.com/sqlfluff/sqlfluff/pull/1482) [tunetheweb](https://github.com/tunetheweb)
* Adding a new BaseFileSegment class for FileSegments to inherit from [1473](https://github.com/sqlfluff/sqlfluff/pull/1473) [sti0](https://github.com/sti0)
* EXASOL_FS: Fix adapter script type [1480](https://github.com/sqlfluff/sqlfluff/pull/1480) [sti0](https://github.com/sti0)
* Dialect/tsql update - added pivot / unpivot, view support, sequence support on table creation [1469](https://github.com/sqlfluff/sqlfluff/pull/1469) [ericmuijs](https://github.com/ericmuijs)
* Correct typo in SQLFluff name [1470](https://github.com/sqlfluff/sqlfluff/pull/1470) [tunetheweb](https://github.com/tunetheweb)
* Stop L008 from adding spaces for simple SELECTs [1461](https://github.com/sqlfluff/sqlfluff/pull/1461) [CyberShadow](https://github.com/CyberShadow)
* Add SQLite dialect [1453](https://github.com/sqlfluff/sqlfluff/pull/1453) [tunetheweb](https://github.com/tunetheweb)
* Fix Windows Clause for Exasol [1463](https://github.com/sqlfluff/sqlfluff/pull/1463) [tunetheweb](https://github.com/tunetheweb)
* Add CHECK constraint syntax to ANSI SQL [1451](https://github.com/sqlfluff/sqlfluff/pull/1451) [tunetheweb](https://github.com/tunetheweb)
* Move Exasol test statements fixtures from Python to SQL files [1449](https://github.com/sqlfluff/sqlfluff/pull/1449) [tunetheweb](https://github.com/tunetheweb)
* fix spelling of "preceding" [1455](https://github.com/sqlfluff/sqlfluff/pull/1455) [jpers36](https://github.com/jpers36)
* Add NORMALIZE to Teradata dialect [1448](https://github.com/sqlfluff/sqlfluff/pull/1448) [tunetheweb](https://github.com/tunetheweb)
* Add and $ symbols to Exasol to avoid lexing errors [1447](https://github.com/sqlfluff/sqlfluff/pull/1447) [tunetheweb](https://github.com/tunetheweb)
* Stop fix adding then removing whitespace [1443](https://github.com/sqlfluff/sqlfluff/pull/1443) [barrywhart](https://github.com/barrywhart)
* Stop exception in L016 for long Jinja comments [1440](https://github.com/sqlfluff/sqlfluff/pull/1440) [tunetheweb](https://github.com/tunetheweb)
* Fix some issues where the SQL file is corrupted by lint "fixes" in or near Jinja loops [1431](https://github.com/sqlfluff/sqlfluff/pull/1431) [barrywhart](https://github.com/barrywhart)
* T-SQL: Remove Limit and NamedWindow segments as not supported in T-SQL [1420](https://github.com/sqlfluff/sqlfluff/pull/1420) [jpers36](https://github.com/jpers36)
* Fix runtime error (IndexError ) when linting file with jinja "if" [1430](https://github.com/sqlfluff/sqlfluff/pull/1430) [barrywhart](https://github.com/barrywhart)
* Add Hive dialect (985) [satish-ravi](https://github.com/satish-ravi)
* Further fix for L036 [1428](https://github.com/sqlfluff/sqlfluff/pull/1428) [tunetheweb](https://github.com/tunetheweb)
* Add default parameter to dbt "var" macro stub [1426](https://github.com/sqlfluff/sqlfluff/pull/1426) [CyberShadow](https://github.com/CyberShadow)

0.6.6

Not secure
Fixed some of our autofix rules where running `fix` sometimes made unintended changes. Added config to rules L011 and L012 to allow preferring implicit aliasing. Also further improved our Postgres support and documentation.

What’s Changed
* Rule L036 bug fixes [1427](https://github.com/sqlfluff/sqlfluff/pull/1427) [tunetheweb](https://github.com/tunetheweb)
* Added support for psql meta commands to Postgres [1423](https://github.com/sqlfluff/sqlfluff/pull/1423) [WittierDinosaur](https://github.com/WittierDinosaur)
* Remaining line endings [1415](https://github.com/sqlfluff/sqlfluff/pull/1415) [tunetheweb](https://github.com/tunetheweb)
* T-SQL: Remove match possibilities for segments with no T-SQL equivalent [1416](https://github.com/sqlfluff/sqlfluff/pull/1416) [jpers36](https://github.com/jpers36)
* Fix generate error on test file with just a comment [1413](https://github.com/sqlfluff/sqlfluff/pull/1413) [tunetheweb](https://github.com/tunetheweb)
* Misc fixes to workflow files [1412](https://github.com/sqlfluff/sqlfluff/pull/1412) [tunetheweb](https://github.com/tunetheweb)
* Added support for escape character strings to Postgres [1409](https://github.com/sqlfluff/sqlfluff/pull/1409) [WittierDinosaur](https://github.com/WittierDinosaur)
* Issue 845: L016 should compute line length prior to template expansion [1411](https://github.com/sqlfluff/sqlfluff/pull/1411) [barrywhart](https://github.com/barrywhart)
* Add .editorconfig config and enforce style rules [1410](https://github.com/sqlfluff/sqlfluff/pull/1410) [tunetheweb](https://github.com/tunetheweb)
* Allow optional enforcing of implicit aliasing of tables (L011) and columns (L012) [1402](https://github.com/sqlfluff/sqlfluff/pull/1402) [tunetheweb](https://github.com/tunetheweb)
* Better error messages on error [1407](https://github.com/sqlfluff/sqlfluff/pull/1407) [tunetheweb](https://github.com/tunetheweb)
* Add README on how to generate docs [1403](https://github.com/sqlfluff/sqlfluff/pull/1403) [tunetheweb](https://github.com/tunetheweb)
* Fix extra underscores in case rules (L010 and L014) [1396](https://github.com/sqlfluff/sqlfluff/pull/1396) [tunetheweb](https://github.com/tunetheweb)
* Remove unused deps in tox test docbuild [1406](https://github.com/sqlfluff/sqlfluff/pull/1406) [zhongjiajie](https://github.com/zhongjiajie)
* Prevent CodeCov commenting on coverage differences too early [1404](https://github.com/sqlfluff/sqlfluff/pull/1404) [tunetheweb](https://github.com/tunetheweb)
* Fix "sqlfluff fix compatible" rules indenting to much in documentation [1405](https://github.com/sqlfluff/sqlfluff/pull/1405) [tunetheweb](https://github.com/tunetheweb)
* Fix documentation SQL highlight error [1393](https://github.com/sqlfluff/sqlfluff/pull/1393) [zhongjiajie](https://github.com/zhongjiajie)
* Support TIMESTAMPTZ in TIME ZONE queries for Postgres [1398](https://github.com/sqlfluff/sqlfluff/pull/1398) [tunetheweb](https://github.com/tunetheweb)
* Improve datatypes: CHARACTER VARYING for ANSI, and Postgres and also TIMESTAMP AT TIME ZONE for Postgres [1378](https://github.com/sqlfluff/sqlfluff/pull/1378) [WittierDinosaur](https://github.com/WittierDinosaur)
* Improve rules L003 and L019 by processing multi-line fixes in one pass. [1391](https://github.com/sqlfluff/sqlfluff/pull/1391) [barrywhart](https://github.com/barrywhart)
* Correct codecov badge for Docs website [1390](https://github.com/sqlfluff/sqlfluff/pull/1390) [tunetheweb](https://github.com/tunetheweb)
* Change fix to use non-zero exit code if unfixable [1389](https://github.com/sqlfluff/sqlfluff/pull/1389) [tunetheweb](https://github.com/tunetheweb)
* Bugfix, frame clauses in window functions were not working [1381](https://github.com/sqlfluff/sqlfluff/pull/1381) [WittierDinosaur](https://github.com/WittierDinosaur)
* Handle template and unfixable errors when fixing stdin [1385](https://github.com/sqlfluff/sqlfluff/pull/1385) [nolanbconaway](https://github.com/nolanbconaway)
* CREATE, ALTER, DROP SEQUENCE support, with Postgres extensions [1380](https://github.com/sqlfluff/sqlfluff/pull/1380) [WittierDinosaur](https://github.com/WittierDinosaur)
* Postgres analyze [1377](https://github.com/sqlfluff/sqlfluff/pull/1377) [WittierDinosaur](https://github.com/WittierDinosaur)
* L016: "sqlfluff fix" adds too many newlines [1382](https://github.com/sqlfluff/sqlfluff/pull/1382) [barrywhart](https://github.com/barrywhart)
* L003 fix mixes hanging and clean indents [1383](https://github.com/sqlfluff/sqlfluff/pull/1383) [barrywhart](https://github.com/barrywhart)
* L034 should not fix inside "INSERT" or "CREATE TABLE AS SELECT" [1384](https://github.com/sqlfluff/sqlfluff/pull/1384) [barrywhart](https://github.com/barrywhart)

0.6.5

Not secure
What’s Changed

This release includes initial support of Transact-SQL (T-SQL), much better Postgres and Snowflake support, improvements to our documentation, 100% coverage for Python code (with a small number of accepted exceptions), along with numerous other bug fixes and improvements.

Many thanks to all the [contributors](https://github.com/sqlfluff/sqlfluff/graphs/contributors) helping to improve SQLFluff!

Complete list of changes

* Simplify rule L030 and fix recursion bug ([1376](https://github.com/sqlfluff/sqlfluff/pull/1376)) ([tunetheweb](https://github.com/tunetheweb)
* Move from CircleCI to GitHub Actions for Continuous Integration ([1361](https://github.com/sqlfluff/sqlfluff/pull/1361)) ([tunetheweb](https://github.com/tunetheweb)
* Postgres enhance create index ([1375](https://github.com/sqlfluff/sqlfluff/pull/1375)) ([WittierDinosaur](https://github.com/WittierDinosaur)
* Initial support for Transact-SQL (T-SQL) dialect ([1313](https://github.com/sqlfluff/sqlfluff/pull/1313)) ([ericmuijs](https://github.com/ericmuijs)
* Handle initial whitespace lines in rule L001 ([1372](https://github.com/sqlfluff/sqlfluff/pull/1372)) ([tunetheweb](https://github.com/tunetheweb)
* Postgres Improved DEFAULT column constraint support ([1373](https://github.com/sqlfluff/sqlfluff/pull/1373)) ([WittierDinosaur](https://github.com/WittierDinosaur)
* Minor grammar, spelling, and readability fixes ([1370](https://github.com/sqlfluff/sqlfluff/pull/1370)) ([WittierDinosaur](https://github.com/Fdawgs)
* Issues 854, 1321: Handle Jinja leading whitespace-only lines ([1364](https://github.com/sqlfluff/sqlfluff/pull/1364)) ([barrywhart](https://github.com/barrywhart)
* Enhanced the Postgres grammar for create table ([1369](https://github.com/sqlfluff/sqlfluff/pull/1369)) ([WittierDinosaur](https://github.com/WittierDinosaur)
* Added ability to Grant and Revoke Grant to multiple users ([1367](https://github.com/sqlfluff/sqlfluff/pull/1367)) ([WittierDinosaur](https://github.com/WittierDinosaur)
* Add BigQuery Parameter Lexing and Parsing ([1363](https://github.com/sqlfluff/sqlfluff/pull/1363)) ([rileyrunnoe](https://github.com/rileyrunnoe)
* Rule L030 bugfix ([1360](https://github.com/sqlfluff/sqlfluff/pull/1360)) ([WittierDinosaur](https://github.com/WittierDinosaur)
* Add Postgres dialect for COMMENT ON ([1358](https://github.com/sqlfluff/sqlfluff/pull/1358)) ([miketheman](https://github.com/miketheman)
* Allow ORDER BY and LIMIT after QUALIFY in BigQuery ([1362](https://github.com/sqlfluff/sqlfluff/pull/1362)) ([tunetheweb](https://github.com/tunetheweb)
* Correct CircleCI badge reference ([1359](https://github.com/sqlfluff/sqlfluff/pull/1359)) [miketheman](https://github.com/miketheman)
* Minor grammar corrections to documentation ([1355](https://github.com/sqlfluff/sqlfluff/pull/1355)) [miketheman](https://github.com/miketheman)
* Pytest coverage exceptions to get us to 100% coverage! ([1346](https://github.com/sqlfluff/sqlfluff/pull/1346)) [tunetheweb](https://github.com/tunetheweb)
* Greatly improved Snowflake syntax support ([1353](https://github.com/sqlfluff/sqlfluff/pull/1353)) [tunetheweb](https://github.com/tunetheweb)
* Postgres keyword support ([1347](https://github.com/sqlfluff/sqlfluff/pull/1347)) [WittierDinosaur](https://github.com/WittierDinosaur)
* Added full support for postgres's ALTER DEFAULT PRIVILEGES. ([1350](https://github.com/sqlfluff/sqlfluff/pull/1350)) [creste](https://github.com/creste)
* Show all LintResult in Rule_L020 ([1348](https://github.com/sqlfluff/sqlfluff/pull/1348)) [zhongjiajie](https://github.com/zhongjiajie)
* Enhance error message L010 base on configure ([1351](https://github.com/sqlfluff/sqlfluff/pull/1351)) [zhongjiajie](https://github.com/zhongjiajie)
* Remove unused variable insert_str ([1352](https://github.com/sqlfluff/sqlfluff/pull/1352)) [zhongjiajie](https://github.com/zhongjiajie)
* Pytest coverage exceptions for Core code - part 1 ([1343](https://github.com/sqlfluff/sqlfluff/pull/1343)) [tunetheweb](https://github.com/tunetheweb)
* BigQuery: Allow Qualify Clause for UnorderedSelectStatements ([1341](https://github.com/sqlfluff/sqlfluff/pull/1341)) [tunetheweb](https://github.com/tunetheweb)
* Postgres "ALTER TABLE" enhancement, and timestamp bug fix ([1338](https://github.com/sqlfluff/sqlfluff/pull/1338)) [WittierDinosaur](https://github.com/WittierDinosaur)
* Improve pytest coverage for non-core code ([1319](https://github.com/sqlfluff/sqlfluff/pull/1319)) [tunetheweb](https://github.com/tunetheweb)
* Support additional GRANTs in Postgres ([1339](https://github.com/sqlfluff/sqlfluff/pull/1339)) [creste](https://github.com/creste)
* Allow optional alias for BigQuery WITH OFFSET ([1330](https://github.com/sqlfluff/sqlfluff/pull/1330)) [tunetheweb](https://github.com/tunetheweb)
* Improve function support in Postgres dialect ([1336](https://github.com/sqlfluff/sqlfluff/pull/1336)) [WittierDinosaur](https://github.com/WittierDinosaur)
* Using github star instead of watch in docs ([1337](https://github.com/sqlfluff/sqlfluff/pull/1337)) [zhongjiajie](https://github.com/zhongjiajie)
* Add unittest for rules docstring ([1335](https://github.com/sqlfluff/sqlfluff/pull/1335)) [zhongjiajie](https://github.com/zhongjiajie)
* Bugfix PR, fixes issue [1333](https://github.com/sqlfluff/sqlfluff/issues/#1333), wherein test___main___help() defaults to your default Python installation ([1334](https://github.com/sqlfluff/sqlfluff/pull/1334)) [WittierDinosaur](https://github.com/WittierDinosaur)
* Improve wording of L007 now the before/after is configurable ([1325](https://github.com/sqlfluff/sqlfluff/pull/1325)) [tunetheweb](https://github.com/tunetheweb)
* Fix a couple of small issues with CI jobs ([1326](https://github.com/sqlfluff/sqlfluff/pull/1326)) [tunetheweb](https://github.com/tunetheweb)
* Add updated sqlfluff graphics and source. ([1315](https://github.com/sqlfluff/sqlfluff/pull/1315)) [alanmcruickshank](https://github.com/alanmcruickshank)
* Issue 1277: Enforce that YML test files are computer generated and not edited ([1279](https://github.com/sqlfluff/sqlfluff/pull/1279)) [barrywhart](https://github.com/barrywhart)
* Fix typo in README ([1320](https://github.com/sqlfluff/sqlfluff/pull/1320)) [tunetheweb](https://github.com/tunetheweb)
* Fix link in README ([1316](https://github.com/sqlfluff/sqlfluff/pull/1316)) [jmks](https://github.com/jmks)
* Update documentation to make the project more discoverable ([1311](https://github.com/sqlfluff/sqlfluff/pull/1311)) [tunetheweb](https://github.com/tunetheweb)
* Show latest version number on unsupported Python error message ([1307](https://github.com/sqlfluff/sqlfluff/pull/1307)) [zhongjiajie](https://github.com/zhongjiajie)
* Fix typo in github PR template ([1308](https://github.com/sqlfluff/sqlfluff/pull/1308)) [zhongjiajie](https://github.com/zhongjiajie)

Page 16 of 24

© 2024 Safety CLI Cybersecurity Inc. All Rights Reserved.