This tool can do that: $ cat example.json | sq sql 'SELECT * FROM data' actor_id first_name last_name last_update 1 PENELOPE GUINESS

This tool can do that: $ cat example.json | sq sql 'SELECT * FROM data' actor_id first_name last_name last_update 1 PENELOPE GUINESS 2020-06-11T02:50:54Z 2 NICK WAHLBERG 2020-06-11T02:50:54Z One of the data source types is 'json' and the command 'sq sql ...' lets you execute SQL directly instead of using their default query language (SLQ).