[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1223) Create SQL String Template framework and dialog for use in new view construction and SQL editing

Create SQL String Template framework and dialog for use in new view construction and SQL editing ------------------------------------------------------------------------------------------------ Key: TEIIDDES-1223 URL: https://issues.jboss.org/browse/TEIIDDES-1223 Project: Teiid Designer Issue Type: Sub-task Components: Transformations Affects Versions: 7.6 Reporter: Barry LaFond Assignee: Mark Drilling Fix For: 7.7 Attachments: Prototype SQL String Template dialog.bmml, Prototype SQL String Template dialog.bmml, Prototype SQL String Template dialog.png, SQLTemplateDialog.png Could be beneficial to expose a standard library of SQL templates that Designer knows about and uses in our import and object creation wizards. EXAMPLES include forms based on : SELECT * FROM XXXX SELECT a,b,c FROM t1, t2 WHERE t1.a = t2.b ======= Generated XML File Importer SQL ========== SELECT A.x AS x, A.y AS y FROM (EXEC MP.getTextFiles('myfile.xml')) AS f, XMLTABLE('/topelement/secondelement' PASSING XMLPARSE(DOCUMENT f.file) COLUMNS x string PATH '/x', y string PATH '/elem_a/elem_b') AS A ========================