herrfugbaum / qsv

Process CSV and TSV files with SQL.
MIT License
13 stars 5 forks source link

Make the parser case-insensitive #24

Closed ankush981 closed 5 years ago

ankush981 commented 5 years ago

I would really like the convenience of not having to reach for the Shift key when typing keywords. select * from table seems as legit to me as SELECT * FROM table does. And maybe I'm wrong, but I feel that this should be a simple matter of applying lowercase functions to the keywords (tokens?).

ankush981 commented 5 years ago

In the same vein, maybe we can necessitate the semi-colon as the line terminator. People used to the MySQL command line will feel more at home. :relaxed:

herrfugbaum commented 5 years ago

I have added case insensitivity to the parser already, I just forgot to update the dependency here as it seems 😅

Support for semicolon still needs to be added. Would you add it as a mandatory character or as an optinal one?

If we head for a non interactive mode it could come in handy to have a terminator in place to support multiple statements at once.