See how powerful FROM_FIELD() is. It helped me extract a simple JSON data structure from a field into it's own dimension table.
This is a simple example that works with flat json, meaning non-nested json hierarchies. However, you can use a combination of other functions like JSONGET() and JSONSET() to extract needed data. More examples on this to follow.
