In many cases the backend for which the interface is being developed is capable of full expression processing and should be involved in the execution of queries. To support this, the OpenAccess SDK SQL engine can operate in a mode in which it passes the full SQL query including the SELECT list and WHERE clause expression to the IP, so that the IP can handle the complete execution and return the final result row(s).
This feature will be useful in the following cases:
• The data source is capable of executing SQL or SQL-like queries but the query needs to be examined and possibly modified before executing it.
• To wrap business logic around the execution of SQL queries based on the contents of the query.
• To translate from SQL to data source specific language.
