trdsql
trdsql copied to clipboard
noborus
CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.
Please add an option to auto-detect column types (e.g. `-itype`), or specify numeric column types (e.g. `-inum c2,c3`). Currently, it seems that column types are not auto-detected, which may cause...
Support for `DuckDB` (https://duckdb.org/) would be great. A quick search shows that there is a Go SQL driver for it: https://github.com/marcboeker/go-duckdb (not sure if it is compatible with trdsql).
Please support multiple queries. Currently, it seems that only last query is output, e.g. ``` $ trdsql 'select 1; select 2,3' 2,3 ``` Note: `union` is not used here because...
```shell $ trdsql -ijson "select verbose_name from fudaneducn.json group by verbose_name" trdsql: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.28' not found (required by trdsql) trdsql: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.32' not found (required by trdsql) trdsql:...
Currently, SELECT is the only example that is output as analysis. However, it will be easier to import if the examples of `CREATE TABLE AS` and` INSERT INTO table SELECT`...
If a data file includes Byte Order Markers (in my case, UTF-8 BOM `ef bb bf`), those bytes should be ignored by `trdsql`, but instead are currently treated as part...
While putting SQL, I need to compute standard deviation of some columns like: "select stddev(c1), stddev(c2) from test.csv" It displays: ERROR(EXPORT):SQL:no such function: stddev
The sqlite string functions are not powerful. How about provide a function to use shell utilities like grep, awk, sed etc.? ex. `trdsql -ih -oh "select shell(grep -oP '[[:digit:]]{5}', c1)...
If the package can be installed, add the installation instructions to README.md. If there is a package available for your OS, please tell me how to do it.
This one is related to a comment in issue #100 When targetting json, a flat array with objects are returned, but when using joins, it would be interesting to return...
