Oh man this is cool. I don't really have much feedback tbh I just think this awesome. I can see myself using this as a handy little utility when data sets get a bit too big for Google Sheets.
In terms of it being a product, things I can think of that would be useful to me.
- Importing/exporting data from Google Sheets/Google Drive.
- Scheduling queries to run and export etc.
Not sure if that really aligns to this specific project being that it runs locally though.
Edit: Having a few standard dimension tables available to join would be great too. I often want to join time from a date dimension table when I'm making time series data for example.
This tool definitely comes from a place of personal need - beyond just handling large files, I've also never really gelled well with the Excel/Google Sheet model of changing data in place as if you were editing text. I'm a Data Scientist and always preferred the chained data transforms you see in things like dplyr (https://dplyr.tidyverse.org/) or Polars (https://pola.rs/) and I feel this tool maps very closely to the chained model.
Also, thank you for the feature requests! Those would all be very useful - we'll put them on the roadmap.
In terms of it being a product, things I can think of that would be useful to me.
- Importing/exporting data from Google Sheets/Google Drive.
- Scheduling queries to run and export etc.
Not sure if that really aligns to this specific project being that it runs locally though.
Edit: Having a few standard dimension tables available to join would be great too. I often want to join time from a date dimension table when I'm making time series data for example.