Sqlfluff

Highlights

This release resolves compatibility issues with a set of `dbt-core` versions.
- `dbt-core` 1.5.2 onwards is now properly supported.
- support for `dbt-core` 1.1 to 1.4 has now been re-enabled after
support had to be abandoned a few releases ago.

NOTE: We cannot guarantee that SQLFluff will always continue to remain
compatible with all dbt versions, particularly as the folks at dbt-labs
have often backported breaking changes to their internal APIs to previous
versions of `dbt-core`. This release does at least bring more extensive
internal testing to catch when this does occur to allow our community
to react.

This release fixes also resolves a potential security issue for when
using external libraries (and the `library_path` config setting),
and also contains various dialect improvements.

What’s Changed

* docs(templater): Add documentation for `SQLFLUFF_JINJA_FILTERS` [4932](https://github.com/sqlfluff/sqlfluff/pull/4932) [dmohns](https://github.com/dmohns)
* Re-enable dbt 1.1 & 1.2 [4944](https://github.com/sqlfluff/sqlfluff/pull/4944) [alanmcruickshank](https://github.com/alanmcruickshank)
* Re-enable dbt 1.4 & 1.3 [4941](https://github.com/sqlfluff/sqlfluff/pull/4941) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix compatibility with dbt 1.5.2+ [4939](https://github.com/sqlfluff/sqlfluff/pull/4939) [alanmcruickshank](https://github.com/alanmcruickshank)
* Security option for library path [4925](https://github.com/sqlfluff/sqlfluff/pull/4925) [alanmcruickshank](https://github.com/alanmcruickshank)
* Remove extra code escapes from release notes docs [4921](https://github.com/sqlfluff/sqlfluff/pull/4921) [tunetheweb](https://github.com/tunetheweb)
* Postgres frame_clause quoted interval [4915](https://github.com/sqlfluff/sqlfluff/pull/4915) [greg-finley](https://github.com/greg-finley)
* Snowflake: CREATE TAG [4914](https://github.com/sqlfluff/sqlfluff/pull/4914) [greg-finley](https://github.com/greg-finley)
* TSQL: support for `DROP EXTERNAL TABLE` [4919](https://github.com/sqlfluff/sqlfluff/pull/4919) [keen85](https://github.com/keen85)
* fix(dialect-clickhouse): Support create database [4620](https://github.com/sqlfluff/sqlfluff/pull/4620) [germainlefebvre4](https://github.com/germainlefebvre4)
* Snowflake: Actualize the CreateProcedureStatementSegment and CreateFunctionStatementSegment [4908](https://github.com/sqlfluff/sqlfluff/pull/4908) [moreaupascal56](https://github.com/moreaupascal56)
* Oracle: Add support for `$` and `` in identifier [4903](https://github.com/sqlfluff/sqlfluff/pull/4903) [ulixius9](https://github.com/ulixius9)
* docs(templater): Refactor templater configuration docs [4835](https://github.com/sqlfluff/sqlfluff/pull/4835) [dmohns](https://github.com/dmohns)
* Handle brackets in from clause with joins [4890](https://github.com/sqlfluff/sqlfluff/pull/4890) [ulixius9](https://github.com/ulixius9)
* Postgres: Add support for dollar literal & mark collation as non-reserved [4883](https://github.com/sqlfluff/sqlfluff/pull/4883) [ulixius9](https://github.com/ulixius9)
* MySQL: ON UPDATE NOW [4898](https://github.com/sqlfluff/sqlfluff/pull/4898) [greg-finley](https://github.com/greg-finley)
* Support ROLLUP/CUBE in AM06 [4892](https://github.com/sqlfluff/sqlfluff/pull/4892) [tunetheweb](https://github.com/tunetheweb)

- Fix linting not clearing diagnostics when there are no linting problems.

- Improve the `lintEntireProject` to lint the entire workspace at once.

Highlights

This is a bugfix release to resolve two regressions included in 2.0.6
related to implicit indents. This also includes a bugfix for config
file on osx, contributed by first time contributor [jpuris](https://github.com/jpuris) 🎉.

What’s Changed

* Fix regression in implicit indents [4798](https://github.com/sqlfluff/sqlfluff/pull/4798) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix bug with brackets and implicit indents [4797](https://github.com/sqlfluff/sqlfluff/pull/4797) [alanmcruickshank](https://github.com/alanmcruickshank)
* fix: correct macos/osx config file location [4795](https://github.com/sqlfluff/sqlfluff/pull/4795) [jpuris](https://github.com/jpuris)

New Contributors

* [jpuris](https://github.com/jpuris) made their first contribution in [#4795](https://github.com/sqlfluff/sqlfluff/pull/4795)

Highlights

* Introduction of a `--quiet` option for the CLI for situations
where less output is useful.
* When using the `--force` option is used for `sqlfluff fix` each
file is fixed during the linting process rather than at the end.
* Bugfixes to comment and templated section indentation.
* Performance improvements to parsing.
* Bugfix to macros triggering LT01.
* Renaming `layout.end-of-file` to `layout.end_of_file` in line
with other rules.
* Dialect improvements to SparkSQL, BigQuery, Hive & Snowflake.


What’s Changed

* Snowflake: Support Temporary View [4789](https://github.com/sqlfluff/sqlfluff/pull/4789) [WittierDinosaur](https://github.com/WittierDinosaur)
* Inroduce `SAFE` prefix segment [4773](https://github.com/sqlfluff/sqlfluff/pull/4773) [dmohns](https://github.com/dmohns)
* Fix 4660: Better handling of empty files. [4780](https://github.com/sqlfluff/sqlfluff/pull/4780) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix 3538: (Fix files as we go) [4777](https://github.com/sqlfluff/sqlfluff/pull/4777) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix 2855: (Tech debt: check consistency in TemplatedFile init) [4776](https://github.com/sqlfluff/sqlfluff/pull/4776) [alanmcruickshank](https://github.com/alanmcruickshank)
* Add a --quiet option for fix [4764](https://github.com/sqlfluff/sqlfluff/pull/4764) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix 4603 indent after Jinja 'do' directive [4778](https://github.com/sqlfluff/sqlfluff/pull/4778) [fredriv](https://github.com/fredriv)
* Snowflake Execute Task with Schema [4771](https://github.com/sqlfluff/sqlfluff/pull/4771) [Thashin](https://github.com/Thashin)
* SQLite: Support CreateTrigger [4767](https://github.com/sqlfluff/sqlfluff/pull/4767) [WittierDinosaur](https://github.com/WittierDinosaur)
* Fix 2865 (AL05 exception for Redshift Semi-structured) [4775](https://github.com/sqlfluff/sqlfluff/pull/4775) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix 4540: Untaken indents evaluation order. [4768](https://github.com/sqlfluff/sqlfluff/pull/4768) [alanmcruickshank](https://github.com/alanmcruickshank)
* Use the new CollationReferenceSegment everywhere [4770](https://github.com/sqlfluff/sqlfluff/pull/4770) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* SQLite: Fix multiple parse issues in Expression_A_Grammar [4769](https://github.com/sqlfluff/sqlfluff/pull/4769) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* SQLite: Remove refs to RESPECT and QUALIFY [4765](https://github.com/sqlfluff/sqlfluff/pull/4765) [WittierDinosaur](https://github.com/WittierDinosaur)
* SQLite: Support STRICT [4766](https://github.com/sqlfluff/sqlfluff/pull/4766) [WittierDinosaur](https://github.com/WittierDinosaur)
* Support hive set syntax [4763](https://github.com/sqlfluff/sqlfluff/pull/4763) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix 4582: Comments after end of line [4760](https://github.com/sqlfluff/sqlfluff/pull/4760) [alanmcruickshank](https://github.com/alanmcruickshank)
* Allow comment match with preceding line [4758](https://github.com/sqlfluff/sqlfluff/pull/4758) [alanmcruickshank](https://github.com/alanmcruickshank)
* Remove the majority of greedy matchers [4761](https://github.com/sqlfluff/sqlfluff/pull/4761) [WittierDinosaur](https://github.com/WittierDinosaur)
* Fix 4745: (max() error in reindent) [4752](https://github.com/sqlfluff/sqlfluff/pull/4752) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix issue with macros triggering LT01 [4757](https://github.com/sqlfluff/sqlfluff/pull/4757) [alanmcruickshank](https://github.com/alanmcruickshank)
* end-of-file > end_of_file [4753](https://github.com/sqlfluff/sqlfluff/pull/4753) [alanmcruickshank](https://github.com/alanmcruickshank)

Highlights

This is a relatively swift bugfix to refine some of the changes made to
widow function indentation in `2.0.4`. In addition there are two dialect
refinements also made since that release.

What’s Changed

* Refactor PG segments to reuse new common segments [4726](https://github.com/sqlfluff/sqlfluff/pull/4726) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)
* Recognize quoted data types [4747](https://github.com/sqlfluff/sqlfluff/pull/4747) [james-johnston-thumbtack](https://github.com/james-johnston-thumbtack)