sq usage

sq usage.sh

#bash command completion
source <(sq completion bash)

#add source
sq add ./CBDB_20200528.db -h @cbdb_20200528

#list source
sq ls

#inspecting, list table names
sq inspect -j @cbdb_20200528 |jq -r '.tables[] | .name' 

#export all tables to csv
sq inspect -j | jq -r '.tables[] | .name' | xargs -I % sq .% --csv --output %.csv


#supported output formats
    --table: Text/Table
    --json: JSON
    --jsona: JSON Array
    --jsonl: JSON Lines
    --csv / --tsv : CSV / TSV
    --xlsx: XLSX (Microsoft Excel)
    --html: HTML
    --xml: XML
    --markdown: Markdown
    --raw: Raw (bytes)