Support for row values comparisons

[j30ng]

Hi, I'm trying to do something like below to implement keyset pagination

SELECT * FROM contacts
WHERE (lastname,firstname) > (?1,?2)
ORDER BY lastname, firstname
LIMIT 7;

(from https://www.sqlite.org/rowvalue.html#scrolling_window_queries)

What I basically need is an operator that allows comparing n-tuple columns to n-tuple values. Is there going to be a support for this? I actually wrote my own operators but if you guys can officially support this for types Pair(col1, col2) and Triple(col1, col2, col3) that'll be amazing.

[cy]

+1 to this, @j30ng maybe you could push your custom operator as a PR to the maintainers?

[j30ng]

Hi @cy, could definitely try that but this issue hasn't had much traction from the users or the maintainers, so I don't know how that will go.