Sqlfluff

- Allow for variables in the configuration setting.

- Do not show error if ignored file does not lint.

- Add postgres as a language option. Thanks to frederikaalund's [Pull Request](https://github.com/sqlfluff/vscode-sqlfluff/pull/77)

Highlights

This release brings some meaningful performance improvements to the parsing of
complex SQL statements. In files with deeply nested expressions, we have seen
up to a 50% reduction on time spent in the parsing phase. These changes are all
internal optimisations and have minimal implications for the parser. In a few
isolated cases they did highlight inconsistencies in the parsing of literals
and so if your use case relies on the specific structure of literal and
expression parsing you may find some small differences in how some expressions
are parsed.

Additionally this release brings new validation steps to configuration.
Layout configuration is now validated on load (and so users with invalid
layout configurations may see some of these being caught now) and inline
configuration statements in files are also now validated for both their
layout rules and for any removed or deprecated settings.

On top of both we've seen dialect improvements to Databricks, PostgreSQL,
BigQuery, Snowflake & Athena.

What’s Changed

* Databricks set time zone [5000](https://github.com/sqlfluff/sqlfluff/pull/5000) [greg-finley](https://github.com/greg-finley)
* Terminator inheritance [4981](https://github.com/sqlfluff/sqlfluff/pull/4981) [alanmcruickshank](https://github.com/alanmcruickshank)
* Reduce copying in the parse phase [4988](https://github.com/sqlfluff/sqlfluff/pull/4988) [alanmcruickshank](https://github.com/alanmcruickshank)
* Validate layout configs 4578 [4997](https://github.com/sqlfluff/sqlfluff/pull/4997) [alanmcruickshank](https://github.com/alanmcruickshank)
* Fix handling of keywords for roles in ALTER ROLE statement [4994](https://github.com/sqlfluff/sqlfluff/pull/4994) [anzelpwj](https://github.com/anzelpwj)
* BigQuery: fixes parse error on some literals with data type and quoted [4992](https://github.com/sqlfluff/sqlfluff/pull/4992) [yoichi](https://github.com/yoichi)
* Correct Snowflake `CROSS JOIN` syntax [4996](https://github.com/sqlfluff/sqlfluff/pull/4996) [tunetheweb](https://github.com/tunetheweb)
* Remove broken 'fork me' banner from docs [4989](https://github.com/sqlfluff/sqlfluff/pull/4989) [greg-finley](https://github.com/greg-finley)
* feat: support athena optional WITH ORDINALITY post UNNEST function [4991](https://github.com/sqlfluff/sqlfluff/pull/4991) [reata](https://github.com/reata)

Highlights

This release is a fairly standard incremental release. Highlights include bugfixes
to `RF05` and dialect improvements to Snowflake, Teradata, MySQL, TSQL, SparkSQL & Postgres.

Internally, the last few weeks have brought several improvements to developer tooling.

We've also moved over to GitHub sponsorships - so if you previously used the old
flattr link, you can find our new profile page at https://github.com/sponsors/sqlfluff.

What’s Changed

* Add the which dbt flag to DbtConfigArgs with default as "compile" [4982](https://github.com/sqlfluff/sqlfluff/pull/4982) [moreaupascal56](https://github.com/moreaupascal56)
* feat: support tsql COPY INTO [4985](https://github.com/sqlfluff/sqlfluff/pull/4985) [reata](https://github.com/reata)
* fix: sparksql lateral view parse tree for multiple column alias [4980](https://github.com/sqlfluff/sqlfluff/pull/4980) [reata](https://github.com/reata)
* Revert "Ignore click mypy issues" [4967](https://github.com/sqlfluff/sqlfluff/pull/4967) [greg-finley](https://github.com/greg-finley)
* Snowflake: Parse column named cross [4975](https://github.com/sqlfluff/sqlfluff/pull/4975) [greg-finley](https://github.com/greg-finley)
* Snowflake: Group by all [4976](https://github.com/sqlfluff/sqlfluff/pull/4976) [greg-finley](https://github.com/greg-finley)
* Update funding yaml to use github sponsors [4973](https://github.com/sqlfluff/sqlfluff/pull/4973) [alanmcruickshank](https://github.com/alanmcruickshank)
* Added DEL keyword [4962](https://github.com/sqlfluff/sqlfluff/pull/4962) [dflem97](https://github.com/dflem97)
* Remove mypy ignores [4972](https://github.com/sqlfluff/sqlfluff/pull/4972) [greg-finley](https://github.com/greg-finley)
* Allow running one rule test locally [4963](https://github.com/sqlfluff/sqlfluff/pull/4963) [greg-finley](https://github.com/greg-finley)
* Postgres support underscore array data type syntax [4959](https://github.com/sqlfluff/sqlfluff/pull/4959) [greg-finley](https://github.com/greg-finley)
* Bump issue-labeler [4958](https://github.com/sqlfluff/sqlfluff/pull/4958) [greg-finley](https://github.com/greg-finley)
* Standardize test fixture names [4955](https://github.com/sqlfluff/sqlfluff/pull/4955) [greg-finley](https://github.com/greg-finley)
* RF05 BigQuery empty identifier bug [4953](https://github.com/sqlfluff/sqlfluff/pull/4953) [keitherskine](https://github.com/keitherskine)
* New GitHub issue labeler library [4952](https://github.com/sqlfluff/sqlfluff/pull/4952) [greg-finley](https://github.com/greg-finley)
* Ignore click mypy issues [4954](https://github.com/sqlfluff/sqlfluff/pull/4954) [greg-finley](https://github.com/greg-finley)
* MySQL: Rename index [4950](https://github.com/sqlfluff/sqlfluff/pull/4950) [greg-finley](https://github.com/greg-finley)
* Adding support to ALTER TABLE with RENAME COLUMN on MySQL dialect [4948](https://github.com/sqlfluff/sqlfluff/pull/4948) [jrballot](https://github.com/jrballot)


New Contributors
* [jrballot](https://github.com/jrballot) made their first contribution in [#4948](https://github.com/sqlfluff/sqlfluff/pull/4948)
* [keitherskine](https://github.com/keitherskine) made their first contribution in [#4953](https://github.com/sqlfluff/sqlfluff/pull/4953)
* [reata](https://github.com/reata) made their first contribution in [#4980](https://github.com/sqlfluff/sqlfluff/pull/4980)

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)