add support for relationships in update mutations

[patcito]

Note from Hasura team: issue closed in favour of #1573

It would be nice to have support for relationships in update mutations like there is in insert so that it automatically delete/add new relationships.

My use case is if a Post table has tags ["x","y","z"] as a relationship in a tag_posts table, if I do an update mutation on post with just tags: ["x","y"] it would be nice if "z" could be deleted automatically from tag_posts table, if you see what I mean. Or maybe add an _unset operator so that we could do _set: {tags: ["x","y"]}, _unset: {tags: ["z"]} to delete "z". That would be more explicit and avoid having people deleting things without knowing. Maybe have an option to _unset all tags that are not set such as {_unsetAllNonSet: {tags: true}}, so in this case that would delete "z".

[nolandg]

I've described how Prisma handles this in #1573 (comment)

[bkstorm]

We can learn how Prisma handles this problem (described by @nolandg), they do very well, I think.

[LeoMartinDev]

So, is this still on track ? This feature is clearly lacking

[brianjd]

@coco98 Is there a timeline for this? I'm currently working on a problem created by the lack of this feature.

[rccc]

@marionschleifer @coco98

3 years after this issue is still open, it is a shame that such a feature is still not implemented.

Can we ask a Hasura boss for this ?

Please everyone, contact Hasura directly as i have done myself to ask for this. The Hasura core team have to know we are waiting for this, they have to put someone one this now !

[marionschleifer]

@rccc this is definitely on our roadmap, and we will try to pick it up soon.

An RFC has already been created for it.

[erikkjell]

@marionschleifer is there an update on this?

[rccc]

@marionschleifer it seems this issue is the same as #1573