How to Flatten nested JSON arrays

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

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