Postgresql function which converts json underscored keys to camel case keys.

underscore_to_camel_case

CREATE FUNCTION key_underscore_to_camel_case(s text)
RETURNS json
IMMUTABLE
LANGUAGE sql
AS $$
    SELECT to_json(substring(s, 1, 1) || substring(replace(initcap(replace(s, '_', ' ')), ' ', ''), 2));
$$;

-- TODO: add recursive processing
CREATE FUNCTION json_underscore_to_camel_case(data json)
RETURNS json
IMMUTABLE
LANGUAGE sql
AS $$
    SELECT ('{'||string_agg(key_underscore_to_camel_case(key)||':'||value, ',')||'}')::json
    FROM json_each(data)
$$;

Thanks for this! Can you help me modify this for it to work with JSON array of objects?