79661218

Date: 2025-06-10 23:23:46
Score: 1
Natty:
Report link
SELECT
  id,
  key,
  TO_JSON_STRING(json_obj[key]) AS value
FROM source,
UNNEST(JSON_KEYS(PARSE_JSON(data))) AS key,
UNNEST([PARSE_JSON(data)]) AS json_obj

Data being a stringified json object

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Kabilan Thayaparan