Have you looked at Jsonata? I think it is a more expressive language than jsonpath.