Q – Run SQL Directly on CSV or TSV Files
A satisfied user here. Found it very useful when tools like cut and sort weren't enough, usually when I need to do a join on two different tables (err, files). Left joins work, but I don't think right joins are supported.I've used this in combination with jq as well. I'll use jq to convert json to CSV, and then use SQL to do whatever else.