[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-987) Add ability to edit/generate Create Virtual Procedure SQL statements for RestEasy XML, File and Web Service Translator procedures

Add ability to edit/generate Create Virtual Procedure SQL statements for RestEasy XML, File and Web Service Translator procedures --------------------------------------------------------------------------------------------------------------------------------- Key: TEIIDDES-987 URL: https://issues.jboss.org/browse/TEIIDDES-987 Project: Teiid Designer Issue Type: Enhancement Components: Editors, Transformations Affects Versions: 7.4 Reporter: Barry LaFond Assignee: Mark Drilling Fix For: 7.7, 7.7.1 Designer includes "Generate xxxx procedures" options in the New Model Wizard. Also have a RestEasy use-case that requires getXXXX virtual procedures that contain SQL like: CREATE VIRTUAL PROCEDURE BEGIN SELECT XMLELEMENT(NAME parts, XMLAGG(XMLELEMENT(NAME part, XMLFOREST(VirtualParts_Supplier.PARTS.PART_ID, VirtualParts_Supplier.PARTS.PART_NAME, VirtualParts_Supplier.PARTS.PART_COLOR, VirtualParts_Supplier.PARTS.PART_WEIGHT)))) AS result FROM VirtualParts_Supplier.PARTS WHERE VirtualParts_Supplier.getParts.partId_in = VirtualParts_Supplier.PARTS.PART_ID; END Would be nice to have a framework where "wizards" can be accessed to create/edit the content of this SQL if the basic structure is a Set Query (SELECT * FROM XXX)for these specific use-cases.