Teiid supports standard ANSI SQL.
BTW, if you are using Teiid Designer, after you define the view and its transformation, there are couple tabs to provide the insert/update/delete transformation that need to carry out for that view. These transformations are defined using INSTEAD OF triggers like
CREATE TRIGGER ON A INSTEAD OF UPDATE FOR EACH ROW BEGIN ATOMIC UPADTE A SET A.COL_A=... WHERE A.ID=... END
See https://docs.jboss.org/author/display/TEIID/Update+Procedures also note that since this block is defined as procedure Teiid provides PROCEDURE language
to define any constructs
Thank you Ramesh, I find another way, I created a linked server in ms sqlserver, and the problem solved