René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"QAPage","mainEntity":{"@type":"Question","name":"Edit JSON Objects in SQL","text":"\u003cp dir=\"auto\"\u003e\u003ca class=\"user-mention notranslate\" data-hovercard-type=\"user\" data-hovercard-url=\"/users/jeffreyaven/hovercard\" data-octo-click=\"hovercard-link-click\" data-octo-dimensions=\"link_type:self\" href=\"https://github.com/jeffreyaven\"\u003e@jeffreyaven\u003c/a\u003e My use case is I have to edit (delete and replace values) JSON object (usually 'properties' Object from Azure Provider). Originally I was planning to do this in stackql SQL but I cannot find the related JSON functions ( json_replace() and  jsonb_remove()) in stackql.  Currently I am planning to use Sqlite JSON functions. I assume I can also use some Python functions. But is this the suggested approach or am I missing something?\u003c/p\u003e","upvoteCount":1,"answerCount":3,"acceptedAnswer":{"@type":"Answer","text":"\u003cp dir=\"auto\"\u003ehey \u003ca class=\"user-mention notranslate\" data-hovercard-type=\"user\" data-hovercard-url=\"/users/vwake7/hovercard\" data-octo-click=\"hovercard-link-click\" data-octo-dimensions=\"link_type:self\" href=\"https://github.com/vwake7\"\u003e@vwake7\u003c/a\u003e we do support \u003ccode class=\"notranslate\"\u003ejson_remove\u003c/code\u003e and \u003ccode class=\"notranslate\"\u003ejson_replace\u003c/code\u003e, they just aren't documented, give them a try\u003c/p\u003e","upvoteCount":1,"url":"https://github.com/stackql/stackql/discussions/401#discussioncomment-9208295"}}}