[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1995) Add templates for OBJECTTABLE, TEXTABLE, etc

[ https://issues.jboss.org/browse/TEIIDDES-1995?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-1995: ---------------------------------------- Office discussions have led to more questions about this feature and how it should be implemented. The nature of SQL definition in Designer really begs for providing a more robust/full set of SQL fragments to handle the special Language objects supported by the Teiid runtime and query parser framework. TEXTTABLE, XMLTABLE, OBJECTTABLE, ARRAYTABLE would be a primary focus. We could provide a small set of templates for each of these with variables/placeholders for the user to replace. Ultimately this begs for enhancing the code-completion framework. So all the formatting/BNF rules for these objects would have to be captured and implemented.... and that's not a small effort. {code} TEXTTABLE(expression [SELECTOR string] COLUMNS <COLUMN>, ... [NO ROW DELIMITER] [DELIMITER char] [(QUOTE|ESCAPE) char] [HEADER [integer]] [SKIP integer]) AS name OBJECTTABLE([LANGUAGE lang] rowScript [PASSING val AS name ...] COLUMNS colName colType colScript [DEFAULT defaultExpr] ...) AS id ARRAYTABLE(expression COLUMNS <COLUMN>, ...) AS name XMLTABLE([<NSP>,] xquery-expression [<PASSING>] [COLUMNS <COLUMN>, ... )] AS name {code} Pushing to 8.7 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira