We are currently working on optimizing our queries (we just moved off Mongo into Cockroach).
One of the heavy hitters we’d like to get rid off involves updating a property of a JSON object.
We currently load the document, update the value and write it back.
We’d like to do that in the database without having to load the whole thing into the client.
I took a look at json_set, but requires me to provide property-key and the value to then do an update.
I need to provide something like {“a”:“the_value_I_dont_know”} where I really just want to provide “a”.
Is there a way to do this?