The current patch supports the following syntaxes: SELECT a, b, c wf() OVER () as d FROM tab QUALIFY d = 1 When using the "QUALIFY d = 1" form, I currently rewrite the expression as "wf() OVER () = 1" by searching the targetlist for the matching alias, replacing the Var with the corresponding WindowFunc.
Not related to $subject but that way you did,
that replacement alias for wf expression, is cool.
With that would it be possible to have where replacements too ? Maybe.
