Array type with windowing like functionality?

[thadguidry]

Not sure if windowing is the right analogy. I was reading through notes on a recent merge in DuckDB and saw potentially some useful ideas that might be added to OjG to optimize on nested data through Arrays. I am not sure of what or all of the capabilities listed in the merge therein but wanted to use this issue to ask the question of "any useful ideas here that OjG can incorporate or in the future?"

Helping OjG becoming even faster with nested data.

duckdb/duckdb#8983

[ohler55]

This is probably more of a discussion item but I'll take a look.

[thadguidry]

You can convert it to a discussion indeed. GitHub has a way to do that now I think.