Possible to do JOIN operations?

[laznic]

Hey there!

I'm currently evaluation Supabase for my new project and while everything has been great so far, I've got stuck wondering if it's possible to do JOIN operations or run raw SQL queries with the supabase-js client? Or maybe there already is a supabase-way of doing this, which I have missed?

Ideally I'd want to store an array of IDs in a table row, and then do a JOIN with them to fetch some extra data from another table.

For example, if I have orders and products tables, I'd like to store a list of product IDs in a column called items in a orders table row. Then when fetching order data, I'd like to display the product names instead of the IDs I've added in the database.

EDIT: I just realized I could've searched the earlier discussions to see if someone had asked this before 😅 Sorry for the duplicate issue, the day is obviously getting too late for me! Feel free to answer this, though. Few other discussions related to this:

• foreign key queries for multiple rows from another table #1100
• Implementing many-to-many relationships with the UI #710
• Filtering on many-to-many relationship with join table #1080