I write an SQL (or mainly PRQL these days) query on a text editor on a file which is being watched by entr which runs the query on a sqlite database which outputs a csv file which is then read by visidata and there I look at the data, do some basic manipulations. That my very simple, completely unix-style data exploration pipeline. What I miss a bit from Visidata is a bit more mouse control. I mainly want to select a range of cells to copy and paste somewhere else, which this does. But unfortunately this doesn't reload the file on change automatically.
Anyone has any recommendations for a data tool that would fit the workflow I described?
18 years of creativity, awesome.
For me, the frustration is version control. Native spreadsheet formats (xlsx/ods) are binary, so un-diffable. Plaintext formats like CSV/TSV play nice with Git, but come at a high cost in ergonomics: there is no way to preserve formatting such as column widths and formulas are usually discarded on save. Moreover, Excel/Calc don't really like it when you overwrite an open file from another program.
MtCellEdit seems to be a step in the right direction, but still leaves a good part of the itch unscratched.