sqlfluff/sqlfluff 0.11.2

[0.11.2] - 2022-03-25

on GitHub

What’s Changed

• Added Support For Snowflake Inline Comments (#2919) @WittierDinosaur
• Spark3: Fix bug which did not allow multiple joins (#2917) @tunetheweb
• Added Snowflake Alter View Support (#2915) @WittierDinosaur
• Adjust L010 to ignore nulls and booleans covered by L040 (#2913) @tunetheweb
• Fix bug where L043 corrupts SQL (#2908) @barrywhart
• Jinja: Add support for Block Assignments (#2907) @barrywhart
• L042 fix fails with missing function get_identifier() on Postgres, Redshift dialects (#2899) @barrywhart
• BigQuery: Better Set Operators support (#2901) @tunetheweb
• Hive: support for complex types in cast rowtype definition (#2896) @KulykDmytro
• Hive: added json type support (#2894) @KulykDmytro
• Hive: fix incorrect L027 error for rowtype attribute name (#2893) @KulykDmytro
• Hive: Add ARRAY support (#2891) @tunetheweb
• Implemented PIVOT/UNPIVOT Redshift + Fixed Snowflake Bug + Standardized PIVOT/UNPIVOT Parsing (#2888) @PLBMR
• Fix AssertionError in dbt templater when file ends with multiple newlines (#2887) @barrywhart
• Hive: Row typecasting in cast function (#2889) @KulykDmytro
• dbt templater should gracefully skip macro files (#2886) @barrywhart
• Disable L031 on BigQuery due to complex backtick / project name behavior (#2882) @barrywhart
• Documentation: Update dbt templater docs with more detail about pros and cons (#2885) @barrywhart
• BigQuery: Better STRUCT Array Support (#2881) @tunetheweb
• L042: Detect violations when column is templated (#2879) @barrywhart
• Improve parsing of BETWEEN statements (#2878) @MarcAntoineSchmidtQC