Lateral Joins

[relsunkaev]

Is your feature request related to a problem? Please describe.

ReadySet currently does not support lateral joins, which limits the ability to use correlated subqueries in certain SQL queries. We use a popular JavaScript library, Drizzle ORM, which relies on lateral subqueries for many of its relational queries. As a result, a significant number of our queries are not cacheable in ReadySet.

Describe the solution you’d like

It would be helpful if ReadySet supported lateral joins, allowing for correlated subqueries and more complex query patterns to be executed efficiently and cached.

Describe alternatives you’ve considered

Refactoring queries to avoid lateral join by not using the relational syntax for the ORM that we use. This is cumbersome significantly reduces the library's ergonomics.

[gvsg-rs]

@relsunkaev - thank you for the submission. We expect to work on lateral joins this quarter. I'll update this ticket when we start work on it.