Miller Csv can process json in record format and has a much saner DSL in my experience.

https://github.com/johnkerl/miller