$ pq --help
prql-query
pq: query and transform data with PRQL
USAGE:
pq [OPTIONS] [QUERY]
ARGS:
<QUERY> The PRQL query to be processed if given, otherwise read from stdin [env:
PQ_QUERY=] [default: -]
OPTIONS:
-b, --backend <BACKEND> The backend to use to process the query [env: PQ_BACKEND=]
[default: auto] [possible values: auto, datafusion, duckdb]
-d, --database <DATABASE> The database to connect to [env: PQ_DATABASE=]
-f, --from <FROM> The file(s) to read data FROM if given [env: PQ_FROM=]
--format <FORMAT> The format to use for the output [env: PQ_FORMAT=] [possible
values: csv, json, parquet, table]
-h, --help Print help information
--no-exec Only generate SQL without executing it against files
--sql set this to pass a SQL query rather than a PRQL one [env: PQ_SQL=]
-t, --to <TO> The file to write TO if given, otherwise stdout [env: PQ_TO=]
[default: -]
-w, --writer <WRITER> The Writer to use for writing the output [env: PQ_WRITER=]
[default: arrow] [possible values: arrow, backend]
after
$ pq --help
prql-query 0.0.14
pq: query and transform data with PRQL
USAGE:
pq [OPTIONS] [QUERY]
ARGS:
<QUERY> The PRQL query to be processed if given, otherwise read from stdin [env:
PQ_QUERY=] [default: -]
OPTIONS:
-b, --backend <BACKEND> The backend to use to process the query [env: PQ_BACKEND=]
[default: auto] [possible values: auto, datafusion, duckdb]
-d, --database <DATABASE> The database to connect to [env: PQ_DATABASE=]
-f, --from <FROM> The file(s) to read data FROM if given [env: PQ_FROM=]
--format <FORMAT> The format to use for the output [env: PQ_FORMAT=] [possible
values: csv, json, parquet, table]
-h, --help Print help information
--no-exec Only generate SQL without executing it against files
--sql set this to pass a SQL query rather than a PRQL one [env: PQ_SQL=]
-t, --to <TO> The file to write TO if given, otherwise stdout [env: PQ_TO=]
[default: -]
-V, --version Print version information
-w, --writer <WRITER> The Writer to use for writing the output [env: PQ_WRITER=]
[default: arrow] [possible values: arrow, backend]
Notes
Supported PRQL versions should also be displayed, which requires prql-compiler 0.4.2 (PRQL/prql#1604)
The datafusion version is publicly available and can be easily displayed, but the duckdb version does not seem to be publicly available.
Thanks very much for the PR @eitsupi . I'll update to prql-compiler 0.4.2 next. If you want to add another PR to expose the prql-compiler version in prql-query, that would be awesome.
before
after
Notes