It would be good to have this as a feature. Are you proposing to fully implement the feature (I.e. add to parser, validator, and Enumerable convention, so that we can execute such queries) or just add it to the parser?
I think our users might be confused or frustrated if the parser supports the syntax but we cannot execute it. Julian > On Jul 16, 2023, at 10:35 AM, Itiel Sadeh <[email protected]> > wrote: > > Hello All, > PostgreSQL supports "frame exclusion" in window function, e.g.: "SELECT > sum(x) OVER (PARTITION BY y ORDER BY z ROWS BETWEEN UNBOUNDED PRECEDING and > UNBOUNDED FOLLOWING EXCLUDE CURRENT ROW) from t", (you can see here > <https://www.postgresql.org/docs/current/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS>) > which let you ignore some rows from the selected scope. > Calcite however does not support it. > Can I add it to the parser? Do we use conformance for such cases or other > mechanisms? > > Thanks, > Itiel
