Support for Vizual within Mimir

[okennedy]

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.

1. 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)

2. 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.

3. Add a Vizual operation to the Vizier API.