When the underlying storage layer allows more flexibility in defining a schema, it's useful to allow a VIEW to define new columns. It'd be great if Calcite supported this as well. See http://phoenix.apache.org/views.html and http://phoenix.apache.org/multi-tenancy.html for examples.
Add EXTEND clause, for defining columns and their types at query/DML time
Support for modifiable views with extended columns