native queries are used on source tables, see https://docs.jboss.org/author/display/TEIID/JDBC+Translator
Is it possible to define the native query property for a physical table ?