I don't make a habit of spamming discussion threads but... my product QueryTree (http://querytreeapp.com http://querytreeapp.com) will load JSON files even if t

I don't make a habit of spamming discussion threads but... my product QueryTree (http://querytreeapp.com http://querytreeapp.com) will load JSON files even if they have lists at the root, you can use the Append tool to bring multiple files together, and you can then use Filter, Sort, Join and Group without ever having to define a schema. Admittedly, it's aimed at novice users so if you're comfortable with SQL it may feel limiting.