I want to find out if it is possible or request a few features related to disconnecting relations. I didn't see anything when searching the Issues, but I cannot imagine that these feature requests haven't been made before. 1. Exclusively update relation - The idea is that if I pass in 2 records that I want to have related to a model and i know that no other records should be related, it should automatically run the query to disconnect any other records that don't match. 2. Connect/Disconnect via where - Instead of having to declare each record to connect/disconnect, the relation could include the ability to add a where clause independent of the unique constraints. ex. If I want to disconnect all Posts from users who are marked as deleted, or connect a Post to all tags created in the last 10 days (these are kinda stupid use cases, but off the top of my head)

1) Should already work via

set

. Is that what you're looking for? 2) is a valid feature request and can be filed on github: https://github.com/prisma/prisma

awesome, I was wondering about #1 because it seemed so obvious of a use case

It doesn’t leave the records in place,

set

replaces the records with the ones you provide.

so it deletes all the rows and adds the new ones?

Yes.