Skip to content

Support CSV format output #105

@AlexZhou1995

Description

@AlexZhou1995

dsq output as json format by default. Can we support the output in csv format.

Currently, I need to use the jq and sed to get the output of csv

dsq t1.csv t2.csv "select t1.*,t2.* from {0} t1 join {1} t2 on t1.id = t2.id" | jq -r '(map(keys) | add | unique) as $cols | map(. as $row | $cols | map($row[.])) as $rows | $cols, $rows[] | @csv' | sed -e 's/"//g' > result.csv

Can we support the output in csv format by --format

dsq --format csv t1.csv t2.csv "select t1.*,t2.* from {0} t1 join {1} t2 on t1.id = t2.id"

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions