Sqlfluff

Added

- Respect XDG base dirs on Mac OS ([889](https://github.com/sqlfluff/sqlfluff/issues/889)).
- Added support for additional delimiters by creating a new DelimiterSegment in the
ANSI dialect which defaults to the semicolon, but allows it to be more intuitive
when overridden in a specific child dialect (mysql) [901](https://github.com/sqlfluff/sqlfluff/issues/901))
- Added support for the DELIMITER statement in the mysql dialect [901](https://github.com/sqlfluff/sqlfluff/issues/901))
- Added support for additional delimiters by creating a new DelimiterSegment in the
ANSI dialect which defaults to the semicolon, but allows it to be more intuitive
when overridden in a specific child dialect (mysql) [901](https://github.com/sqlfluff/sqlfluff/issues/901))
- Added support for function as a default column value [849](https://github.com/sqlfluff/sqlfluff/issues/849).
- Add an `--include-metas` option for parse output to show the meta
segments in the parse tree.
- Allow CREATE FUNCTION syntax without arguments [bolajiwahab](https://github.com/bolajiwahab) [#1063](https://github.com/sqlfluff/sqlfluff/pull/1063).
- Added support for the CREATE/DROP PROCEDURE statement for the mysql dialect [901](https://github.com/sqlfluff/sqlfluff/issues/901))
- Added specific allowed/required syntaxes for CREATE/DROP FUNCTION within the mysql dialect [901](https://github.com/sqlfluff/sqlfluff/issues/901))
- Now possible to run sqlfluff commands outside the project root when using the dbt templater.

Changed

- Renamed --parallel CLI argument to --processes to be more accurate.
- L034 now ignores select statements which contain macros.
- L034 now ignores select statements part of a set expression, most commonly a union.
- Fix bug [1082](https://github.com/sqlfluff/sqlfluff/issues/1082), adding
support for BigQuery `select as struct '1' as bb, 2 as aa` syntax.
- Rationalisation of the placement of meta segments within templated
queries to support more reliable indentation. This includes prioritising
_longer_ invariant sections first and then dropping any shorter ones
which then are relatively out of place.
- Additional logging within the lexer and templater engines.
- Allow meta segments to parse within `Delimited` grammars which otherwise
don't allow gaps. This is facilitated through an optional argument to
`trim_non_code_segments`.
- Fix bug [1079](https://github.com/sqlfluff/sqlfluff/issues/1079), addressing
issues with L025 and L026 with BigQuery column references involving `STRUCT`.
- [1080](https://github.com/sqlfluff/sqlfluff/issues/1080) Add
SET SCHEMA and DROP SCHEMA support to ANSI dialect.

Contributors

- [bolajiwahab](https://github.com/bolajiwahab) ([#1063](https://github.com/sqlfluff/sqlfluff/pull/1063))
- [silverbullettruck2001](https://github.com/silverbullettruck2001) ([#1126](https://github.com/sqlfluff/sqlfluff/pull/1126), [#1099](https://github.com/sqlfluff/sqlfluff/pull/1099), [#1141](https://github.com/sqlfluff/sqlfluff/pull/1141))

Changed

- Better exception handling for the simple parsing API (`sqlfluff.parse`)
which now raises an exception which holds all potential parsing issues
and prints nicely with more than one issue.
- Fix bug [1037](https://github.com/sqlfluff/sqlfluff/issues/1037), in which fix
logging had been sent to stdout when reading data from stdin.
- Add a little bit of fun on CLI exit 🎉!
- Disabled models in the dbt templater are now skipped entirely rather than
returning an untemplated file.
- Add a changelog check to SQLFluff continuous integration.
- Fix bug [1083](https://github.com/sqlfluff/sqlfluff/issues/1083), adding
support for BigQuery named function arguments, used with functions such as
[ST_GEOGFROMGEOJSON()](https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfromgeojson)
- Update documentation links to sqlfluff-online.

Added

- Lint and fix parallelism using `--parallel` CLI argument
- Fix [1051](https://github.com/sqlfluff/sqlfluff/issues/1051), adding support
for bitwise operators `&`, `|`, `^`, `<<`, `>>`

- Bugfix release for an issue in `L016` introduced in `0.5.4`.
- Fix for `L016` issue where `DISTINCT` keywords were mangled during
fixing [1024](https://github.com/sqlfluff/sqlfluff/issues/1024).

- Bugfix release for an off-by-one error introduced in L016 as part of `0.5.4`.

Added

- Parsing of Postgres dollar quoted literals.
- Parsing of Postgres filter grammar.
- Parsing of "ALTER DEFAULT PRIVILEGES" Postgres statement.
- Parsing of Postgres non-explicit role granting and function execution.
- Early failing on fatal dbt templater fails.

Changed

- Big rewrite of the lexer, segments and position markers for simplicity
and to support future parallelism work.
- Fix to L036 which previously mangled whitespace.