sqlfluff/sqlfluff 0.13.1

[0.13.1] - 2022-05-06

on GitHub

Highlights

Major changes include:

• Addition of "rule groups" (currently core and all) to allow ease of turning on and off groups of rules.
• Addition of db2 dialect
• PRS errors are now highlighted in red.
• Many bugs fixes and dialect improvements

What’s Changed

• Allow optional AS in MERGE statements using SELECT #3276 @tunetheweb
• Add groups each rule is in to Rules documentation #3272 @tunetheweb
• BigQuery: Enhanced EXPORT DATA statement #3267 @tunetheweb
• BigQuery: CREATE TABLE support for COPY and LIKE #3266 @tunetheweb
• Improve error on missing keywords #3268 @greg-finley
• MySQL: Add FLUSH support #3269 @greg-finley
• Postgres: Add ALTER TYPE support #3265 @greg-finley
• Bug fix: L036 handle single-column SELECT with comment on same line as SELECT keyword #3259 @barrywhart
• Put working example in the README #3261 @greg-finley
• Snowflake: Add CREATE FILE FORMAT Support #3104 @jmc-bbk
• Bug fix: Disable L059 in snowflake dialect #3260 @barrywhart
• Remove redundant Anything() from match_grammars #3258 @tunetheweb
• Postgres: Add DOMAIN support #3257 @tunetheweb
• T-SQL: Allow optional brackets with EXECUTE #3255 @pguyot
• Add rule groups and a core rules group #3142 @pwildenhain
• MySQL: Better UNSIGNED support #3250 @tunetheweb
• MySQL (and others): Support DROP TEMPORARY TABLE #3251 @tunetheweb
• Add Db2 dialect #3231 @ddresslerlegalplans
• BigQuery: Add CREATE EXTERNAL TABLE statement #3241 @dmohns
• SQLite: Add support for expressions in CREATE INDEX columns #3240 @tunetheweb
• Fix exception in check_still_complete and matching in StartsWith #3236 @tunetheweb
• Snowflake: Add Support for DROP Statements #3238 @chrisalexeev
• Allow YAML generation script to accept arguments when run through tox #3233 @tunetheweb
• Bug fix: Cleanly catch and report errors during load_macros_from_path #3239 @barrywhart
• Indent procedure parameters #3234 @fdw
• Enhance apply_fixes() to automatically fix violations of can_start_end_non_code #3232 @barrywhart
• T-SQL: Fix for xml path identifier #3230 @fdw
• SparkSQL: Additional Delta Merge Test Cases #3228 @R7L208
• Fix bug where L018 warns inappropriately if CTE definition includes a column list #3227 @barrywhart
• BigQuery: Better STRUCT support #3217 @tunetheweb
• Fix bug where L003 and L036 fixes caused a parse error #3221 @barrywhart
• Make IF EXISTS work with UNION selects #3218 @fdw
• Fix bug where the fix_even_unparsable setting was not being respected in .sqlfluff #3220 @barrywhart
• BigQuery: Better DELETE table support #3224 @tunetheweb
• Snowflake: ALTER MATERIALIZED VIEW statement #3215 @jmc-bbk
• BigQuery: recognise DATE, DATETIME and TIME as a date parts for EXTRACT #3209 @tunetheweb
• Postgres: enhanced UPDATE statement support #3203 @tunetheweb
• Prevent Date Constructors from being changed to double quotes by L064 #3212 @tunetheweb
• Postgres: Fix DROP EXTENSION syntax #3213 @tunetheweb
• Snowflake: Handle FLATTEN() table function aliases correctly in L025, L027, L028 #3194 @barrywhart
• Snowflake: Function LANGUAGE SQL #3202 @WittierDinosaur
• Postgres: Enhanced CREATE MATERIALIZED VIEW #3204 @tunetheweb
• T-SQL: Support basic FOR XML statements #3193 @fdw
• T-SQL: Fix cursor syntax #3192 @fdw
• Snowflake: REMOVE statement enhancement #3191 @jmc-bbk
• Snowflake: Moved VIEW to unreserved keywords #3190 @WittierDinosaur
• BigQuery: Support EXPORT DATA #3177 @tunetheweb
• T-SQL: Fix exception when using variable names in FROM clause #3175 @tunetheweb
• Fix bug where encoding setting in .sqlfluff file was not being respected #3170 @barrywhart
• Highlight PRS errors in red #3168 @OTooleMichael
• Remove unnecessary StartsWith and make terminator mandatory when using it #3165 @tunetheweb
• Postgres: Support Composite Types #3167 @tunetheweb
• T-SQL: Support opening, closing, deallocating and fetching cursors #3166 @fdw
• T-SQL: Add declaration of cursors #3164 @fdw
• Missed #3151 from CHANGELOG #3163 @tunetheweb
• Bug fix: L028 sometimes makes incorrect fix when there are subqueries #3156 @barrywhart
• T-SQL: Support OUTPUT INTO #3162 @fdw
• T-SQL: Add CREATE TYPE statement #3154 @fdw
• Hive: SupportTABLESAMPLE #3159 @barunpuri
• Hive: Support back quoted identifier and literal #3158 @barunpuri
• T-SQL: Add table hints to INSERT and DELETE #3155 @fdw

New Contributors

• @ddresslerlegalplans made their first contribution in #3231
• @greg-finley made their first contribution in #3261