Joins are not supported yet, but will be in the future
We’ve also looked into adding support for views. To make views work well with the row level security policies, we need the security_invoker feature of Postgres 15 (which is not out yet). Or we need to implement some kind of workaround.
For me, by the way, the views would be of greater benefit as I’d generally prefer writing queries directly in SQL rather than via the client library functions- I can execute them in a database tool of my choice, I can use various built-in functions, I’m less dependent on 3rd-party code, and users can’t see the queries I’m using if they dig into the code.