[teiid-issues] [JBoss JIRA] Created: (TEIID-669) Support "pass though" SQL commands to sources

[Ramesh Reddy (JIRA)]

Support "pass though" SQL commands to sources
---------------------------------------------

                 Key: TEIID-669
                 URL: https://jira.jboss.org/jira/browse/TEIID-669
             Project: Teiid
          Issue Type: Feature Request
          Components: Query Engine
            Reporter: Ramesh Reddy
            Assignee: Steven Hawkins
             Fix For: 6.2.0


Currently there is no mechanism in Teiid, when a query is submitted to a runtime engine that is passed through the query engine unadulterated and unmodified and submitted directly to a source connector. All queries are parsed, optimized, re-written.  Some times this limits the functionality in Teiid, when a user would like to execute a query that is very "source" specific. For example Oracle supports lots of Oracle specific functions that are not supported by the SQL spec, to support execution of these in Teiid user need to resort to UDF, which is cumbersome and involves modelling. 

Another benefit of this is also to pass DDL to sources, currently since Teiid does not support DDL, this is not possible at all.

There is no-expectation that these queries are part of any data integration, these are one off queries that enhance user experience with Teiid if they use this feature. Command Payload mechanism is similar system that is used for authentication and authorization needs at the connector level, this feature can use similar techniques or use some custom extension to the language to define a query etc.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira