The problem is you need to create a table with the correct data types first, which can be time-consuming. Additionally, using CLI can be a bit cumbersome to use, especially if it involves quering multiple tables, or using joins. I don't want to point to the infamous "dropbox" comment [1], but it's important to understand that many folks just want a friendly interface where they can put in a URL/file, and start querying.
This is the exact reason I built TextQuery [2], which solves a similar problem as OP's. I just wanted a simple app where I could drop a CSV and start SQL querying it, without creating schemas or writing code/commands.