I doubt it is novel. For example, ClickHouse has the WITH FILL modifier for ORDER BY: https://clickhouse.com/docs/en/sql-reference/statements/select/order-by#or

I doubt it is novel. For example, ClickHouse has the WITH FILL modifier for ORDER BY: https://clickhouse.com/docs/en/sql-reference/statements/select/order-by#order-by-expr-with-fill-modifier https://clickhouse.com/docs/en/sql-reference/statements/sele...