How to Flatten nested JSON arrays (datazip.io)

wrote a blog on it, maybe helpful to the community.

Full title is How to Flatten Object Types and Query Arrays in Semi-Structured Nested JSON for Effective Data Extraction which makes a lot more sense, as flattening nested arrays seems rather trivial.