When I announced the SuiteQL Query Tool v2026.1 back in January, I covered the foundation: the modernized interface, AI integration, dark mode, and query history. Since then, the beta has continued to evolve based on testing and feedback.
Beta 09 is now available, and it includes some significant additions. Here's what's new.
Clickable Record Links
This one's simple but immediately useful: ID columns in your query results now automatically link to their NetSuite records.
Click a customer ID and the customer record opens in a new tab. Same for vendors, employees, transactions, items, subsidiaries, departments, classes, locations, accounts—the tool recognizes the context and builds the right URL.
It works in all three view modes (Table, DataTable, and Row Details) and can be toggled off in the Options panel if you prefer plain numbers. But once you've used it, you probably won't turn it off.
Plugin Architecture
This is the biggest addition in Beta 09, and it opens up possibilities I'm excited to see people explore.
Plugins are self-contained JavaScript files that live in your NetSuite File Cabinet. Point the Query Tool at a folder (via CONFIG.PLUGIN_FOLDER_ID), and it automatically loads any *.sqt-plugin.js files it finds there.
Server-Side Hooks
Plugins can intercept queries at three points:
- onBeforeQuery — Modify queries before they run, add logging, or enforce policies
- onAfterQuery — Process results, add calculated fields, or push data to external systems
- onError — Custom error handling, alerting, or recovery logic
Client-Side Hooks
On the browser side, plugins can respond to:
- onInit — Run setup code when the app loads
- onBeforeQuery / onAfterQuery — Client-side query lifecycle
- onResultsDisplay — Customize how results render
- onBeforeExport / onAfterExport — Hook into the export process
- onEditorChange — React to editor changes in real-time
UI Injection Points
Plugins can add custom buttons, panels, and indicators to 17 different locations throughout the interface: toolbar start/end, dropdown menus, header, editor area, results header/footer, sidebar, options panel, status bar, and modal containers.
Want to add a button that exports to your company's internal BI tool? Write a plugin. Need to log every query to a custom record for compliance? Plugin. Want to add a custom panel that shows related saved searches? Plugin.
I've included a sample plugin (query-logger.sqt-plugin.js) that demonstrates the patterns—it logs queries to the console and adds a status bar indicator.
Data Visualization with Charts
Query results tell you something. Visualized results tell you more.
The new Chart feature (button in the results toolbar) turns any result set into a bar, line, pie, doughnut, or polar area chart. Select your label column (X-axis) and one or more value columns (Y-axis), and the chart renders instantly.
If you'd rather not configure it manually, describe what you want in plain English: "pie chart showing sales by region" or "monthly revenue as a line chart." The AI figures out which columns to use.
Charts adapt to your current theme (light or dark) and can be exported as PNG images for reports and presentations.
Editor and AI Improvements
A few targeted enhancements to the editing experience:
BUILTIN Syntax Highlighting — NetSuite's BUILTIN functions (BUILTIN.DF, BUILTIN.CONSOLIDATE, BUILTIN.CURRENCY, etc.) now get their own syntax highlighting in the editor. Easier to spot at a glance.
Improved SQL Formatter — Better keyword detection that avoids false positives within identifiers, proper CASE/WHEN/THEN/ELSE formatting, and cleaner handling of UNION/INTERSECT/EXCEPT.
OpenAI-Compatible Provider — Beyond the built-in providers (Claude, GPT, Gemini, Cohere, Grok, Mistral), you can now configure any OpenAI-compatible endpoint. This means OpenRouter, Azure OpenAI, Together AI, or even local models via Ollama all work. Just enter the base URL and model name.
Schema Explorer Refinements
The Schema Explorer now has collapsible sections for Build Schema and Export Schema, with the collapsed state persisting to localStorage. It's a small thing, but it keeps the interface cleaner when you're focused on one task.
Also fixed: a bug in NetSuite's Records Catalog API sometimes returns malformed labels like [Missing Label:...]. The Schema Explorer now extracts the class name from the metadata and displays it cleanly, with a warning indicator so you know the label was derived.
Try Beta 09
If you're already running a previous beta, upgrading is just replacing the script file. Your query history, preferences, and schema data are stored in your browser, so everything carries over.
For feedback, the best place is the SuiteQL Query Tool LinkedIn group. Bug reports, feature requests, and general thoughts are all welcome—there's still time to shape the final release.