Pluggable SQL and inquiry levels

Inquiry levels can be used in conjunction with pluggable SQL statements.

Pluggable SQL statements are generated to supplement the fine grained SQL statements that populate coarse grained business objects for domains. This approach results in performance improvements and increased transaction throughput.

The pluggable SQL feature does not support fine grained pre-post action triggers, and so does not support behavior extensions in components that were otherwise invoked with the standard method. Therefore, features such as Smart Inquiry and Skip Execution Rules are not supported when the pluggable SQL feature is enabled.

The action triggers for the top level component are supported as-is.

You can modify the existing data model by extending existing tables within the pluggable SQL feature.