q
q copied to clipboard
q - Run SQL directly on delimited files and multi-file sqlite databases
``` $ cat a.txt "1 $ q -W all 'select * from a.txt' "1" ``` the output is not correct
I would like to donate to you or your favorite charity to help encourage a new feature: Unicode separated values (USV) which uses Unicode unit separator U+241F and Unicode record...
This Q tool is amazing is there any plan to release a java library to use it programmatically?
q appears in app search but an error is displayed when trying to install it: - snap search q ... q 1.6.3-1 nhandler - run SQL directly on CSV or...
I really like this tool, it simply awesome! I just wonder why you don't provide it as a Python package so pip may be used to manage the installation. It's...
I have a csv like: ``` "a","b","c" "1","2","3" ``` When I try to use q to select this with this command `q -H -d ',' "select * from " -O`,...
https://saveenr.gitbooks.io/usql-tutorial/content/set-operations/outer-union.html
More folks and systems are shipping with modern python as the default. It would be great if ``q`` specified that it needed python2.
First, thanks for this very useful script – works fine even in MobaXterm out-of-the-box (used the single-file-executable)! Unfortunately, I couldn't figure how to use it properly on "CSV" files using...
select ifnull(column,0) from doesn't work for me, never sees the null, but I wonder if it's related to format, I'm using `-d ,`