Materialized View that parses JSON or nested JSON from the string field of another table

If you store your data as JSON object, but as a String type, and you need to transform this data into the structure with simple types (for aggregation, etc.) this example should help you