dataform format fails on case/between statements

[spatel11]

The following Definition

config {
  "type": "table"
}

SELECT CASE 
        WHEN 1 BETWEEN 2 AND 3 THEN 'test1'
        ELSE 'test2'
        END

Will result in a formatting error:

definitions/Between.sqlx: Unable to format "config {
  "type": "...".

when dataform format is run.
I'm using the bigquery warehouse type, but other types that I tried (redshift, snowflake) also failed on this definition.

The definition does compile however, and it's a valid query (at least according to bigquery)

An alternative formulation:

config {
  "type": "table"
}

SELECT CASE 
        WHEN 1 >= 2 AND 1 <= 3 THEN 'test1'
        ELSE 'test2'
        END

formats successfully.

[Ekrekr]

I think this is a bug in the SQL formatter that we use - and the error it gives isn't very helpful for that.

I'm in the process of open sourcing the GoogleSQL definition and formatter, to replace the current SQL formatter, which should fix this! If not, I'll take a look then.