Skip to content

Releases: Florents-Tselai/liteJQ

liteJQ v0.1.0

03 Mar 14:28
Compare
Choose a tag to compare

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"])');