Use case: You are planning to use Oracle Apex to execute the Logical queries to OAC programmatically and expecting a Physical Query/ Result set from it. Custom application is less performant and unable to generate the Optimized Physical Queries. Hence, the business need is to leverage Analytics engine query optimization, dynamic query generation capabilities.
As of now Best Known Solution:
The best solution we have at the moment is JDBC.
Here is a blog post showing an example:
https://blogs.oracle.com/analytics/post/query-your-oac-semantic-model-from-oci-data-science-environment
OAC Should allow queries through REST APIs
