How can I build a web-based SQL query runner to safely query Oracle Fusion data?

Hi Oracle Support,

I’ve seen a tool that connects to Oracle Fusion Cloud by providing the Fusion URL, username, and password, and then allows running SELECT statements through a web interface (like a SQL console).

I would like to understand the recommended Oracle-supported way to build something similar — for example, a custom website where:

The user enters a SQL SELECT query in a text area.

Clicks “Run Query.”

The site executes the query securely and returns the results in a table format.

My goal is to allow read-only access for specific schemas or BI views for analysis.

I’m looking for guidance on: