Sqlfluff

Latest version: v3.3.1

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

Scan your dependencies

Page 19 of 26

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)

0.6.4

Not secure
Added
* Added support for empty WINDOWS specifications ([1293](https://github.com/sqlfluff/sqlfluff/pull/1293)) [matthieucan](https://github.com/matthieucan)
* Added auto release drafter ([1287](https://github.com/sqlfluff/sqlfluff/pull/1287)) [tunetheweb](https://github.com/tunetheweb)

Changed
* Fix typo in the in the wild page ([1285](https://github.com/sqlfluff/sqlfluff/pull/1285)) [tunetheweb](https://github.com/tunetheweb)
* Fix spacing issue for BigQuery UNNEST statement for rules L003 and L025 ([1303](https://github.com/sqlfluff/sqlfluff/pull/1303)) [tunetheweb](https://github.com/tunetheweb)
* Update GitHub templates ([1297](https://github.com/sqlfluff/sqlfluff/pull/1297)) [tunetheweb](https://github.com/tunetheweb)
* Allow BigQuery UDF with triple quoted bodies to pass rule L048 ([1300](https://github.com/sqlfluff/sqlfluff/pull/1300)) [tunetheweb](https://github.com/tunetheweb)
* Add Parameterless Functions and more function names support to BigQuery ([1299](https://github.com/sqlfluff/sqlfluff/pull/1299)) [tunetheweb](https://github.com/tunetheweb)
* Add release drafter ([1295](https://github.com/sqlfluff/sqlfluff/pull/1295)) [tunetheweb](https://github.com/tunetheweb)
* Support empty OVER() clause in Window Specification ([1294](https://github.com/sqlfluff/sqlfluff/pull/1294)) [tunetheweb](https://github.com/tunetheweb)
* Fix typo on the In the Wild page ([1285](https://github.com/sqlfluff/sqlfluff/pull/1285)) [tunetheweb](https://github.com/tunetheweb)

0.6.3

Not secure
Added

- Support for primary index name, collect stats improvement, COMMENT statement for teradata dialect [1232](https://github.com/sqlfluff/sqlfluff/issues/1232)
- Support config for L007 to prefer end of line operators [1261](https://github.com/sqlfluff/sqlfluff/issues/1261)
- Support for DETERMINISTIC user defined functions in BigQuery dialect [1251](https://github.com/sqlfluff/sqlfluff/issues/1251)
- Support more identifiers in BigQuery dialect [1253](https://github.com/sqlfluff/sqlfluff/issues/1253)
- Support function member field references in BigQuery dialect [1255](https://github.com/sqlfluff/sqlfluff/issues/1255)
- Support alternative indentation for USING and ON clauses [1250](https://github.com/sqlfluff/sqlfluff/issues/1250)
- Support COUNT(0) preference over COUNT(*) or COUNT(1) [1260](https://github.com/sqlfluff/sqlfluff/issues/1260)
- Support for BigQuery "CREATE table OPTIONS ( description = 'desc' )" [1205](https://github.com/sqlfluff/sqlfluff/issues/1205)
- Support wildcard member field references in BigQuery dialect [1269](https://github.com/sqlfluff/sqlfluff/issues/1269)
- Support ARRAYS of STRUCTs in BigQuery dialect [1271](https://github.com/sqlfluff/sqlfluff/issues/1271)
- Support fields of field references in BigQuery dialect [1276](https://github.com/sqlfluff/sqlfluff/issues/1276)
- Support OFFSET and ORDINAL clauses of Array Functions in BigQuery dialect [1171](https://github.com/sqlfluff/sqlfluff/issues/1171)
- Added check for generated YML files [1277](https://github.com/sqlfluff/sqlfluff/issues/1277)
- Support QUALIFY to BigQuery dialect [1242](https://github.com/sqlfluff/sqlfluff/issues/1242)

Changed

- Fix comma removed by L019 [939](https://github.com/sqlfluff/sqlfluff/issues/939)
- Update L019 (leading/trailng comma rule) so it doesn't run on unparsable code.
- The `--nocolor` command-line option should suppress emoji output [1246](https://github.com/sqlfluff/sqlfluff/issues/1246)
- Added HTTP Archive to the [In The Wild page](https://docs.sqlfluff.com/en/stable/inthewild.html)

0.6.2

Not secure
Added

- Support for looping statements (loop, while, repeat) and supporting statements to mysql dialect [1180](https://github.com/sqlfluff/sqlfluff/issues/1180)

Changed

- Added dbt 0.20.* to the default test suite.
- Updated manifest loading in dbt 0.20.* to use the new `ManifestLoader` [1220](https://github.com/sqlfluff/sqlfluff/pull/1220)
- Handle newlines in rule list configuration in .sqlfluff [1215](https://github.com/sqlfluff/sqlfluff/issues/1215)
- Fix looping interaction between L008 and L030 [1207](https://github.com/sqlfluff/sqlfluff/issues/1207)

0.6.1

Not secure
Added

- Linting output now supports GitHub Actions [1190](https://github.com/sqlfluff/sqlfluff/issues/1190)
- Support for QUALIFY syntax specific to teradata dialect [1184](https://github.com/sqlfluff/sqlfluff/issues/1184)
- Support for TRUNCATE statement [1194](https://github.com/sqlfluff/sqlfluff/pull/1194)
- Support for prepared statement syntaxes specific to mysql dialect [1147](https://github.com/sqlfluff/sqlfluff/issues/1147)
- Support for GET DIAGNOSTICS statement syntax specific to mysql dialect [1148](https://github.com/sqlfluff/sqlfluff/issues/1148)
- Support for cursor syntax specific to mysql dialect [1145](https://github.com/sqlfluff/sqlfluff/issues/1145)
- Support sequential shorthand casts [1178](https://github.com/sqlfluff/sqlfluff/pull/1178)
- Support for select statement syntax specific to mysql dialect [1175](https://github.com/sqlfluff/sqlfluff/issues/1175)
- Support for the CALL statement for the mysql dialect [1144](https://github.com/sqlfluff/sqlfluff/issues/1144)
- Support for OVERLAPS predicate [1091](https://github.com/sqlfluff/sqlfluff/issues/1091)
- Support for the CREATE/DROP PROCEDURE statement for the mysql dialect [901](https://github.com/sqlfluff/sqlfluff/issues/901)
- Specific allowed/required syntaxes for CREATE/DROP FUNCTION within the mysql dialect [901](https://github.com/sqlfluff/sqlfluff/issues/901)
- Support for DECLARE statement for the mysql dialect [1140](https://github.com/sqlfluff/sqlfluff/issues/1140)
- Support for the IF-THEN-ELSEIF-ELSE syntax for the mysql dialect [1140](https://github.com/sqlfluff/sqlfluff/issues/1140)
- Support for the DEFINER syntax for the mysql dialect [1131](https://github.com/sqlfluff/sqlfluff/issues/1131)
- Preserve existing file encoding in the "fix" command. Partially addresses [654](https://github.com/sqlfluff/sqlfluff/issues/654)
- Support for DECLARE and SET variable syntax for the BigQuery dialect [1127](https://github.com/sqlfluff/sqlfluff/issues/1127)
- Support for ALTER TASK statement on Snowflake [1211](https://github.com/sqlfluff/sqlfluff/pull/1211)

Changed

- Fix runtime error in diff-cover plugin caused by new diff-cover release 6.1.0 [1195](https://github.com/sqlfluff/sqlfluff/pull/1195)
- Resolved an issue with the snowflake dialect where backslash escaped single
quoted strings led to fatal lexing errors [1200](https://github.com/sqlfluff/sqlfluff/pull/1200)

Contributors

- [GitHub-Username](Link to GitHub profile) ([PR-Number](Link to PR))
- [dflss](https://github.com/dflss) ([#1154](https://github.com/sqlfluff/sqlfluff/pull/1154))
- [barrywhart](https://github.com/barrywhart) ([#1177](https://github.com/sqlfluff/sqlfluff/pull/1177), [#1195](https://github.com/sqlfluff/sqlfluff/pull/1195))
- [niallrees](https://github.com/niallrees) ([#1178](https://github.com/sqlfluff/sqlfluff/pull/1178))
- [barnabyshearer](https://github.com/barnabyshearer) ([#1194](https://github.com/sqlfluff/sqlfluff/pull/1194))
- [silverbullettruck2001](https://github.com/silverbullettruck2001) ([#1141](https://github.com/sqlfluff/sqlfluff/pull/1141), [#1159](https://github.com/sqlfluff/sqlfluff/pull/1159), [#1161](https://github.com/sqlfluff/sqlfluff/pull/1161), [#1176](https://github.com/sqlfluff/sqlfluff/pull/1176), [#1179](https://github.com/sqlfluff/sqlfluff/pull/1179), [#1181](https://github.com/sqlfluff/sqlfluff/pull/1181), [#1193](https://github.com/sqlfluff/sqlfluff/pull/1193), [#1203](https://github.com/sqlfluff/sqlfluff/pull/1203))

Page 19 of 26

© 2025 Safety CLI Cybersecurity Inc. All Rights Reserved.