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 }