Hello, I have kinda theoretical question. But it should help to understand overall Calcite's possibility.
Suppose there is some abstract format/table, which supports only
sorting by one column.
Let's say there is next query passed to calcite:
select * from table order by id
Is it possible to rewrite query tree so it will change this request into this?
select * from table
In this way after logical query rewrite Calcite should not be
concerned about sorting at all.
