> well, you can perform multiple updates atomically, so that shouldn't be the primary concern, but I do see why you want it to be simpler
What happens in one update if a subset of the relations don't exist and I try to delete them?
Also I'm looking closer at your schema. It does simplify things, but it requires a bidirectional relationship. For example, I need to both set
relationships. Is there a way to avoid such a cyclic dependency?