Sqlfluff

- Allow for variables in the working directory setting.

- 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)