> And the newest era of "some" programs supporting JSON or XML output but there's still no easy tools for filtering through it into the next program--requiring yet another translation layer.

As someone who's been working with aws command line tools quite a bit recently that accept and emit lots of json, I've found jq to be a life saver! https://stedolan.github.io/jq/