visidata icon indicating copy to clipboard operation
visidata copied to clipboard

[sqlite ] exec-sql command create sheets with unique or helpful names.

Open frosencrantz opened this issue 7 months ago • 5 comments

@saulpw added this wonderful exec-sql command in response to https://github.com/saulpw/visidata/issues/1719

The wishlist item is to make that command more useful.

  • [ ] The command always creates sheets with the same name query. Add a way to automatically create unique names for the sheets like make the name based on the query, or simply add a unique count suffix to the sheet name query1, query2, etc.
    • [ ] Add an input field for specifying the sheet name
  • [ ] Make it easy to see the query associated with the sheet. I can not see this in the SheetsSheet. There is likely a way to do it, but I do not know.
  • [ ] Make it easy to make an edit to the query used and create a new sheet
  • [ ] Add column types

frosencrantz avatar Nov 25 '23 19:11 frosencrantz