Sources

from chooses the main JSON file:

select {id, name} from 'customers.json'

join uses the same source format for additional files.

Relative paths

A relative path starts from the directory where you run jql:

jql "select {id} from 'data/orders.json'"

JQL resolves relative paths from the directory where you run the command and does not search other locations.

Absolute paths

An absolute path points directly to a file:

jql "select {id} from '/srv/import/orders.json'"

Quoted and unquoted filenames

Both forms work in the command-line interface:

jql "select {id} from 'orders.json'"
jql "select {id} from orders.json"

Quotes are recommended because they also support paths containing spaces.

Root JSON values

JSON root	Rows used by JQL
Array	One row for every array item.
Object	One row containing that object.
Primitive or null	One row containing that value.
Empty array	No rows.

Most queries use an array of objects, but JQL can read any valid JSON document.