Thanks for bringing this up. I came across Oracle’s “invisible” columns while researching https://issues.apache.org/jira/browse/CALCITE-1991 <https://issues.apache.org/jira/browse/CALCITE-1991>. You’ll notice that I explicitly say they are out-of-scope for that issue.
However, they are a nice feature, and we should consider doing them at some point. Julian > On Sep 28, 2017, at 2:08 AM, Vladimir Sitnikov <[email protected]> > wrote: > >> Option 6, “system” columns. Similar behavior to Oracle’s ROWID column: > > By the way, Oracle DB 12.1 has invisible columns: > https://oracle-base.com/articles/12c/invisible-columns-12cr1 > > Invisible column is not listed in "select *", and it can be selected via > direct mention. > > Vladimir
