> Source Metadata can have a "native query" property set so is it possible to create a source table with a native query specified and do so via DDL?
Yes it can be done via DDL or extension metadata in Designer.
Ok.. then back to my original question
Source Metadata can have a "native query" property set so is it possible to create a source table with a native query specified and do so via DDL?