BREAKING CHANGE
This release extracts the dbt templater to a seperately installable plugin sqlfluff-templater-dbt. For users who take advantage of the dbt templater see the updated docs on how to migrate. It also adds the redshift dialect and removes the exasol_fs dialect which has been merged into the exasol dialect.
What’s Changed
- src/sqlfluff/core/linter: Improve ignore file processing #1650 @CyberShadow
- Misc documentation updates #1644 @tunetheweb
- Segregate dbt plugin tests #1610 @alanmcruickshank
- Add initial Redshift support #1641 @tunetheweb
- Update docs for dbt templater, improve error messages when not installed. #1583 @alanmcruickshank
- Make templaters pluggable and move the dbt templater into a plugin #1264 @alanmcruickshank
🚀 Enhancements
- TSQL: CTAS delimiter #1652 @jpers36
- TSQL: Allow for multiple variables DECLAREd in the same statement #1651 @jpers36
- TSQL: Allow DECLARE/SET statements to parse using ExpressionStatement #1649 @jpers36
- TSQL PRINT statement parsing #1648 @jpers36
- Better date function for tsql #1636 @tunetheweb
- TSQL: Allow for multiple statements in a procedure #1637 @jpers36
- TSQL: Allow for !>, !< operators #1640 @jpers36
- TSQL: Fix GROUP BY delimiter #1635 @jpers36
- TSQL: Fix DROP delimiter #1633 @jpers36
- TSQL: +RENAME statement for Azure Synapse Analytics #1631 @jpers36
- TSQL: Fix CASTing variables #1627 @jpers36
- Snowflake: Add implementation for CREATE TASK statement #1597 #1603 @JoeHut
- Allow global config for rule testcases #1580 @sti0
- Snowflake dollar sign literals #1591 @myschkyna
- Rename test/fixtures/parser directory to test/fixtures/dialects #1585 @tunetheweb
- Rename keyword files #1584 @tunetheweb
- Add some more unreserved keywords to BigQuery #1588 @tunetheweb
- Increase minimum runs before coverage report is issued #1596 @tunetheweb
- Snowflake: Support CURRENT_TIMESTAMP as a column default value #1578 @wong-codaio
- TSQL temp tables #1574 @jpers36
🐛 Bug Fixes
- Fix NoneType exception in L031 #1643 @tunetheweb
- Stop rule L048 complaining if literal is followed by a semicolon #1638 @tunetheweb
- L031 desc updated to cover both 'from' and 'join' #1625 @nevado
- Snowflake auto increments fixes #1620 @myschkyna
- Fix DECLARE Delimitation #1615 @jpers36
- Snowflake drop column fixes #1618 @myschkyna
- TSQL: fix statement delimitation #1612 @jpers36
- Snowflake: Fixed data type casting not working in
SETstatement #1604 @wong-codaio - Postgres dialect: Fix parse error for "on delete", "on update" clauses in column constraints #1586 @samlader
- Fix AttributeError: 'NoneType' object has no attribute 'get_child' error with rule L031 #1595 @barrywhart
- Fix zero length templated file bug. #1577 @alanmcruickshank
- Fully remove exasol_fs dialect and bump version #1573 @alanmcruickshank