Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hey all, quick Q about joins and such. I have 3 tables: `users`, `groups` and `groups_users`. The last one is a table containing `userId`/`groupId` links, to join between them.
What would be the ideal queries to get "All users of group `i`" and "All groups of user `j`"?

I got a SQL query working that simply does the following:
```
SELECT *
FROM summoners summ
INNER JOIN group_summoner gs ON summ."summonerId" = gs."summonerId"
```
(summoners are kind of users)

But with the JS API I do the following:
```
const { data, error, status } = await this.supabaseClient
      .from<definitions['group_summoner']>('groups_summoners')
      .select(
        `
        *,
        summoners (
          name
   )`,
      )
      .eq('groupId', id)
```
and I get `Could not find a relationship between groups_summoners and summoners in the schema cache`

Not the same query I know, but seems to be a similar logic?

Here is my ideal query I think:
```
SELECT *
FROM summoners summ
INNER JOIN groups gr ON gr.id = 1
INNER JOIN group_summoner gs ON summ."summonerId" = gs."summonerId";
```

I managed to do it with something "simpler":
```
const { data, error, status } = await this.supabaseClient
      .from<definitions['groups']>('groups')
      .select(
        `
        *,
        summoners (
          name
        )
        `,
      )
      .eq('id', id);
```
I figure supabase/postgres knows how to follow the foreign key alone?

I feel there's some magic happening and would like to understand more :/ <@!107176742342402048>

Under the hood the Supabase library is using postgrest for its querying mechanisms, you can read more about how it handles relationships on their website https://postgrest.org/en/v9.0/api.html?highlight=relationships#embedding-through-join-tables

That's pretty cool! Thanks for the info 🎉