Support for JSON modification functions

[Kelley12]

Is your feature request related to a problem? Please describe.

When working with a JSON column, it's easy to query that column for the values, but when attempting to update the values, the functions to do so are not supported.

Describe the solution you'd like

Support for the basic JSON modification functions:

• JSON_INSERT
• JSON_REPLACE
• JSON_REMOVE

Describe alternatives you've considered

1. Modifying those columns to be relational. This would require a lot of rework and many schema conflict issues with our workflow.
2. Extracting the JSON, updating the object, and updating using an update script. This is possible but cumbersome
3. Manually updating the JSON values. Possible with a few rows but not feasible with hundreds or thousands of rows

[timsehn]

We'll get on this right quick. Thanks for the request. A function usually takes about 4 hours of developer time so this is a couple days of work.

[macneale4]

I'm going to add JSON_SET to the list to implement.

All four are recommended in concert to give full control

[macneale4]

@Kelley12 - The latest release of Dolt, 1.14.1, has JSON mutation functions implemented. We did the three you requested, completed the implementation of json_set(), and implemented json_array_append() and json_array_insert() for good measure.

I'm going to resolve this. Don't hesitate to reopen if you have any trouble.