On: Execute SQL against structured text like CSV or TS...

[samsquire]

I've found xmlstarlet is wonderful if you are want to use XPath on the terminal. Great with curl + XML APIs like Jenkins.

xml sel --template --value-of "//foo/bar" \ --template --value-of "//baz[@name='Alice']" << EOF <foo> <bar>hello</bar> <baz name="Alice"> world</baz> </foo> EOF

http://xmlstar.sourceforge.net/docs.php

It also can edit with XPath which is really handy.