Support Snowflake SQL Pivot Command

Hi All,

a lot of new Snowflake commands do not work within the Query Console of the Database plugin.

The following SQL code snippet ist taken from
PIVOT | Snowflake Documentation
It works in Snowflake's IDE Snowsight, but not in Pycharm. 

I am using professional Edition version 2024.1..

Please note, that i know multiple other commands, that are not being executed or highlighted by Pycharm.
I would love, if Pycharm would do regular updates forthe  Snowflake SQL dialect.

CREATE OR REPLACE TEMP TABLE quarterly_sales(
  empid INT,
  amount INT,
  quarter TEXT)
  AS SELECT * FROM VALUES
    (1, 10000, '2023_Q1'),
    (1, 400, '2023_Q1'),
    (2, 4500, '2023_Q1'),
    (2, 35000, '2023_Q1'),
    (1, 5000, '2023_Q2'),
    (1, 3000, '2023_Q2'),
    (2, 200, '2023_Q2'),
    (2, 90500, '2023_Q2'),
    (1, 6000, '2023_Q3'),
    (1, 5000, '2023_Q3'),
    (2, 2500, '2023_Q3'),
    (2, 9500, '2023_Q3'),
    (1, 8000, '2023_Q4'),
    (1, 10000, '2023_Q4'),
    (2, 800, '2023_Q4'),
    (2, 4500, '2023_Q4');


SELECT *
  FROM quarterly_sales
    PIVOT(SUM(amount) FOR quarter IN (ANY ORDER BY quarter))
  ORDER BY empid;