[FORMATTING] Missing support for Snowflake lambda operator

[datarttu]

-> operator in Snowflake SQL dialect is currently formatted into - >. See Snowflake Lambda expressions for background.

Input data

Which SQL and options did you provide as input?

SELECT FILTER(some_array_of_objects_with_int_value, a -> a:value >= 50) AS "Filter >= 50";

Expected Output

SELECT
  FILTER (
    some_array_of_objects_with_int_value,
    a -> a:value >= 50
  ) AS "Filter >= 50";

Actual Output

SELECT
  FILTER (
    some_array_of_objects_with_int_value,
    a - > a:value >= 50
  ) AS "Filter >= 50";

Usage

• How are you calling / using the library? - SQL Formatter VSCode / format-on-save
• What SQL language(s) does this apply to? - Snowflake SQL
• Which SQL Formatter version are you using? - SQL Formatter VSCode v4.1.2 which uses sql-formatter v15.4.3

[datarttu]

Could this be fixed with an addition to supported operators and related test(s)?

// https://docs.snowflake.com/en/user-guide/querying-semistructured#lambda-expressions
'->'

Unfortunately I don't currently have Node / ts environment set up to test my suggestion locally, but I'm happy to help in any way I can.

[nene]

Thanks for reporting. Yes, that would have been the fix to make.

[nene]

Released the fix in sql-formatter 15.4.5 and vscode plugin 4.1.3.

[datarttu]

Works like a charm. Thank you so much! 🎉