jq

While curl is universal in scripts, for interactive API work, HTTPie makes it easy to write your request.

SQL queries directly on the files you already have, CSV, JSON-lines, Parquet, with no database server and no load step.