12 ms·

csvsql is the first google result for "sql in command line for csv" https://towardsdatascience.com/analyze-csvs-with-sql-in-command-line-233202dc1241 https://t

• coldtea 4y ago
  Yes, I know. It's not that there isn't several ways to do it, it's that it's not really a good fit for the command line, except in the "I want to reuse SQL that I already know". The problem isn't in having a way to use SQL to query the data from the command line, it's that SQL is long winded and with syntax not really fit in a traditional shell pipeline.
  • avodonosov 4y ago
    I submitted a ticket: https://github.com/johnkerl/miller/issues/1235 https://github.com/johnkerl/miller/issues/1235