Use value returned by UPDATE in another query

SQL++
1

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).

2

except SELECT all other DMLs are not allowed in chaining.

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

1 Like