Highlights
This release is less about internals and much more about some quality of life improvements and dialect changes. The most notable are:
- The introduction of a
sqlfluff rendercommand to preview the results of templated sql. - Linting errors within templated loops should now only appear once in the linting output.
- Indentation around jinja
{% set %}statements should now be more consistent. - Linting errors around unparsable code are now more appropriately handled (with more to come soon on that front).
- Error messages when specified files aren't found are now more specific.
We've also got dialect improvements for Redshift, SOQL & SparkSQL.
What’s Changed
- Fix type error in
get_ruleshook of plugin example (#4060) @Samyak2 - L003: Add missing "pragma: no cover" (#4058) @barrywhart
- Fix bug in sparksql SELECT statement termination at UNION #4050 (#4052) @anna-azizian
- Deduplicate violations in the source space (#4041) @alanmcruickshank
- Use "docker compose", not "docker-compose" (#4055) @barrywhart
- Allow warnings for specific rules (#4053) @alanmcruickshank
- Better file not found error #1023 (#4051) @alanmcruickshank
- Filter out issues in unparsable sections (#4032) @alanmcruickshank
- Snowflake: ADD and DROP without COLUMN (#4049) @greg-finley
- Make render command (#4043) @alanmcruickshank
- Bump after_n_builds to 10 (#4046) @greg-finley
- Redshift: allows for parenthesis around FROM content (#3962) @adam-tokarski
- Update CI to use Python 3.11 (#4038) @greg-finley
- Classify self contained set statements as templated (#4034) @alanmcruickshank
- Date and Datetime literals in SOQL (#4037) @alanmcruickshank
- mypy edits for 0.990 (#4035) @alanmcruickshank
- sparksql: support for create/remove widget clause (#4021) @Coola4kov
- Redshift CREATE EXTERNAL FUNCTION statement (#4011) @rpr-ableton
- Update Redshift bare functions (#4012) @rpr-ableton