The SQL pass-through mode of the OpenAccess SDK SQL engine allows it to be used to do the SQL parsing and present the parse tree to the IP to perform the execution. This mode allows the IP to use the language that is supported by the data source to optimally execute the requests. One use of this feature is to take advantage of limited or non-standard SQL processing that is offered by your data source. In this example, the OpenAccess SDK SQL engine does the parsing and the IP uses functions that are provided by the OpenAccess SDK SQL engine to extract the information from the query and to formulate it into a language that the data source can execute. The IP then passes the results as rows.
