Skip to content

Releases: sqlfluff/sqlfluff

[3.1.0] - 2024-07-03

03 Jul 17:32
@github-actions github-actions
3.1.0
3ef765d
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.
Compare
Choose a tag to compare
[3.1.0] - 2024-07-03 Latest
Latest

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

New Contributors

Assets 2
Loading

[3.0.7] - 2024-05-23

23 May 09:39
@github-actions github-actions
3.0.7
6c22f5e
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.
Compare
Choose a tag to compare
[3.0.7] - 2024-05-23

Highlights

This is primarily a fix for compatibility with dbt 1.8+. Beyond that it also brings several dialect improvements to SQLite, Bigquery, MySQL, Oracle & Clickhouse.

Thanks also to the five new contributors whose work was included in this release! 🎉🎉🏆🎉🎉

What’s Changed

New Contributors

Contributors

timchurch, kzosabe, and 5 other contributors
Assets 2
Loading

[3.0.6] - 2024-05-06

06 May 19:38
@github-actions github-actions
3.0.6
75cf648
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.
Compare
Choose a tag to compare
[3.0.6] - 2024-05-06

Highlights

This release primarily fixes an issue introduced by the recent dbt 1.7.14 release, and better support for dbt 1.7+. It also includes a range of dialect improvements and CLI refinements.

This release also includes the groundwork for linting the unrendered sections of Jinja templates. More documentation on this will be released in due course when it's ready for beta testing.

Thanks also to @padraic00 & @burhanyasar who made their first contributions in this release. 🎉🎉🏆🎉🎉

What’s Changed

New Contributors

Contributors

kzosabe, burhanyasar, and 8 other contributors
Assets 2
Loading

[3.0.5] - 2024-04-19

19 Apr 13:47
@github-actions github-actions
3.0.5
fbf8fad
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.
Compare
Choose a tag to compare
[3.0.5] - 2024-04-19

Highlights

This release contains one larger change, which is a big upgrade to case sensitivity in the alias use rules. Also allowing the customisation of how SQLFluff uses case sensitivity in rules like AL05. Beyond that, this also includes a handful of dialect improvements.

Thanks especially to @olshak, @MarkPaulin, @mhoogendoorn & @kawashiro who made their first contributions in this release! 🚀

What’s Changed

Contributors

kzosabe, mhoogendoorn, and 5 other contributors
Assets 2
Loading

[3.0.4] - 2024-04-09

09 Apr 17:44
@github-actions github-actions
3.0.4
cda058e
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.
Compare
Choose a tag to compare
[3.0.4] - 2024-04-09

Highlights

This is a standard bugfix release bringing a bunch of dialect improvements and bugfixes. Almost every dialect sees some improvements and it also includes quality of life improvements to the CLI, pre-commit hooks, docs and several rules.

Thanks also to the eight new contributors whose first contributions are included in this release. 🎉🎉🏆🎉🎉

What’s Changed

New Contributors

Contributors

kzosabe, mdeweerd, and 10 other contributors
Assets 2
Loading

[3.0.3] - 2024-03-22

22 Mar 11:57
@github-actions github-actions
3.0.3
40bdc4b
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.
Compare
Choose a tag to compare
[3.0.3] - 2024-03-22

Highlights

This is a standard minor release fixing a set of dialect issues with Trino, BigQuery, Vertica and Snowflake.

Thanks to @maegan-canva, @rileymcdowell & @paysni who made their first contributions in this release.

What’s Changed

New Contributors

Assets 2
Loading

[3.0.2] - 2024-03-17

17 Mar 19:46
@github-actions github-actions
3.0.2
5ac7e6e
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.
Compare
Choose a tag to compare
[3.0.2] - 2024-03-17

Highlights

This is primarily another hotfix release for 3.0.0. Specifically making sure the deprecation warnings for -f/--force go to stderr rather than stdout. It also includes two dialect improvements, one for Snowflake and one for T-SQL.

What’s Changed

Assets 2
Loading

[3.0.1] - 2024-03-13

13 Mar 23:08
@github-actions github-actions
3.0.1
5b39b51
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.
Compare
Choose a tag to compare
[3.0.1] - 2024-03-13

Highlights

This minor release is a hotfix to resolve a bug introduced affecting CLI exit codes
in the 3.0.0 release.

What’s Changed

Assets 2
Loading

[3.0.0] - 2024-03-12

12 Mar 19:41
@github-actions github-actions
3.0.0
85c85bf
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.
Compare
Choose a tag to compare
[3.0.0] - 2024-03-12

Highlights

This release brings several breaking changes to previous releases. Most notably:

  • It drops support for python 3.7, which reached end of life in June 2023.

  • It migrates to pyproject.toml rather than setup.cfg as the python packaging configuration file (although keeping setuptools as the default backend).

  • The serialised output for sqlfluff lint (and the corresponding API methods) now contains more information about the span of linting issues, initial proposed fixes and several statistics which were previously only accessible via csv export. Beside the new fields, the original fields of line_pos and line_no have been renamed to start_line_pos and start_line_no, to distinguish them from the new fields starting end_*.

  • The default annotation_level set by the --annotation-level option on the sqlfluff lint command has been changed from notice to warning, to better distinguish linting errors from warnings, which always now have the level of notice. This is only relevant when using the github-annotation or github-annotation-native formats.

  • A change in the default behaviour for convention.not_equals. The new default is to be consistent, which is slightly more relaxed than the original behaviour.

  • The --force option has been deprecated on sqlfluff fix as that option is now the default behaviour. This is to enable significant reductions in memory overhead when linting large projects.

  • The long since deprecated --disable_progress_bar option has been removed (which was replaced by the kabab-case --disable-progress-bar more than a year ago).

  • Plugins are now loaded progressively, and with error handling. If a plugin fails to load, SQLFluff will now continue onward and try to run regardless while also showing a more helpful error message.

On top of these changes, there have a been a whole host of dialect improvements and additions, in particular the inclusion of avertica dialect for the first time. There's also:

  • A new rule (aliasing.self_alias.column) which prevents aliasing a column as itself.

  • A change to disables AL01 (aliasing.table) by default for Oracle.

  • A change to allow AL05 to allow aliasing for a VALUES clause.

For more specifics please take a look at the release notes.

Thanks to the community for patience during the release cycle for 3.0.0, which has taken a little longer than expected. Thanks also to the TWENTY SEVEN new contributors whose changes are included in this release. 🎉🎉🏆🎉🎉

What’s Changed

Read more
Assets 2
Loading

[3.0.0a6] - 2024-03-05

05 Mar 21:19
@github-actions github-actions
3.0.0a6
ee8e536
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.
Compare
Choose a tag to compare
[3.0.0a6] - 2024-03-05 Pre-release
Pre-release

Highlights

This introduces some memory optimisations in the linting operation which prevent a major cause of crashes when linting large projects. As part of that we've also deprecated the --force option on sqlfluff fix and made that the default behaviour (the associated memory optimisations will come shortly).

This also removes the long since deprecated --disable_progress_bar option (which was replaced by the kabab-case --disable-progress -bar more than a year ago).

On top of that this release also introduces the vertica dialect for the first time, and a whole host of bugfixes and improvements to other dialects.

This release should be considered a release candidate for the final 3.0.0 release which will follow shortly in the next few days unless any other major issues are found.

Thanks particularly to the seven new contributors we saw in this release 🏆🎉.

What’s Changed

Contributors

alanmcruickshank, mitchellvanrijkom, and 12 other contributors
Assets 2
Loading