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

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12729502#comment-12729502 ] 

Ramesh Reddy commented on TEIID-669:
------------------------------------

JLee, I thought the only changes we are going to do for EDS 5.3 was in the JBDS which are going in their rollup. The extension properties for native query for relational sources is already in the 5.3. These TEIID-2176, TEIID-2177 JIRAs expand the native query support to other sources and also provide native procedure support which we are not approved for 5.3
                
> Support "pass though" SQL commands to sources
> ---------------------------------------------
>
>                 Key: TEIID-669
>                 URL: https://issues.jboss.org/browse/TEIID-669
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Ramesh Reddy
>            Assignee: Steven Hawkins
>             Fix For: 8.2
>
>
> 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.

--
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