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.
wrote a blog on it, maybe helpful to the community.