Transform SQL Queries to BQL using Oracle AI Agent

This article explains how to use the built-in, template-driven workflow in Oracle Fusion AI Agent Studio to convert standard SQL queries into Business Query Language (BQL) for data extraction with Oracle RODS APIs.

1. Navigate to AI Agent Studio

In Oracle Fusion Cloud, go to Tools -> AI Agent Studio.

2. Search for the Pre-Built Agent Template

On the home page, search for the Data Extraction Query Transformer Workflow agent.

3. Create the Agent Team from Template

• Click Use Template.
• Enter an Agent Name and Agent Code (a simple approach is to add a custom prefix or suffix to the standard name).

4. Review the Created AI Agent

Once created, your AI Agent workflow is ready for testing.

5. Test the Query Transformation

• Provide an Oracle SQL query prompt to the agent. For example
• SELECT header_id, order_number FROM doo_headers_all WHERE header_id = 123456;

• The Agent validates the input query and requests human approval before proceeding.

• Once approved, the Agent converts the SQL query into the equivalent BQL query.