Clean JSON input and switch to JSONB

[adsharma]

I tried to make some of the JSON columns use the JSONB type. But had to revert back to TEXT because of errors.

[adsharma]

c6099cd fixes some of the issues. Leaving this issue open if there are more cases to be handled.

Once clean, you should be able to run:

opencode=# ALTER TABLE message ALTER COLUMN data TYPE jsonb USING data::jsonb;