invantive documentation
Invantive Support ForumsLog In / Sign Up

Release notes of Invantive Query Tool Multi-Platform

Release Note - Download

Invantive Query Tool Multi-Platform, new in 27.0

Build Date Description
– – the product did not exist
27.0.54 01-11-2026 latest build of release 27.0 at the time of writing

Invantive Query Tool Multi-Platform is an interactive SQL editor for Windows, Linux and macOS. It runs SQL on the Invantive UniversalSQL engine, so the same statements work on the many database and cloud platforms that the engine supports. It is meant for users who develop, test and run SQL and who do not work on Microsoft Windows only. It is a separate product next to Invantive Query Tool for Windows: it uses the same engine, databases, favourites and licence functions, but has a smaller and newer user interface and does not replace the Windows product. The product is new in release 27.0: there is no older release to compare with, so this note lists what the product can do instead of what changed.

  • 45 enhancements
  • 0 bug fixes
  • 3 things to check before upgrading

Before You Upgrade

These changes ask for a check:

Top 25 Changes

  1. Interactive SQL editor on the UniversalSQL engine for Windows, Linux and macOS
    • Enhancement
    • A capability that the new product offers from release 27.0.
  2. Same engine, drivers and settings as the other Invantive products
    • Enhancement
    • A capability that the new product offers from release 27.0.
  3. Self-contained ZIP per operating system and processor architecture
    • Enhancement
    • A capability that the new product offers from release 27.0.
  4. Several query tabs that run statements in parallel
    • Enhancement
    • A capability that the new product offers from release 27.0.
  5. Run the selected text or the statement around the cursor
    • Enhancement
    • A capability that the new product offers from release 27.0.
  6. Execute All runs every statement of the document in order
    • Enhancement
    • A capability that the new product offers from release 27.0.
  7. Results grid with sorting and filters per column
    • Enhancement
    • A capability that the new product offers from release 27.0.
  8. Export results to ten formats
    • Enhancement
    • A capability that the new product offers from release 27.0.
  9. Log on window with databases in groups and a platform icon per database
    • Enhancement
    • A capability that the new product offers from release 27.0.
  10. Licence window to register a key or request a free, trial or public data licence
    • Enhancement
    • A capability that the new product offers from release 27.0.
  11. Available objects tree with tables, views, functions and PSQL packages
    • Enhancement
    • A capability that the new product offers from release 27.0.
  12. macOS application bundle with icon, name in the menu bar and SQL file association
    • Enhancement
    • A capability that the new product offers from release 27.0.
  13. Open SQL files from the menu, the command line or the file manager
    • Enhancement
    • A capability that the new product offers from release 27.0.
  14. Running a script is a licensed function
    • Enhancement
    • A capability that the new product offers from release 27.0.
  15. Local statements and scripting variables
    • Enhancement
    • A capability that the new product offers from release 27.0.
  16. Syntax colouring that follows the words of the connected platform
    • Enhancement
    • A capability that the new product offers from release 27.0.
  17. Progress bar with elapsed time, engine details and a stop button
    • Enhancement
    • A capability that the new product offers from release 27.0.
  18. Group results by dragging a column header
    • Enhancement
    • A capability that the new product offers from release 27.0.
  19. Totals per column: sum, average, count, minimum and maximum
    • Enhancement
    • A capability that the new product offers from release 27.0.
  20. Copy or save the current view as CSV or to the clipboard
    • Enhancement
    • A capability that the new product offers from release 27.0.
  21. Log on with stored or typed credentials and provider-specific settings
    • Enhancement
    • A capability that the new product offers from release 27.0.
  22. Favourite and recently used databases shared with other Invantive products
    • Enhancement
    • A capability that the new product offers from release 27.0.
  23. Discover the databases that are present on the device
    • Enhancement
    • A capability that the new product offers from release 27.0.
  24. Licence key from the command line or an environment variable
    • Enhancement
    • A capability that the new product offers from release 27.0.
  25. Native routines of a platform in the Objects tab
    • Enhancement
    • A capability that the new product offers from release 27.0.

All Enhancements

Changes to behaviour, platforms, drivers and settings, grouped by area.

Installation and platform

Self-contained ZIP per operating system and processor architecture

The product is delivered as one ZIP file for each of Windows x64, Linux x64, Linux ARM64, macOS x64 and macOS ARM64. The ZIP holds the application, the engine and the drivers, so nothing else has to be installed.

What to Do

Download the ZIP for the operating system and processor, extract it in a folder and start the Invantive.QueryTool programme from that folder.

  • importance 5
macOS application bundle with icon, name in the menu bar and SQL file association

On macOS the product can be built as an application bundle for Apple silicon or Intel. The bundle shows the product icon and name and lets Finder open SQL files with the product. It declares macOS 13.0 as the minimum version.

  • importance 3
Command line options with built-in usage text

The option help writes the usage and ends without starting the product or checking a licence. The options can be written as /name, -name or --name. Further options start the interface without the engine, switch off syntax colouring, report keyboard input on the status bar and mark a run as part of an AI agent.

  • importance 2

Licensing and sign-in

Licence window to register a key or request a free, trial or public data licence

On the first start, or when the licence is not valid, a window opens. The user can paste a licence key, accept the licence agreement in English or Dutch, or request a free, trial or public data licence. The window states why it opened. The acceptance is remembered, so it is asked once per device.

What to Do

Register a licence on the first start.

  • importance 4
Running a script is a licensed function

Execute All is refused when the licence does not cover running scripts or the function has not been granted to the user. The message names the function. Running a single statement needs no function in this product.

What to Do

Check that the licence and the user rights include the function for running scripts before using Execute All.

  • importance 3
Log on with stored or typed credentials and provider-specific settings

The user name and password can be left empty to use the keychain or the settings file, or typed for one log on. Settings of the chosen platform are shown with a suitable control, such as a check box, a number box, a date picker or a list. A secret value is hidden.

  • importance 3
Licence key from the command line or an environment variable

A licence key can be given with the licence key option or in the environment variable INVANTIVE_LICENSE_KEY. The option takes precedence. This allows registration without opening the licence window.

  • importance 3
Automatic log on to the last database

An option in the log on window lets the product connect to the chosen database at the next start. The option is only offered when automatic log on is available and the user has the right to use it.

  • importance 2

Security

Reading and writing of script files and clipboard copies are registered

When a script file is opened or saved, the action is registered by the engine as a managed file action, including the size and a possible failure. Copying results to the clipboard goes through a guard that registers the action.

  • importance 2
Marker on the log on window when the product runs within an AI agent

When the product is started in the context of an AI agent, the log on window shows a shield with the letters AI. The tooltip names the type of agent. The command line option for the agent marks a run for tests.

  • importance 2

Scripting

Run the selected text or the statement around the cursor

Execute runs the selected text. Without a selection it runs the statement around the cursor. Statements are separated by an empty line, a line with go or a line with a slash. A trailing semicolon is removed, but a semicolon never separates two statements.

  • importance 4
Execute All runs every statement of the document in order

Execute All splits the document at the separating lines and runs the statements one after the other. It stops at the first statement that fails and reports the number of statements that ran.

  • importance 4
Local statements and scripting variables

Statements that start with local, such as defining a variable or exporting the last result, are handled by the client. Expressions such as a variable in curly brackets are expanded before a statement goes to the engine. Some subscriptions do not permit local statements.

  • importance 3

Query Tool user interface

Interactive SQL editor on the UniversalSQL engine for Windows, Linux and macOS

The product offers one SQL editor with a results grid on all three operating systems. Statements are run by the UniversalSQL engine, so the same SQL works on every platform that the engine can reach.

  • importance 5
Several query tabs that run statements in parallel

Each query tab has its own editor, results and messages. A tab runs one statement at a time, but different tabs can run at the same time. A tab with unsaved text is marked and cannot be closed while a statement is running.

  • importance 4
Results grid with sorting and filters per column

Each column can be sorted. A column filter combines a condition (contains, equals, starts with, greater than, is empty and others) with a selection of distinct values. The value list offers at most 500 values.

  • importance 4
Log on window with databases in groups and a platform icon per database

The log on window lists the licensed databases in groups, each with the icon of its platform. Choosing a database shows its description and the fields it needs. The window opens at start-up when there is no connection yet.

  • importance 4
Available objects tree with tables, views, functions and PSQL packages

The Objects tab shows the tables, views and table functions of every schema of the connected database, and the PSQL packages, functions and procedures of the data dictionary. Selecting an object shows its description. Double-clicking inserts its name or a ready-to-run select statement, limited to at most 5000 rows where the engine evaluates the SQL.

  • importance 4
Open SQL files from the menu, the command line or the file manager

SQL files (.sql, .isql and .txt) open in a query tab through File > Open, through file names on the command line, or on macOS by double-clicking in Finder. Files are saved as UTF-8 without byte order mark.

  • importance 3
Syntax colouring that follows the words of the connected platform

The editor colours keywords, functions and objects from the vocabulary of the session. This is UniversalSQL, or the SQL dialect of the platform on a connection that runs native SQL. The colours are the same as in the Windows product and also suit the dark appearance.

  • importance 3
Progress bar with elapsed time, engine details and a stop button

While a statement runs, the tab shows the elapsed time and what the engine is doing. A stop button cancels the wait. The running statement is not interrupted on the platform; its result is ignored when it finishes.

  • importance 3
Group results by dragging a column header

A column header can be dragged to the group bar above the grid, or grouped from the column menu. Several columns can be grouped and a grouping can be removed again.

  • importance 3
Totals per column: sum, average, count, minimum and maximum

The column menu adds summaries to a column. They show in a total row and in the header of each group.

  • importance 3
Favourite and recently used databases shared with other Invantive products

A star in front of a database pins it as a favourite. Favourites and recently used databases are shown first in the log on window. The lists are kept per user and are the same as in the other Invantive products. A favourite whose database no longer exists stays visible, greyed out, with the reason.

  • importance 3

On macOS the menu is shown in the menu bar of the screen. On Windows and Linux it is shown as a bar in the window, and the shortcuts use the Ctrl key. The menus are File, Edit, Selection, Query, Window and Help. The Help menu opens the documentation and the forums.

  • importance 3
Engine questions and messages shown in windows instead of on the terminal

Questions from the engine (yes or no, yes, no, all or none, text input, choice from a list, XML correction) and error reports are shown as dialogs. The error window shows the message, the action to take and the object concerned in separate fields, with the message code and details.

  • importance 3
Find, select current statement and the usual editing commands

The editor has line numbers, a search panel, undo, redo, cut, copy, paste and select all. A separate command selects the statement around the cursor.

  • importance 2
Fixed columns, hiding of empty columns and refresh of the result

Columns can be pinned so that they stay visible while scrolling. A switch hides columns without any value. Refresh runs the last statement of the tab again.

  • importance 2
Light and dark appearance follow the system

The product follows the light or dark setting of the operating system, also while it runs. The editor colouring changes with it.

  • importance 2
Window position and size are remembered

The product opens on the screen, at the position and in the size that it had when it was closed. When that screen is gone, it falls back to a visible position.

  • importance 2
Warning before unsaved SQL is lost

Closing a tab, closing the window or quitting the product asks for confirmation when a tab holds text that was not saved. Empty tabs do not count.

  • importance 2
Names for screen readers on rows, buttons and fields

Rows of the database and objects trees, buttons that only show an icon, tabs and input fields carry a name that a screen reader can read out.

  • importance 2
About window with product, edition, version and contact details

The About window shows the product name, the audience and edition of the licence, the version, the copyright and the contact details with links to the website, the sales e-mail address and the product forums.

  • importance 1

Platforms and drivers

Same engine, drivers and settings as the other Invantive products

The product contains the same UniversalSQL engine and drivers as the other Invantive products. It reads the databases from the shared settings files and the credentials from the shared keychain, so databases that are already known on the device can be used directly.

  • importance 5
Discover the databases that are present on the device

The Discover Databases window asks all drivers which databases and services they find on the device. The results are grouped by platform and saved, so they appear in the log on window. The function needs the discovery right.

  • importance 3
Native routines of a platform in the Objects tab

On a connection that sends SQL to the platform as typed, the Objects tab shows the packages, procedures and functions of that platform under their schema. Selecting one shows its parameters, and double-clicking inserts a call in the syntax of the platform. PSQL packages of the engine are not shown for such a connection.

  • importance 3

Export and import

Export results to ten formats

The Export menu writes the result of the last statement to Excel, CSV, TSV, text, XML, JSON, NDJSON and to SQL insert, select and create table statements. The statement is run again so that the file holds all rows, not only those on screen.

  • importance 4
Copy or save the current view as CSV or to the clipboard

Two further export entries write the grid as it is shown, with the active filter, order and hidden columns. One saves a CSV file with semicolons as separator in UTF-8; the other puts tab-separated text on the clipboard.

  • importance 3

Logging and diagnostics

Indicator and window for the activity on database and API connections

A coloured dot on the status bar shows how much of the recent time was spent waiting on a database or an API. A click opens a list of the calls with start time in UTC, duration, rows, round trips, cache use and address, with a search box and a detail window. The list can be saved as CSV or NDJSON. The dot stops moving while the interface is blocked.

  • importance 3
Trace from the start with command line options

Options switch trace on, write it to a file and name the folder for the trace files, so that a problem during start-up is in the trace without setting environment variables first. The product writes trace entries with a message code and a logging level.

  • importance 3
Execution profile of statements that are run

Every statement that is run, by hand or as part of Execute All, is registered as a run with statements. The durations can be read afterwards with SQL from the runs and statement executions of the script session.

  • importance 2
Start-up problems are shown in a window

Problems that occur while the engine starts are collected and shown in the error window as soon as the main window is open. The product keeps running, so the cause can be read. A failure while reading the command line ends with exit code 6 and a message on the error output.

  • importance 2

Translations and texts

Interface language can be changed from the Window menu

The language of the interface is chosen in a submenu of the Window menu, which lists the languages that the licence allows. The choice is shared with the other Invantive products on the device. A number of short texts still appear in Dutch whatever language is chosen.

  • importance 3

Documentation

The product has a documentation section of thirteen pages with the topics installation, licence, log on, discovery, statements, objects, results, export, language, command line options and limitations. The Help menu opens the online documentation and the forums.

  • importance 2

Other

Orderly shutdown on log off, termination signals and normal closing

When the window is closed, or the system sends a termination signal, the product stops running work, finishes the registration of the run and ends. This prevents statements that stay in the execution profile as never ended.

  • importance 2

All Bug Fixes

Defects of the older release that are repaired.

None.

Announced, Not Yet Available

  • Seven windows are stubs that report 'not available in this version': diagnostics, keychain, data replicator, help for local statements, feedback, stay informed and preferences.
  • The Objects tab stops at the table or view; the columns of an object are not shown.
  • Double-clicking a PSQL package function, a function or procedure of the data dictionary or a data dictionary view in the Objects tab inserts nothing.
  • Names of tables and columns are not completed while typing.
  • Cancelling a statement does not interrupt it on the platform; only the result is discarded.
  • There is no log off: a database stays connected until the window is closed.
  • A value that holds a document or image is shown as [BLOB] and cannot be opened or saved from the grid.
  • Refresh and the export menu report that there is nothing to work with after Execute All, because no single statement is remembered.
  • Export to PDF, Word, XPS, HTML and RTF, and printing, are not offered; the README also lists charts and dashboards as absent.
  • The load graph and the overlay of the activity indicator are not implemented; the dot stops while the interface thread is blocked.
  • Pre-emptive loading of metadata after the object list has loaded is only a design (NEXT_STEPS item 15) and has no code in the repository.
  • The discovery window shows grouped tiles only; the per-driver rows with help links and action buttons of the Windows window are not built.
  • The macOS bundle is signed ad hoc only; Developer ID signing and notarisation are left to the release build.
  • Running a single statement, or a selected document with Execute, is not checked against a licensed function; only Execute All is.
  • The menu bar on Linux and the menu captions on macOS were not verified after the menu rewrite; only Windows was verified.
  • Some texts are still hard-coded Dutch, among them the filter operators and summary names of the column menu, the status texts for preparing, executing and cancelling, and the keyboard diagnosis texts.
  • No installer script or package-manager package (MSI, Chocolatey, NuGet) for this product was found in the repository, although product-orig.json names package identifiers; delivery is by ZIP.

Differences from Windows Edition

  • The Windows Query Tool exports results to Adobe PDF, Microsoft Word, XPS, HTML, RTF and JSON data set as well; this product offers ten engine formats and no document formats or printing.
  • The Windows Query Tool has a preferences window and a keychain window; here both only report that the window is not available.
  • The Windows Query Tool has a diagnostics window and data replicator windows; here the diagnostics and data replicator entries only report that the window is not available.
  • The Windows Query Tool completes keywords while typing in its SQL editor; this product only colours the SQL.
  • The Windows products show a load graph of the connection activity next to the dot; this product has the dot and the list of calls only.
  • The Windows Query Tool uses the complete Invantive Producer interface on Windows only; this product has a smaller interface and one window layout for all three operating systems.

What It Builds On

Kind Name From To
invantive component Invantive Query Tool Multi-Platform 27.0.54
invantive component Invantive(R) Basics 27.0.93
invantive component Invantive(R) Producer GUI Base 27.0.93
invantive component Invantive(R) Producer Data Model 27.0.93
invantive component Invantive(R) SQL for Core 27.0.93
invantive component Invantive(R) SQL 27.0.93
invantive component Invantive(R) SQL for Windows 27.0.93
build tool Invantive Deploy 27.0.93
third party summary

More Information

How This Note Was Made

  • Not verified by a second reading: the capabilities come from one reading of the documents and source.
  • The product did not exist in the previous release, so there is no range of commits to compare.
  • The capabilities were read from the documents and the source of the newer state by one reader; each item names no commits.
  • Items that are designed but not built at the newer state are not listed; they are recorded as not yet available.