[FORMATTING] Formatter doesn't like the ~ in SQL statement

[zjpersc]

Input data

Which SQL and options did you provide as input?

SELECT bar, foo FROM foo_bar WHERE customer_prefix_name ~ '^.*\\d{9}.*$' GROUP BY bar

Expected Output

SELECT
  bar,
  foo
FROM
  foo_bar
WHERE
  ~ customer_prefix_name '^.*\\d{9}.*$'
GROUP BY
  bar

Actual Output

Parse error: Unexpected "~ '^.*\\d{" at line 1 column 57.
This likely happens because you're using the default "sql" dialect.
If possible, please select a more specific dialect (like sqlite, postgresql, etc).

Usage

• How are you calling / using the library? Included as part of a toolbox plugin for Backstage: https://github.com/drodil/backstage-plugin-toolbox

• What SQL language(s) does this apply to? Redshift

• Which SQL Formatter version are you using? Tried w v13.1.0 and v15.3.1

[nene]

It works fine. Just select "redshift" dialect, not the default "sql" one, like the error message suggests to you. FAQ.

I don't know how to do that in this drodil/backstage-plugin-toolbox, you'll need to figure this out on your own or ask from the developers of that plugin.