TIL how to scan, search, filter and rejigger CSV & JSON data using `sqlite-utils` π»
sqlite-utils is a handy little CLI tool to work with CSV and JSON data. Its v3.10 update introduced a new memory command that makes it trivially easy to pass raw data into the tool without extra steps: The new sqlite-utils memory command can import CSV and JSON data directly into an in-memory SQLite database, combine and query it using SQL and output the results as CSV, JSON or various other formats of plain text tables.