Read more on my blog, in this series of posts on New features in sqlite-utils and other entries tagged sqliteutils. $ sqlite-utils memory dogs.csv "select * from t ...

Use the SQLite CLI's fsdir() table functions with lines_read() to read lines from every file in a directory.