Are nested INSERTs possible?

[philip-weber]

Hi there,

I have a one-to-many relation between two tables and would like to insert in both tables with one query. Is this possible with the Supabase-JS Client? Unfortunately I did not find anything regarding this in the docs.

Eg. it would be great if one could insert a new user in the users table and within the same query insert some posts associated to the new user in the posts table.

For example see the docs from Prisma or Fauna (with GraphQL).

Thank you in advance!

[steve-chavez]

Hey @philip-weber,

Is not possible right now. But once PostgREST/postgrest#818 is solved, supabase-js will be able to do nested inserts.

[philip-weber]

Thank you for the answer. Then I'll keep my fingers crossed that PostgREST/postgrest#818 will be solved sooner or later. Hopefully sooner than later ;)

Regardless, thanks to you and all the other maintainers for your great work on supabase and all the libraries it is built on. Keep up the good work!