Many-to-many relationships not inserting in pivot table

[zalito12]

Bug report

Describe the bug

I have tried lot of things, but I cannot find the way so the client inserts many-to-many relationships between tables.

I have all the PK and FK configures, I even recreate the example from the docs with movie and person table, tried querying for the related person first, I don't know, may be I'm missing something or may be this is not supported. I couldn't find any innformation on this topic.

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Go to Supabase and create movie and person tables like the example
2. Create the models as the examples
3. Create some persons in the supabase web client
4. Insert a new Movie referencing an existing person
5. The pivot table is empty, no reference is inserted.

Expected behavior

I was expecting the client to insert the reference between the two models.

[Tr00d]

@zalito12 Thanks for the report.

This is a limitation of PostgREST itself rather than a bug in the client: a request writes to exactly one table. This means we can't support nested inserts, and Reference properties are ignored on insert/update/delete operations.

I improved the docs on that matter, as you can see here.

I'll see if we can do something to improve the DX though, like an opt-in function where the SDK will also process nested entities but no promises. One issue I'm expecting is doing so without reflection.