sqlfluff/sqlfluff 0.4.0

0.4.0 Release

on GitHub

This is a huge major release, which wouldn't have been possible without a massive number of contributors. 🎉 🎉. In particular thanks to everyone who tested the alpha versions of this release in the wild.

Major new functionality includes:

• This release drops support for python 3.5.
• A public API to import sqlfluff and use the main functionality within other python projects. See examples for more details.
• A dbt templating engine which can use the compiler from dbt directly all allow access to all of the macros within a project.
• Source mapping so that linting errors are now reported based on their position in the raw file rather than the templated file.
• Optimisations in the templating and parsing engine to provide significant performance improvements, especially on large sql files and large codebases.

Alongside these big changes, there are a whole host of parser improvements for all dialects and a set of new linting rules and configuration options.

For full details of the changes, check out the changelog.