SQL/JSON path expressions look very powerful for making queries easier to understand, they’re a part of the SQL spec I hadn’t seen yet. I’m a little sad though

SQL/JSON path expressions look very powerful for making queries easier to understand, they’re a part of the SQL spec I hadn’t seen yet. I’m a little sad though to see yet another JSON location mini-language appear. We’ve got JSONPointer (IETF standard for the web, used by jsonschema), JSONPath, the more expressive but cross language JMESPath, the CLI favorite jq, and presumably a billion more. It’s wearing me out.