For JSON querying, checkout JSONata(http://jsonata.org/ - Inspired by the location path semantics of XPath 3.1) . It was created by Andrew Coleman(Part of W3C XML Query WG).
I seem to have reinvented parts of that in python by total happenstance with my latest little project[0]. Have to check out the docs some more to see what ideas I can steal.
