https://jsvine.github.io/intro-to-visidata/index.html
I am a big fan of VisiData for working with data in the terminal. I also like John Kerl's miller[1] and Simon Willison's sqlite-utils [2] when I want to do queries. These are useful for working with data in simple shell scripts.
[1] https://github.com/johnkerl/miller [2] https://github.com/simonw/sqlite-utils