Supabase JavaScript data fetching with nested select

Question

I am new to supabase and data fetching via supabase-js client.

When I have the tables below and I have to fetch votes and additionally data from the result and club table, how does this work? Respectively is it possible to have nested selects? Unfortunately I could not find an example in https://supabase.com/docs/guides/api/joins-and-nesting or https://supabase.com/docs/reference/javascript/select.

From Prisma I know it can be realized with nested includes as described here. Is this possible in supabase too?

Voting table

id	title	result_id
1	Voting title 1	1
2	Voting title 2	2

Result table

id	yes	no	club_id
1	300	406	1
2	21	12	2
2	265	201	3

Club table

ey dee ey em · Accepted Answer · 2024-06-23 02:40:22Z

4

There is an example for querying nested tables in the docs that you liked right here. https://supabase.com/docs/guides/database/joins-and-nesting

You can query them like this:

const {data, error} = await supabase.from('votes').select('*, results(*, clubs(*))')

ey dee ey em

8,77315 gold badges73 silver badges130 bronze badges

answered Apr 26, 2023 at 4:56

dshukertjr

19.2k11 gold badges71 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1