Is there a way to run multiple selects on multiple tables with one request? I don't mean related data, completely separate tables

The only way to achieve this is with a stored procedure/function defined in the database (you can then invoked it with the supabase.rpc() method)

Thanks