Hi Everyone, As part of our discussions on the Materialized View (MV) spec, the topic of "SQL table identifiers" has been a constant source of complexity. After several iterations, the community has agreed not to use SQL table identifiers in the table-side representation of MVs. However, that still does not preclude referencing SQL table identifiers in views since they are integral to view definitions. Therefore, it’s crucial to properly design this aspect of the spec in order to improve the view spec as well as unblock the progress on the MV spec.
I’ve outlined the current gaps in the view spec along with some proposed ways to address them in this document [1]. It would be great to get your feedback so we can simplify future discussions around views and materialized views. Looking forward to hearing your thoughts. [1] https://docs.google.com/document/d/1e5orD_sBv0VlNNLZRgUtalVUllGuztnAGTtqo8J0UG8/edit Thanks, Walaa