Hi! I want to implement ORDER BY WITH FILL [1] functionality. It is similar to time_bucket_gapfill and interpolate functions from timescaledb [2]. I didn't find a way to do it with existing functionality.
I have an idea to introduce a PostOrder RelNode and implement EnumerablePostOrder or extend existing Sort relnode, but it will require a lot of changes. Maybe someone knows a more elegant way to do it ? [1] https://clickhouse.com/docs/en/sql-reference/statements/select/order-by/#order-by-expr-with-fill-modifier [2] https://docs.timescale.com/api/latest/hyperfunctions/gapfilling-interpolation/time_bucket_gapfill
