19th June 2021 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. sqlite-utils memory The new feature is part of sqlite-utils 3.10, which I released this morning. You can install it using brew install sqlite-utils or pip install
![Joining CSV and JSON data with an in-memory SQLite database](https://cdn-ak-scissors.b.st-hatena.com/image/square/1dd63341a0e9239759263030baad8774e4599754/height=288;version=1;width=512/https%3A%2F%2Fstatic.simonwillison.net%2Fstatic%2F2021%2Fsqlite-utils-memory.jpg)