I am looking into the possibility of using row value constructors for paging through data. The query would be of the form
SELECT * FROM t WHERE (pk1, pk2) > (2,'bar'); which should logically be equivalent to SELECT * FROM t WHERE pk1 > 2 OR (pk1=2 AND pk2>'bar') I found a previous thread where this was discussed [1]. Does anyone know the scope of work it would take to support this feature in Calcite? [1] https://lists.apache.org/thread.html/8d3154f6a636972777493d176b9bbaa69ab957145470135a0a13a1b3@1419906719@%3Cdev.calcite.apache.org%3E
