[Feature Request] Support optimistic updates for Upsert queries

[priyanka-sadhwani]

Is your feature request related to a problem? Please describe.
We use the Upsert hooks a lot in our frontend, however optimistic updates do not work for these hooks. Feature request is to add support for optimistic updates in Upsert hooks.

Describe the solution you'd like
The optimistic update options works for Upsert queries, as it does for Create/Update. i.e. the query cache is updated while the API query is pending.

Describe alternatives you've considered
Alternatives would be use Create / Update, however this would cause extra complication in our codebase as we could need to check if the object exists first.