In the k8s world there's a random collection of json path, json query, some random expression language.

Just use jq. None of the other ones are as flexible or widespread and you just end up with frustrated users.

This. Jq is the defacto standard and anytime I come across something else I am annoyed.

Which isn't to say jq is the best or even good but its battle-tested and just about every conceivable query problem has been thrown at it by now.