Postgres 9.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table mytable (column_1  jsonb);
insert into mytable values('
{
  "country": "GB",
  "channel": "mobile",
  "profileGroups": [
    {
       "profiles": ["profileA", "profileB"],
       "negativeProfiles": ["negativeA"]
    },{
       "profiles": ["profileC"],
       "negativeProfiles": null
    }
  ]
}')

INSERT 0 1


CREATE OR REPLACE VIEW v_table AS
SELECT REPLACE(REPLACE(column_1::TEXT, 'profileGroups', 'profile_groups'), 'negativeProfiles', 'negative_profiles')::jsonb AS column_1
FROM mytable

CREATE VIEW


SELECT *
FROM v_table


column_1


{"channel": "mobile", "country": "GB", "profile_groups": [{"profiles": ["profileA", "profileB"], "negative_profiles": ["negativeA"]}, {"profiles": ["profileC"], "negative_profiles": null}]}



SELECT 1