liteJQ

This first release brings the jq(json,jqprog) function to SQLite.

Examples

select jq(d, '{title: .title, year: .year}')
from movies
where jq(d, '.year > 1980');

select jq(d, '.extract')
from movies
where jq(d, '.extract | contains("silent")');

select jq(d, '{title: .title, year: .year, cast: .cast}')
from movies
where jq(d, '.cast | contains(["Joan Lorring", "John Dall"])');