is it possible to run arbitrary select requests using the supabase-js client? the sql-editor within the supabase app seems to support any type of query. but an 'x-connection-encrypted' header is required to make the calls. i'm trying to create a complex query with joins, filtering by joined columns and to order the results from a foreign table column. how do other people perform complex queries?

You can create a view or rpc in the db and then call that from your js.

thank you. i think multiple views looks to be the answer!