Every Oracle Fusion Developer knows that writing SQL is only half the job. The moment a BI Publisher report goes live, the change requests start rolling in:
“Can you add the email column?”
“Can we group this by location?”,
“Can you add a new date parameter?”
For a simple query, these changes take only a minute. But with real-world Oracle Fusion SQL, packed with multiple WITH clauses, nested subqueries, complex joins, and long SELECT lists even a small update can mean searching through hundreds of lines of code and carefully making changes without breaking the query.
At DataFusing, we saw the same challenge across Oracle Fusion reporting teams: developers weren’t just writing SQL they were constantly rewriting it.
This is where AI takes the complexity out of SQL editing.
CloudSQL’s built-in AI Agent lets you modify Oracle Fusion SQL just as you would ask a colleague in plain English without manually searching through the query yourself.
In this article, you will see how CloudSQL’s new Modify with AI feature helps you in Oracle Fusion SQL Modifications in seconds while keeping you in complete control of the final query.
Meet Modify with AI
Modify with AI is the next evolution of CloudSQL’s AI Agent. While FixwithAI helps resolve Oracle SQL errors, Modify with AI lets you update working queries add columns, change filters, swap joins, or even restructure SQL all with simple instructions typed directly into the SQL editor.
There’s no need to copy your SQL into a separate AI tool or manually search through the query. Simply describe the change, and the AI Agent takes care of the rest.
Step 1: Invoke Modify with AI
After launching Modify with AI, you can access it in two convenient ways:
- Using the Context Menu: Right-click your SQL query and select Modify with AI.
- Using the Modify with AI Button: Click the Modify with AI button available in the toolbar to start modifying your SQL.
Choose the method that best fits your Development both provide the same AI-powered SQL modification experience.
Step 2: Describe Your Changes in Plain English
The side panel opens, ready for your instructions.
Simply tell the AI Agent what you want to change. For example, you might type:
- “Change the salary condition from >5000 to >10000.”
- “Add employee email and phone number to the SELECT list.”
- “Group the results by department and location.”
The AI Agent analyzes your SQL, understands its structure, and applies the requested changes automatically no need to search for the exact lines yourself.
Step 3: Test the Modified SQL
As with any AI-assisted change, always validate the modified SQL before using it. CloudSQL lets you run the updated query directly from the AI panel, so you can verify the changes before replacing the original SQL.
Step 4: Review the Updated SQL Side by Side
Once the AI applies the changes, review what has been modified. CloudSQL lets you compare the original SQL and the modified SQL side by side, making it easy to verify every change. You can open this comparison directly from the chat panel.
Every change whether it’s a new column, an updated WHERE clause, or a swapped table is clearly highlighted, so you can quickly see exactly what changed. You stay in control of every change while the AI handles the repetitive editing.
Step 5: Keep Refining, One Instruction at a Time
Query requirements rarely change just once. Modify with AI is built for exactly that. Keep giving new instructions, and the AI Agent will apply them to the same query helping you refine your SQL through a natural conversation instead of lengthy man ual edits.
Must Read: How to Fix Oracle Fusion SQL With CloudSQL’s AI Agent?
Common SQL Modifications You Can Make
Modify with AI supports a wide range of SQL changes. Some of the most common include:
| Modification Type | Example Instruction |
|---|---|
| Modify WHERE Conditions | “Change the salary condition from >5000 to >10000.” |
| Add Columns | “ Include employee email and phone number from tables per_email_addresses and per_phones.” |
| Remove Columns | “Remove Address and Mobile columns.” |
| Add GROUP BY | “Group by Business Group” |
| Modify GROUP BY | “Group by Business Group and Legislation Code” |
| Add JOIN | “Join with PER_PEOPLE_LEGISLATIVE_F table.” |
| Remove JOIN | “Remove the Legislative information table and corresponding joins” |
| Modify Table Alias | “Add all missing table aliases as table name abbreviations” |
| Convert SQL Style | “Rewrite ANSI style joins to Oracle style” |
| Optimize SQL | “Optimize this query for better performance.” |
| Simplify SQL | “Make this SQL easier to read.” |
| Add Comments | “Add comments explaining each section.” |
| Refactor SQL | “Refactor SQL by changing nested SQLs into WITH clause” |
| Explain SQL | “Explain this SQL to me” |
These are just a few examples. The AI Agent understands a wide range of everyday SQL requests, so you can simply describe the change in your own words.
AI That Enhances Every SQL Development
The goal of ModifyWithAI is not to replace your SQL expertise. Oracle Fusion reporting still relies on understanding business objects, security predicates, and table relationships knowledge only the developer has.
Instead, Modify with AI removes the repetitive work finding the right clause, updating joins, and renaming aliases so developers can focus on building the right report.
By combining AI assistance with developer expertise, teams can adapt to changing report requirements in minutes instead of hours.
Final Thoughts
Oracle Fusion SQL rarely stays the same. Requirements evolve, new columns are added, and queries need to be updated often multiple times. With CloudSQL’s Modify with AI, you can:
- Update SQL using plain English instructions
- Add, remove, or change columns, filters, joins, and grouping in seconds
- Review every change side by side before accepting it
- Test modified SQL immediately
- Keep refining the same query through multiple instructions
Whether you are building BI Publisher reports, OTBI analyses, data migration queries, or integration extracts, CloudSQL helps you keep up with changing Oracle Fusion SQL requirements without the manual rework.
Ready to see Modify with AI in action? Download the free trial and experience a faster, smarter way to modify Oracle Fusion SQL.
Suggested Read: SQL to Get Person Details from Oracle HCM
