sqlfluff/sqlfluff 0.11.1

[0.11.1] - 2022-03-17

on GitHub

Highlights

Major changes include:

• A number of changes to fix code to make these more robust
• Improvements to templating blocks
• generate_parse_fixture_yml options to allow quicker, partial regeneration of YML files
• Numerous rule fixes including adding auto fix to L042
• Numerous grammar changes

What's Changed

• Spark3: Support for SHOW statements #2864 @R7L208
• Add Markerr to list of organizations using SQLFluff in the wild #2874 @kdw2126
• Refactor JinjaTracer: Split into two classes, break up _slice_template() function #2870 @barrywhart
• BigQuery: support Parameterized Numeric Literals #2872 @tunetheweb
• L042 autofix #2860 @OTooleMichael
• Redshift: transaction statement #2852 @rpr-ableton
• JinjaTracer fix for endif/endfor inside "set" or "macro" blocks #2868 @barrywhart
• L009: Handle adding newline after {% endif %} at end of file #2862 @barrywhart
• Redshift: Add support for AT TIME ZONE #2863 @tunetheweb
• L032 bug fix and fix improvement #2859 @OTooleMichael
• Refactor JinjaTracer; store lex output as individual strings where possible #2856 @barrywhart
• Add ability to regenerate subsets of fixture YAMLs (by dialect, or new only) #2850 @OTooleMichael
• Fix bug with Jinja and dbt {% set %} blocks #2849 @barrywhart
• Bug fix: ValueError: Position Not Found for lint/parse/fix in JinjaTracer #2846 @barrywhart
• Reduce unnecessary setting run ci #2847 @zhongjiajie
• Spark3: statements to SET and RESET spark runtime configurations #2839 @R7L208
• BigQuery - prevent L006 flagging hyphenated table references #2842 @tunetheweb
• TSQL fix CONVERT function definition #2843 @tunetheweb
• Change rule test script from bash to python #2840 @OTooleMichael
• Spark3: Support DESCRIBE statement #2837 @R7L208
• Spark3: Refactor REFRESH statements into one class #2838 @R7L208
• Prevent rules incorrectly returning conflicting fixes to same position #2830 @barrywhart
• Redshift and BigQuery: Update dateparts values and functions #2829 @rpr-ableton
• MySQL add NOW support #2825 @tunetheweb
• MySQL DELETE FROM support #2823 @tunetheweb
• Rule L059 bug with IF #2824 @tunetheweb
• Prevent exceptions when running fix on dialect fixtures #2818 @tunetheweb
• Spark3: Support to handle CACHE AND UNCACHE auxiliary statements #2814 @R7L208
• Fix L036 error on CREATE VIEW AS SELECT #2816 @tunetheweb
• Fixes for the new post-fix parse check #2813 @barrywhart
• Add initial MERGE syntax to most dialects #2807 @PhilippLange
• Automated tests should fail if a lint fix introduces a parse error #2809 @barrywhart

New Contributors

• @kdw2126 made their first contribution in #2874