QUALIFY is not supported

[joshbode]

The QUALIFY clause is not supported, giving the diagnostic error: INVALID_ARGUMENT: QUALIFY is not supported

WITH
  x AS (
    SELECT 1 id, 1 value
    UNION ALL
    SELECT 1 id, 2 value
    UNION ALL
    SELECT 2 id, 3 value
  )
SELECT
  *
FROM
  x
QUALIFY
  COUNT(1) OVER (PARTITION BY id) > 1

[joshbode]

Thank you!

[joshbode]

@kitagry - I'm still getting the error on version 0.2.1 (I also tried with the latest code on main):

❱ go install github.com/kitagry/[email protected]
...
❱ which bqls
/Users/josh/.local/share/go/bin/bqls
❱ bqls --version
bqls v0.0.0 (rev: /go1.23.3)

[kitagry]

I think this is related with google/zetasql#124. I'll fix it within a few days.

[joshbode]

No worries - thank you!

[joshbode]

It works! Thank you @kitagry :)