Table Joins in weweb

I have a collection which is a view and in that view there is data coming from 2 tables.
i wanted to ask if we can create view in configuration step of the collection or in weweb instead of making the view in supabase because it makes the fetching step from supabase too slow because the data is 1.5 million, so what i want to ask is if weweb provides us with a step in which we can manually join the tables in weweb instead of supabase or just create a view in weweb

You can do this, but it is not well documented on either the WeWeb’s side and neither on the Supabase’s side I made it work some time back, but it is not really as straightforward.

thanks i’ll look into it