select array_length((details->>'$.videos')::JSON[]) AS item_video_count FROM ( select '{"videos":[{"lang":"en","name":"Thats another story } (short film)","type ...
When using the repair_json function, JSON strings with arrays containing unescaped quotes inside string values are incorrectly split into multiple elements, instead of escaping the additional ...