Pluggable Templaters

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 SET statement #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