> Could we use it to bring in tables from a model after the VDB has been started?
Yes my intent is to not force this to only source temporary tables. From our perspecitve the notion of temporary here is really just scoping. Having it be at a session scope allows us to use the existing temp logic and not worry about cluster propogation, etc.
Great. It isn't even abuse.
From my perspective, using CREATE FOREIGN TEMP TABLE is a better solution than support for pushdown of array_get (from our earlier conversation). For us, the two serve the same use case. There is probably value in the array_get pushdown support but, assuming that TEIID-196 arrives in a suitable time frame, we'll probably use that.