mimir
mimir copied to clipboard
Support for Vizual within Mimir
At some point, we should migrate the implementation of Vizier's spreadsheet-versioning language, Vizual into Mimir.
Benefits
- Operations in Vizual correspond mostly to simple DDL/DML operations, and many are already defined as OperatorTransforms.
- Putting it in Mimir allows us to leverage Mimir's parser for spreadsheet expressions
- Helping Mimir to understand Vizual would make it easier to push schema changes through operations in the notebook, since Mimir already has tools for batch renaming.
- create a
Vizual
case class with a JSON codec and operations for each of:
- [ ] Reorder columns (Project)
- [ ] Remove column (Project)
- [ ] Add Column (Project adding a column hardcoded to NULL)
- [ ] Rename Column (Project)
- [ ] Remove row (Select on ROWID)
- [ ] Add row (Union ALL with HardTable)
- [ ] Sort
- [ ] Update Cell/Range (Project with CASE)
- [ ] Annotate (Project with DataWarning)
- [ ] Filter (Select)
-
Add a method that takes a table and a sequence of Vizual operations and, using re-enactment (see discussion here) produces a query that simulates applying the operations.
-
Add a Vizual operation to the Vizier API.