Q: Run SQL Directly on CSV Files
Real-world CSV files generally contain some or all of the following horrors:<p>- some strings enclosed in speechmarks, but some not<p>- empty fields<p>- speechmarks within strings<p>- commas within strings<p>- carriage returns within strings<p>How does Q do up against a CSV file with those traits?