Supabase - Is it possible to use JOIN statements from within the WeWeb Plugin?

Hello, I’m wondering whether I could make this query with the Supabase Plugin alone, or I need to do this with a PostgreSQL function and do a REST API request as I’m doing now, It would be great to have it in the Plugin, as we could use auth for RLS :slight_smile:

I think you should be able to do it through the advanced mode, by using this format to write the select :

I’ll try this out, could you send me the reference you took the screenshot from please? :slight_smile: Thanks @Alexis

Its the documentation of the SDK we used in our implementation => Supabase Javascript Client - Fetch data

2 Likes

You can also check the supabase documentation : WeWeb | Works With Supabase in the section “advanced mode”

1 Like

or you can create a view in supabase, and fetch this view

2 Likes