ExtendInsights Analytics now includes an AI-powered SuiteQL Query Generator, allowing you to download NetSuite data using natural language. This feature eliminates the need to build saved searches in NetSuite and enables fast, flexible data exploration directly in Excel.
With AI + SuiteQL, you can convert English prompts into SQL, preview results instantly, and automate reports with schedules.
Walkthrough Video
You can watch the walkthrough video to see the AI Query Generator + SuiteQL in action, or follow the step-by-step instructions below.
Before getting started, it’s also helpful to understand the different sections of the workspace you’ll be working in.
➡️ Review the Query Builder Workspace – Interface Overview
Step 1: Enter a Prompt to Generate SuiteQL
In the Query Builder, type a natural-language prompt.
Example
User Input:
Download all contacts
Generated SuiteQL:
SELECT
entityId,
fullName,
email,
phone,
isInactive,
dateCreated
FROM contact
Without creating Saved searches in NetSuite, users can build and run SuiteQL queries directly from the ExtendInsights Application.
Step 2: Validate and Update SuiteQL generated
Preview
Click Preview before downloading the full query.
First 50 rows will show, check the output and refine the SQL as needed.
Edit a Query
To update an existing query:
Select the query to manage using the three-dot menu (…) > Edit to reopen the Query Builder.
Modify SQL manually or regenerate using AI.
ExtendInsights supports both manual SuiteQL editing and AI-assisted generation.
Rename, Add desciption, and Delete a Query
To manage a query, select query from the list then three-dot menu (…):
Rename make query name user friendly.
Add description so teams understand the purpose of each query.
Delete unwanted queries.
Step 3: (Optional): Manually Run or Schedule the Query
ExtendInsights lets you run queries manually or schedule them to auto-refresh.
Adhoc Query Run
From the Query pane.
Click the Refresh button to run the query.
Schedule Management
Check the steps below on how to add schedule to your queries.
Scheduling Prerequisites
Available for trial and Enterprise customers
The Excel file must be saved on OneDrive for Business or SharePoint
Go to Schedule pane
Click the + button to add new schedule or
Select the schedule to manage using the three-dot menu (…):
Assign multiple reports or queries to a schedule
Update Schedules
Unassign/Delete items quickly from the same screen
➡️ See full guide on scheduling queries and saved searches
Support for all Standard and Custom fields
Supports all standard and custom NetSuite fields available to the connected role
Custom fields that the role can see in NetSuite are available for query generation
Notes & Limitations
Approx. 70% accuracy for SuiteQL generation
AI may make mistakes, queries should be reviewed before use
Prompt box is non-conversational; each prompt is treated independently
Supports all languages available in GPT-4.1