Joining CSV and JSON data with an in-memory SQLite database
The new
sqlite-utils memory
command can import CSV and JSON data directly into an in-memory SQLite datbase, combine and query it using SQL and output the results as CSV, JSON or various other formats of plain text tables.
This looks very useful.