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. |
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
This Note
Before You Upgrade
These changes ask for a check:
- Self-contained ZIP per operating system and processor architecture
- Download the ZIP for the operating system and processor, extract it in a folder and start the Invantive.QueryTool programme from that folder.
- Running a script is a licensed function
- Check that the licence and the user rights include the function for running scripts before using Execute All.
- Licence window to register a key or request a free, trial or public data licence
- Register a licence on the first start.
Top 25 Changes
- Interactive SQL editor on the UniversalSQL engine for Windows, Linux and macOS
- Enhancement
- A capability that the new product offers from release 27.0.
- Same engine, drivers and settings as the other Invantive products
- Enhancement
- A capability that the new product offers from release 27.0.
- Self-contained ZIP per operating system and processor architecture
- Enhancement
- A capability that the new product offers from release 27.0.
- Several query tabs that run statements in parallel
- Enhancement
- A capability that the new product offers from release 27.0.
- Run the selected text or the statement around the cursor
- Enhancement
- A capability that the new product offers from release 27.0.
- Execute All runs every statement of the document in order
- Enhancement
- A capability that the new product offers from release 27.0.
- Results grid with sorting and filters per column
- Enhancement
- A capability that the new product offers from release 27.0.
- Export results to ten formats
- Enhancement
- A capability that the new product offers from release 27.0.
- 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.
- 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.
- Available objects tree with tables, views, functions and PSQL packages
- Enhancement
- A capability that the new product offers from release 27.0.
- 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.
- 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.
- Running a script is a licensed function
- Enhancement
- A capability that the new product offers from release 27.0.
- Local statements and scripting variables
- Enhancement
- A capability that the new product offers from release 27.0.
- Syntax colouring that follows the words of the connected platform
- Enhancement
- A capability that the new product offers from release 27.0.
- Progress bar with elapsed time, engine details and a stop button
- Enhancement
- A capability that the new product offers from release 27.0.
- Group results by dragging a column header
- Enhancement
- A capability that the new product offers from release 27.0.
- Totals per column: sum, average, count, minimum and maximum
- Enhancement
- A capability that the new product offers from release 27.0.
- Copy or save the current view as CSV or to the clipboard
- Enhancement
- A capability that the new product offers from release 27.0.
- Log on with stored or typed credentials and provider-specific settings
- Enhancement
- A capability that the new product offers from release 27.0.
- Favourite and recently used databases shared with other Invantive products
- Enhancement
- A capability that the new product offers from release 27.0.
- Discover the databases that are present on the device
- Enhancement
- A capability that the new product offers from release 27.0.
- Licence key from the command line or an environment variable
- Enhancement
- A capability that the new product offers from release 27.0.
- 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.
Importance: all | 2 and higher | 3 and higher | 4 and higher | 5
0 of 45 shown.
None.
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.