How to insert in multiple tables with a single API call in Supabase
This is the simplified structure of my tables - 2 main tables, one relation table. What's the best way to handle an insert API for this? If I just have a Client and Supabase: - First API call to insert book and get ID - Second API call to insert genre and get ID - Third API call to insert book-genre relation This is what I can think of, but 3 API calls seems