[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1270) SQL Templates for Insert, Update, and Delete queries need to be modified to represent new syntax for Teiid 7.7

SQL Templates for Insert, Update, and Delete queries need to be modified to represent new syntax for Teiid 7.7 -------------------------------------------------------------------------------------------------------------- Key: TEIIDDES-1270 URL: https://issues.jboss.org/browse/TEIIDDES-1270 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 7.7 Reporter: Barry LaFond Assignee: Mark Drilling Priority: Critical Fix For: 7.7 The latest Teiid has changed the Update/Insert/Delete SQL to utilize the "FOR EACH ROW" concept instead of the "CREATE VIRTUAL PROCEDURE" Also the content of the SELECT has changed to use the NEW, OLD and CHANGED terms See Teiid 7.7 Reference Guide for details