You can use SQL function
JSON_TRANSFORM to update parts of a JSON document. You specify which parts to modify, the modifications, and any new values.
JSON_TRANSFORM makes it easier for an application to modify a JSON document, without having to parse and rebuild it. In most cases, it also avoids a round-trip between the server and client for the whole document.