Converting a JSON string to a JSON obj in SQL

Let’s say you have an string object that looks like this:

'{ "subtype": "birthday", "type": "automated_campaign" }'

How can you convert that to a JSON obj?

Answer: You can use JSON_PARSE

SELECT JSON_PARSE('{ "subtype": "birthday", "type": "automated_campaign" }')