Unsupported json input with minus character in key value

[fraf]

Hello,

I need to SED a json input file so as to remove all "'-" (minus) character when they are present as a key. e.g. :
{
"my-key": "my-value"
}

need to be "sed" processed so as to obtain the resulting json :
{
"my_key":"my-value"
}

Can you correctly parse json input taking into account those "minus" in key value ?

Regards.

This command should run ok :

cat gravitee-request-2024.06.08-single.json | spyql -Otable=gravitee_request_2024_06_08 "SELECT json->_index, json->_type, json->_id, json->_score, json->_source.subscription, json->_source.request_content_length, json->_source.local_address, json->_source.path, json->_source.response_content_length, json->_source.remote_address, json->_source.host, json->_source.api, json->_source.plan, json->_source.tenant, json->_source.method, json->_source.custom, json->_source.response_time, json->_source.uri, json->_source.timestamp, json->_source.proxy_latency, json->_source.application, json->_source.api_response_time, json->_source.gateway, json->_source.transaction, json->_source.status, json->_source.user_agent FROM json TO sql" 2>/dev/null > output.sql

letting original json->_source.api-response-time (I.e. without transforming to : json->_source.api_response_time )