How to query data using a join table?

The official doc doesn't provide any examples in querying using a join table: https://supabase.com/docs/reference/javascript/select#query-foreign-tables

So I have two tables product and user which have many-to-many mapping relationship, and I have a third join table product_user which has three fields:
id
, product_id and
user_id
.

How do I get all products that belong to a certain user in javascript?

I found the same issue here: https://github.com/supabase/supabase/discussions/1080
It says it was a limitation in 2021 and we can only do client-side filtering, what about now?
GitHub
Hey folks! I have a question related to this discussion here and figured I'd break it out into it's own post. Basically, I'm using @kiwicopple 's suggestion to creat...
Performs vertical filtering with SELECT.
Was this page helpful?