SFDX convert SOQL into CSV

soql2csv.sh

#!/bin/sh -e

function printHelp() {
    echo "Incorrect usage. Example:\n\t./soql2csv.sh \"SELECT Id, Name FROM Account LIMIT 10\" myorg > accounts.csv";
}

if [ ! -e "`which jq`" ]; then
    echo "You need to install jq to use this script."
    if [[ "`uname`" == "Darwin" && -e "`which brew`" ]]; then
        echo "Try running 'brew install jq'"
    fi
    exit 1
fi

if [ "$#" -lt 1 ]; then
    printHelp
    exit 1
fi

QUERY=$1
if [ -z "$QUERY" ]; then
    printHelp
    exit 1
fi

ORG=$2
if [ -z "$ORG" ]; then
    ORG=`sfdx force:config:list --json | jq -r '.result[] | select(.key == "defaultdevhubusername") | .value'`
fi

# execute SOQL and convert json result into a CSV.
sfdx force:data:soql:query -u $ORG --query "$QUERY" --json | \
    jq -r '.result.records | del(.[].attributes) | (.[0] | to_entries | map(.key)), (.[] | [.[]]) | @csv '