duckdb -json mydb.duckdb -c "SELECT * FROM users;"

Category: Databases & SQL

duckdb -json mydb.duckdb -c "SELECT * FROM users;"

Output results as JSON

Prints one JSON object per row, handy for jq pipelines or feeding web APIs. Related: -csv.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.