JSONPath is a full query language (https://datatracker.ietf.org/doc/rfc9535/), similar to XPath for XML. It supports things like transformations, array operations, filters, etc.
We use this to great effect exploring and sifting through data in web browsers, where many different pieces of software may be storing various things globally, but you don't always know where to look.
(The advantage to this approach is that both XML and XPath are specified standards)