[FORMATTING] QUALIFY for AWS Redshift

[KlingonDragon]

Input data

Which SQL and options did you provide as input?

CREATE TEMP TABLE user_activity AS (
    SELECT
        scenario,
        week,
        selection,
        edit_timestamp
    FROM
        raw_user_activity
    WHERE
        scenario NOT IN ('test_scenario')
        QUALIFY ROW_NUMBER() OVER (
            PARTITION BY scenario,
            week
            ORDER BY
                edit_timestamp DESC
        ) = 1
);

Expected Output

CREATE TEMP TABLE user_activity AS (
    SELECT
        scenario,
        week,
        selection,
        edit_timestamp
    FROM
        raw_user_activity
    WHERE
        scenario NOT IN ('test_scenario')
    QUALIFY
        ROW_NUMBER() OVER (
            PARTITION BY
                scenario,
                week
            ORDER BY
                edit_timestamp DESC
        ) = 1
);

Actual Output

CREATE TEMP TABLE user_activity AS (
    SELECT
        scenario,
        week,
        selection,
        edit_timestamp
    FROM
        raw_user_activity
    WHERE
        scenario NOT IN ('test_scenario') QUALIFY ROW_NUMBER() OVER (
            PARTITION BY scenario,
            week
            ORDER BY
                edit_timestamp DESC
        ) = 1
);

Usage

• How are you calling / using the library?
  • Both VSCode and Online
• What SQL language(s) does this apply to?
  • Redshift
• Which SQL Formatter version are you using?
  • ReneSaarsoo.sql-formatter-vsc v4.1.9
  • https://sql-formatter-org.github.io/sql-formatter/ v15.6.1

[nene]

Thanks for reporting, fixed in v15.6.2

[nene]

Also released new version (4.2.0) of the VSCode extension.