postgres escape single quote in json

How to group on a column array aggregate on another and create a single JSON object keyed by the grouped column. Insert json stri…