Let's expand a JSON array column to a new table so you can slice and dice by properties in that array.
It took me too long to figure this out - so hope this saves you some time.
@bradygaster was a guest in my test data :)
Blog: https://jong.io
Twitter: / jongallant