Currently i am returning single value from "testers" as single(). Is it possible to return single values from nested select queries as well? So lets say i just want a single(first) value from "test" table .

const {error, data} = await supabase
    .from('testers')
    .select("assignments (*, test(*))")
    .single()

Hello ! This thread has been automatically created from your message in a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

I don't think so as these are generally one to many (1:m) relationships

Ziga (2022-03-30)