[teiid-issues] [JBoss JIRA] (TEIID-2798) Add creation of view when exposing metadata via Object translator

Add creation of view when exposing metadata via Object translator ----------------------------------------------------------------- Key: TEIID-2798 URL: https://issues.jboss.org/browse/TEIID-2798 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Affects Versions: 8.4.1 Reporter: Van Halbert Assignee: Van Halbert When the metadata is exposed for the java object via the Object translator, a view should also be created using a template similar to: SELECT t.{pkKeyField}, o.{colname}, o.{colname} FROM Order {ObjectSourceTable} as T, OBJECTTABLE('x' PASSING T.{ObjectTypeName}Object as x COLUMNS {colname} {type} 'teiid_row.{colname}', ….) as o where {pkKeyField} is the primary key column to the cache {ObjectSourceTable} is the source table imported above {ObjectTypeName} is the column added in {ObjectSourceTable} to reference the cache object {colname} is the name of the columns that have “get” methods, see the {ObjectSourceTable} for columns to use {type} is the data type for this column