Also see common JDBC Translators information.

The JDBC ANSI translator, known by the type name jdbc-ansi, declares support for most SQL constructs supported by Teiid, except for row LIMIT/OFFSET and EXCEPT/INTERSECT. It translates source SQL into ANSI compliant syntax. This translator should be used when another more specific type is not available. If source exceptions arise from unsupported SQL, then consider using the JDBC simple translator to further restrict capabilities, or create a custom translator. For more information, see the Custom Translator documentation in the Teiid community.