How to parse json data in a column with Druid SQL?

I'm trying to parse json data in a column with Druid SQL in Superset SQL lab. My table looks like this:

id json_scores
0 {"foo": 20, "bar": 10}
1 {"foo": 30, "bar": 10}

I'm looking for something similar to json_extract in MySQL e.g.

SELECT *
FROM my_table
WHERE json_extract(json_scores, '$.foo') > 10;

Continue reading...