Best way to perform complex queries?
I have a query that I don't think the supabase-js client can perform directly:
It seems the recommended solution is to put the query in a postgress function and call it with the supabase client's
I could connect directly to the database (eg with the node-postgres library) and run the query that way. Is there a downside to this? The action is performed by the server with the service key so RLS is irrelevant for me.
select * from worksheet where id in (select worksheet from "profilesWorksheet" where profile = 'some-id')It seems the recommended solution is to put the query in a postgress function and call it with the supabase client's
rpcI could connect directly to the database (eg with the node-postgres library) and run the query that way. Is there a downside to this? The action is performed by the server with the service key so RLS is irrelevant for me.
