spyql
spyql copied to clipboard
Query data on the command line with SQL-like SELECTs powered by Python expressions
`to_json(.a_dict_col)` would generate a json string. Follow-up of #94
I'm using spyql to handle general text files (single-column, not comma-separated), but got a problem. A single-column text file like the following is misinterpreted as multiple columns by spyql. test.csv:...
Tried to add Python 3.11 but broke the build: ``` Installing build dependencies: started [66](https://github.com/dcmoura/spyql/actions/runs/3609720398/jobs/6083085988#step:4:67) Installing build dependencies: finished with status 'done' [67](https://github.com/dcmoura/spyql/actions/runs/3609720398/jobs/6083085988#step:4:68) Getting requirements to build wheel: started [68](https://github.com/dcmoura/spyql/actions/runs/3609720398/jobs/6083085988#step:4:69)...
i'm trying to read json file im getting below error UnicodeDecodeError: 'charmap' codec can't decode byte 0x9d in position 2854: character maps to
Currently SPyQL only allows to read and write JSON lines. Writing JSON arrays can be done using the `dict_agg`, aggregating everything into an array and writing an JSON with a...