I have a multiple level JSON field which I am unable to parse.

      "Complete Blocks"."EVENT_SCORES_JSON":"OverallScore" as Score

The above line returns the full "Complete Blocks"."EVENT_SCORES_JSON" field as a Text type field i.e
{
  "OverallScore" : XX, 
  ect...
}

But obviously I am looking to simply return the value XX.

I would normally just TRY_CAST or CAST these values but they dont seem to be supported?

How can I parse the value?