For interactive slicing and dicing of csv, xml, json, etc. I like VisiData. For scripting I like miller and jq. Not sure how that compares to your PS setup.
There are some recent Unix shells, like nushell for working with structured data, but I haven't used them.
- https://github.com/saulpw/visidata
- https://github.com/johnkerl/miller
- https://github.com/nushell/nushell