ritchieking

sqlcsv() {
  if [ $# -lt 2 ]
  then
    echo "USAGE: sqlcsv [filename.csv] [SQL]"
    echo "In the SQL, refer to the data sourse as [filename]"
  else
    filename="$1"
    dataname=${filename%????}
    sqlite3 :memory: -cmd '.mode csv' -cmd ".import $filename $dataname" -cmd '.mode markdown' $2
  fi