This question has come up a few times in this thread. However I don't see how people expect this to be possible unless they are talking about ndjson with flat r

This question has come up a few times in this thread. However I don't see how people expect this to be possible unless they are talking about ndjson with flat records. JSON in general is a very nested format so languages based on relational algebra/calculus like SQL and PRQL are not going to be that useful unless the data is flattened and normalised first.