Ask files command for querying CSV / JSON etc

[simonw]

Idea from Datasette Discord. Can use the same mechanism as sqlite-utils memory for turning CSV/TSV/JSON into temporary in-memory tables, the answer a question.

[simonw]

Needed this feature in sqlite-utils core first:

• Mechanism to make memory DB created by sqlite-utils memory available to other commands sqlite-utils#643

[simonw]

OK, the prototype works. With a CSV file dogs.csv like this:

name,description
Cleo,Excellent dog
Buffy,Vampire slayer dog

This works:

sqlite-utils ask-files dogs.csv 'count the dogs'

select count(*) from t

[
    {
        "count(*)": 2
    }
]

And:

sqlite-utils ask-files dogs.csv 'count the dogs with slay in their description'

select count(*) from t where description like '%slay%'

[
    {
        "count(*)": 1
    }
]