Use value returned by UPDATE in another query

Hello all,
I have rather straightforward question. Is it possible to somehow use UPDATE query with RETURNING keyword in INSERT INTO query?
Basically I want to update a document and create a new document next to it with the same value (I want to be sure that it didn’t change between queries).

except SELECT all other DMLs are not allowed in chaining.

You can use SDKs and use returning values as direct kv operation .

1 Like