Hi guys, I think that I’m going crazy, there is something about the doc that I must not understand correctly. How would you convert this query

SELECT urls.id, urls.name, array_agg(tags) as tags
    from urls
    join urls_tags on urls.id = urls_tags.url_id
    join tags on tags.id = urls_tags.tag_id
    group by urls.id

To a supabase query ? I came up with that but it’s not complete:

await db.from(`urls_tags`).select(`urls:url_id ( id, name ), tags:tag_id ( id, name )`)

You can create a view from your query and query it the same as you would a table

Thank you !

you need to put your SQL query into a function

CREATE FUNCTION my_function ...
<your query here>

then

supabase.rpc('my_function')

For what you are after here a view is probably a better option

Thanks guys