Is it possible to update multiple rows with one query? Like in insert i can pass an array of objects and each key refers each column. Is there anything like that for an update query?
I have an array of objects (id, value) and i want to update all the fields that match id from the object with the value from the same object.