Edit JSON Objects in SQL

[vwake7]

@jeffreyaven 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?

[jeffreyaven]

hey @vwake7 we do support json_remove and json_replace, they just aren't documented, give them a try

[vwake7]

oh, ok, sure thanks.

[jeffreyaven]

ill raise an issue to get these documented

[jeffreyaven]

hi @vwake7 have documented several functions including JSON_INSERT and JSON_REPLACE, have a look, we are always looking for goo real world examples if you wanted to raise a PR at stackql.io

[vwake7]

Sure, I will, More than happy to be involved in this project.

…

On Mon, 29 Apr, 2024, 2:00 pm Jeffrey Aven, ***@***.***> wrote: hi @vwake7 <https://github.com/vwake7> have documented several functions including JSON_INSERT <https://stackql.io/docs/language-spec/functions/json/json_insert> and JSON_REPLACE <https://stackql.io/docs/language-spec/functions/json/json_replace>, have a look, we are always looking for goo real world examples if you wanted to raise a PR at stackql.io <https://github.com/stackql/stackql.io> — Reply to this email directly, view it on GitHub <#401 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AQBW7BJ2X4NEBGE7SKHONYLY7YAJJAVCNFSM6AAAAABGWFGGR2VHI2DSMVQWIX3LMV43SRDJONRXK43TNFXW4Q3PNVWWK3TUHM4TENJZHE4TM> . You are receiving this because you were mentioned.Message ID: ***@***.***>