invantive documentation
Invantive Support ForumsLog In / Sign Up

Release notes of Invantive Query Tool for Windows

Release Note - Installer

Invantive Query Tool for Windows 27.0, from 26.0

Build Date Description Platform
26.0.4 22-03-2026 first build of release 26.0 64-bit Windows; .NET 10
27.0.92 09-11-2026 latest build of release 27.0 at the time of writing 64-bit Windows 10 version 1809 or later; .NET 10

The older state is the first build of release 26.0, not its last: later builds of 26.0 received ports of changes made for 27.0, so those changes are part of this step. The 27.0 line also contains the beta builds 26.1.x.

  • 203 enhancements
  • 177 bug fixes
  • 14 things to check before upgrading

Before You Upgrade

These changes ask for a check:

Top 25 Changes

  1. The Progress panel replaces Explain Plan and shows live how a statement runs
    • Enhancement
    • A statement is drawn while it runs: a card per step and platform, the rows flowing between steps, time, calls and bytes, live figures within a running step and an estimate of the time left. Reads over many files, bulk inserts, internet crawls and streaming reads report their progress, and the tab of a document shows a turning ring while its statement runs.
  2. Settings files move from XML to JSON
    • Enhancement
    • action needed
    • Action needed before or after the upgrade.
  3. More work is sent to the platform: row limit, grouping, selected columns and joins
    • Enhancement
    • A query with LIMIT or TOP is limited by the platform, COUNT, SUM and other group functions are answered by the platform on supported drivers, only the columns that a query needs are requested, join conditions are forwarded, an exists condition on a child table reaches the platform, and OData platforms get shorter filters with the IN operator. Fewer rows are transferred.
  4. Parts of a PSQL block can run in parallel
    • Enhancement
    • PSQL gets a PARALLEL construct that runs branches and loop iterations side by side, SYNCHRONIZE accepts a parallel option, and the package dbms_atomic holds values that parallel branches share safely.
  5. Correlated subqueries are supported
    • Enhancement
    • A subquery can refer to columns of the outer query, as in EXISTS, IN and scalar subqueries. A subquery without outer references is evaluated once per statement and its answer is reused.
  6. A dark appearance that follows the Windows app theme
    • Enhancement
    • The windows, the SQL editor, grids, ribbon, dialogs, scroll bars and tool windows follow the dark appearance when Windows is set to dark mode, including the windows for plug-ins, parameters and running a script.
  7. The Connection Monitor shows the calls of the application to databases and platforms
    • Enhancement
    • A dot shows whether the application talks to a database or platform. It opens a window with the calls, their moment in UTC, duration, rows, bytes and the action, with a load graph; running calls show the time and rows so far.
  8. Joins return the correct rows
    • Bug Fix
    • A left, right or full join written without the word OUTER was executed as an inner join and lost rows. A right outer join placed columns in the wrong order, a condition in ON removed rows, a cross join dropped its right-hand side, and a full outer join that could not be answered was not reported.
  9. Data containers and credentials from Invantive Credentials Server
    • Enhancement
    • A database definition can point to Invantive Credentials Server, which supplies the data containers and sign-in credentials. The log-on window and the partition menu show these containers with their own icon, errors of the server are shown with their details, and a retrieval is repeated after a time-out.
  10. Scripts can run operating system commands with the new package dbms_os
    • Enhancement
    • The package dbms_os runs an operating system command with environment variables and a time limit, returns its output and exit code, and calculates a file hash. A command that runs too long is ended together with the programs it started. Files it writes are UTF-8 without byte order mark.
  11. Data is loaded in the background while a session is idle
    • Enhancement
    • A connected session fills caches with predictable data, such as the tables read in the last fourteen days and the incremental tables of Exact Online, Freshdesk and Freshservice, using spare rate allowance. Four loads run in parallel, partitions can be chosen, and the connection monitor shows the loads.
  12. The legacy Oracle driver and the Invantive Web Service driver are removed; Oracle 18 is the minimum
    • Enhancement
    • action needed
    • Action needed before or after the upgrade.
  13. Filters no longer lose rows or evaluate wrongly
    • Bug Fix
    • A condition such as a and (b or c) could return too few rows, lower and upper case conversions and decimal constants were not sent correctly to SQL databases, NOT LIKE dropped rows that differ only in case, and x between 1 and 2 and y = 1 was read wrongly.
  14. Results of every platform are read while scrolling, ahead of the view
    • Enhancement
    • The results grid shows the first rows quickly and reads further rows in the background as the grid is scrolled, for every platform and not only for Oracle and MySQL. A statement with a trailing line comment on Oracle no longer fails.
  15. Loading of provider assemblies from a settings file is blocked
    • Enhancement
    • action needed
    • Action needed before or after the upgrade.
  16. Add, edit, test and delete database definitions in the Discover Databases window
    • Enhancement
    • The Discover Databases window can add, edit, duplicate, test and delete a database definition on the screen. Settings files are validated and saved without losing members, and the editor has rights for deleting a database and managing settings files.
  17. Invantive License Service: clearer messages, grace period and new modules
    • Enhancement
    • A licence key of the wrong type is explained, a licence service that is unavailable gets a specific message, and a licence that was valid stays in force for a grace period when the service cannot be reached. The check that prolongs a licence runs hourly. New licence modules exist for the Support Assistant, OEM use and subscription software, the built-in trial and open data keys use the new format, and text-mode products show tips about the licence in use.
  18. New platforms: Inspectlet, Matomo, Nextcloud and Tweede Kamer v5
    • Enhancement
    • Four new drivers read Inspectlet (websites and recorded sessions), Matomo web analytics with a package of PSQL procedures, a Nextcloud server (tables depend on the installed apps) and the Tweede Kamer open data on the new API. The earlier Tweede Kamer driver remains available. Each platform has a licence module and an icon.
  19. DeepL driver
    • Enhancement
    • A new driver reads and writes DeepL: languages, billing, translation, writing assistance, documents, glossaries, style rules and translation memories.
  20. Visma.net: new API specification, Visma Connect log-on and the Sales Order APIs
    • Enhancement
    • The Visma.net driver uses the API specification of 18 June 2026 and the new Visma Connect sign-in, and adds tables for the Sales Order APIs with server-side filtering, insert and update. Filters such as not in and not equal on a column with a fixed list of values are sent as requests for the remaining values.
  21. Exact Online incremental tables reload less often and are read faster
    • Enhancement
    • Incremental tables avoid full reloads caused by a rejected previous image or a row count guard, are read from the cache up to six times faster, and stop an incremental run when the deleted rows needed are older than the platform keeps them. The new table IncrementalEntityTypes lists the entity types that can be loaded incrementally.
  22. Big Data JSON reads files much faster and skips files that cannot match
    • Enhancement
    • Collections of NDJSON files, plain or Zstandard compressed, are streamed and only the needed columns are built. A directory gets an index with value ranges, Bloom filters and counts, so filters, counts and group-by statements read fewer files.
  23. Long operations can be cancelled and react quickly
    • Enhancement
    • A stop button ends a Data Loader run and operations such as synchronize and loops of a script, and the stop window names the operation and its progress. Cancelling also stops slow web requests, waits between retries and compression, and closing the application ends its work within a set time.
  24. A script can query its own execution profile
    • Enhancement
    • Runs of Invantive Script, their statements, started operating system commands, variables and exit codes are registered and can be queried with plain SQL through the new data container Script. The name of the profile log can be chosen, and statements register the memory they allocated.
  25. Available Objects handles tens of thousands of objects and lists native packages
    • Enhancement
    • The tree builds and refreshes faster with 30,000 or more objects, shows details of the selected data container beside it, an overlay names the step while it is filled, and a connection that sends statements natively to Oracle, MySQL, PostgreSQL or SQL Server lists the stored packages, procedures and functions, which Describe shows with their parameters.

All Enhancements

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

Importance: all | 2 and higher | 3 and higher | 4 and higher | 5

Platform: all | AccountView (1) | ActiveCampaign (3) | AFAS (1) | AFAS Online (3) | AFAS Profit (1) | Autotask (1) | Big Data JSON (2) | Brevo (2) | Bridge Online (4) | CBS (1) | Chargebee (1) | Crisp (4) | Data Cache (1) | DeepL (1) | Discourse (1) | Dropbox (1) | Dynamics 365 CRM (2) | Dynamics CRM (2) | Easyflex (1) | EDIFACT (1) | Exact Online (37) | File system (2) | Firebird (2) | Fortnox (1) | FoxPro (1) | Freshdesk (3) | Freshservice (2) | FTP (1) | Gripp (2) | Gripp CRM (2) | HubSpot (3) | IBM Db2 (1) | In-memory (2) | In-memory storage (2) | Inspectlet (2) | Invantive Bridge Online (1) | Invantive Business (2) | Invantive Credentials Server (1) | Invantive Estate (1) | Invantive Web Service (1) | ionBIZ (1) | Kadaster (1) | LinkedIn (1) | Logius COR (1) | Loket (1) | Loket.nl (2) | Magento (4) | MariaDB (1) | Matomo (2) | Mendix (1) | Microsoft Access (1) | Microsoft Dynamics CRM (1) | Microsoft Graph (1) | MySQL (11) | Nextcloud (1) | Nmbrs (2) | OData (1) | ODBC (3) | Odoo (4) | Open Archives (2) | Open Besluitvorming (1) | Oracle (22) | Ossus (1) | PayPal (2) | Pipedrive (1) | PostgreSQL (16) | Rabobank MT940 (1) | RDW (2) | Robaws (3) | Salesforce (1) | SFTP (1) | Slack (1) | SnelStart (5) | SQL Server (16) | StackExchange (1) | Stripo (2) | Stripo Email (1) | Teamleader (1) | Teamleader Focus (2) | TeamViewer (1) | Teradata (1) | Tixly (1) | Tweede Kamer (2) | Twinfield (7) | Twitter (1) | VIES (1) | Visma Severa (1) | Visma.net (5) | Wikipedia (2) | Windows WMI (2) | WMI (1) | XAA (1) | XAF (1) | Yuki (5)

16 of 380 shown.

Security

Prevent SQL injection through inlined values on MySQL and PostgreSQL

String values that are placed in generated SQL for MySQL are now escaped for backslashes as well as quotes. A PostgreSQL session now sets standard_conforming_strings to on and fails with an error when the server does not accept this.

  • MySQL
  • PostgreSQL
  • importance 3
Find objects through synonyms and hide credentials in logged pass-through SQL

Object names from Oracle and PostgreSQL account for private synonyms. A logged pass-through statement that carries credentials is no longer shown in full.

  • Oracle
  • PostgreSQL
  • importance 2

SQL engine

Clear error when a PostgreSQL connection has no host

A PostgreSQL connection string without a host now gives an error that says so, instead of a message about a null value.

  • PostgreSQL
  • importance 2

Query Tool user interface

The Progress panel replaces Explain Plan and shows live how a statement runs

A statement is drawn while it runs: a card per step and platform, the rows flowing between steps, time, calls and bytes, live figures within a running step and an estimate of the time left. Reads over many files, bulk inserts, internet crawls and streaming reads report their progress, and the tab of a document shows a turning ring while its statement runs.

  • Big Data JSON
  • Exact Online
  • Oracle
  • PostgreSQL
  • SQL Server
  • importance 5

Progress in Invantive Query Tool

Available Objects handles tens of thousands of objects and lists native packages

The tree builds and refreshes faster with 30,000 or more objects, shows details of the selected data container beside it, an overlay names the step while it is filled, and a connection that sends statements natively to Oracle, MySQL, PostgreSQL or SQL Server lists the stored packages, procedures and functions, which Describe shows with their parameters.

  • MySQL
  • Oracle
  • PostgreSQL
  • SQL Server
  • importance 4

Available Objects, Describe an object

Platforms and drivers

PostgreSQL: setting fail-on-missing-tables

A new setting fail-on-missing-tables on the PostgreSQL driver controls the check that every primary key in the metadata has an accessible table or view. When off, the check is skipped.

  • PostgreSQL
  • importance 3
Set the idle period before SQL connections are closed

A new provider attribute sets after how many seconds an idle connection to a SQL database is closed. Server products keep connections for 300 seconds by default.

  • SQL Server
  • MySQL
  • PostgreSQL
  • Oracle
  • importance 3
Register the number of rows of tables as statistic for SQL Server, MySQL and PostgreSQL

The row count that the catalogue of the database knows is registered per table, so that the engine can plan and report with it.

  • SQL Server
  • MySQL
  • PostgreSQL
  • importance 2

Performance

More work is sent to the platform: row limit, grouping, selected columns and joins

A query with LIMIT or TOP is limited by the platform, COUNT, SUM and other group functions are answered by the platform on supported drivers, only the columns that a query needs are requested, join conditions are forwarded, an exists condition on a child table reaches the platform, and OData platforms get shorter filters with the IN operator. Fewer rows are transferred.

  • ActiveCampaign
  • Bridge Online
  • Crisp
  • Exact Online
  • IBM Db2
  • Inspectlet
  • Invantive Bridge Online
  • Matomo
  • MySQL
  • ODBC
  • OData
  • Odoo
  • Oracle
  • PayPal
  • PostgreSQL
  • SQL Server
  • Tweede Kamer
  • importance 5
Disable GSS (Kerberos) negotiation on PostgreSQL connections for faster log-on

Every new PostgreSQL connection first asked the server for Kerberos encryption, which servers without Kerberos refuse by closing the connection. The setting is now disabled by default, which makes opening connections faster.

  • PostgreSQL
  • importance 3
Lower memory use and faster processing

Encryption, compression, logging, translations, JSON reading, sorting, the in-memory driver and long-running sessions allocate less memory and use less CPU time. Creating a table from a large result streams the rows, and several string functions run faster.

  • Exact Online
  • In-memory
  • MySQL
  • Oracle
  • PostgreSQL
  • SQL Server
  • XAF
  • importance 3

Translations and texts

More messages and hints in the language of the user

Error messages and hints of the engine and several drivers (OAuth, PostgreSQL, Tixly, Twinfield, Gripp, Crisp, Odoo) are available in more languages, Hindi is a known interface language, and singular units are used in durations.

  • Crisp
  • Gripp
  • Odoo
  • PostgreSQL
  • Tixly
  • Twinfield
  • importance 2

All Bug Fixes

Defects of the older release that are repaired.

SQL engine

Send the correct value for user functions in set-based updates

An update such as set modified_by = user, or with coalesce over the user, sent a null to the database instead of the name of the logged-on user. A not-null column then refused the update, for example on PostgreSQL.

  • PostgreSQL
  • importance 3

Platforms and drivers

PostgreSQL: metadata of data types with missing names no longer fails

The driver for ADO.NET based databases no longer stops with error itgenase518 when a data type has no data type name, and it accepts a column name that differs only in casing, as Npgsql uses.

  • PostgreSQL
  • importance 2
Read DateOnly values from PostgreSQL on .NET

A date column of PostgreSQL raised an error in the .NET version of the product because the driver returns a DateOnly value. The value is now read as a date.

  • PostgreSQL
  • importance 2
Spelling error in a PostgreSQL error hint corrected

The hint of the error about unknown table columns on PostgreSQL contained a spelling error.

  • PostgreSQL
  • importance 1

What It Builds On

Kind Name From To
invantive component Invantive Query Tool 26.0.4 27.0.92
invantive component Invantive Producer Windows 26.0.4 27.0.92
invantive component Invantive Producer Base 26.0.4 27.0.92
invantive component Invantive Producer Data 26.0.4 27.0.92
invantive component Invantive SQL for Core 26.0.4 27.0.92
invantive component Invantive SQL for Windows 26.0.4 27.0.92
invantive component Invantive SQL 26.0.4 27.0.92
invantive component Invantive Basics 26.0.4 27.0.92
build tool Invantive Deploy 26.0.4 27.0.92
build tool change Installing and upgrading a .NET 10 product no longer runs the NGEN tool per assembly
build tool change Installer shows an error when another installation is already running
build tool change Final installer window shows the version link
build tool change Progress bar of the installer follows the measured duration of the installation stages
build tool change Installer windows flicker less when moving to the next step
build tool change Installer no longer stalls on an unreachable Customer Service and cancels reliably
build tool change Installer explains in a window why installation settings cannot be downloaded
build tool change Maintenance window checks that the product is still installed
build tool change Installer shows unexpected errors in its own window
build tool change Repair Office add-in name, optional email check and installs run as SYSTEM
build tool change Installs run as SYSTEM are attributed to the end user, not to the SYSTEM account
build tool change Each product gets one .NET 10 installer; the .NET Framework installer is no longer built
build tool change Installer includes the files .NET needs to find native libraries such as WebView2
build tool change Installer carries native runtime folders and Catalan, Hungarian and Romanian resources
build tool change Installer no longer includes the crash dump tool
build tool change Supported Windows versions in release information follow mainstream support dates
build tool change Installer writes its trace to the Invantive Trace folder when trace to file is on
build tool change Installer texts for new messages are available in all supported languages
build tool change Installer email step rejects example and test domains
target framework Invantive.Producer:src/Invantive.Producer.QueryTool/Invantive.Producer.QueryTool.csproj net10.0-windows
target framework Invantive.Producer:src/Invantive.Producer.QueryTool.Setup/Invantive.Producer.QueryTool.Setup.csproj net48
target framework Invantive.Producer:src/Invantive.Producer.Windows.Forms/Invantive.Producer.Windows.Forms.csproj net48;net10.0-windows
target framework Invantive.Producer:src/Invantive.Producer.QueryTool/Invantive.Producer.QueryTool.Build.csproj net10.0-windows10.0.17763.0
target framework Invantive.Producer:src/Invantive.Producer.QueryTool.Setup/Invantive.Producer.QueryTool.Setup.Build.csproj net48
target framework Invantive.Producer:src/Invantive.Producer.Windows.Forms/Invantive.Producer.Windows.Forms.Build.csproj net48;net10.0-windows10.0.17763.0
third party changed Infragistics.WPF 23.1.41 26.1.14
third party changed Oracle.ManagedDataAccess 23.26.100 23.26.300
third party changed Oracle.ManagedDataAccess.Core 23.26.100 23.26.301
third party changed Microsoft.Data.SqlClient 7.0.0 7.1.1
third party changed Npgsql 10.0.2, 8.0.9 10.0.3
third party changed Microsoft.Web.WebView2 1.0.3856.49 1.0.4129.50
third party changed EPPlus 8.5.0 8.6.3
third party changed QuestPDF 2026.2.3 2026.7.2
third party changed FluentFTP 53.0.2 54.2.0
third party changed SSH.NET 2025.1.0 2026.0.0
third party changed Dirkster.AvalonDock 4.72.0 4.74.1
third party changed AWSSDK.S3 4.0.19 4.0.102
third party changed Elastic.Clients.Elasticsearch 9.3.3 9.5.0
third party changed Microsoft.SqlServer.SqlManagementObjects 181.15.0 181.25.0
third party added Dirkster.AvalonDock.Themes.VS2013 4.74.1
third party added Nodify 7.3.0
third party added QRCoder 1.8.0
third party added Scintilla5.NET 7.0.0
third party added System.IO.Hashing 10.0.13
third party added System.Linq.Async 7.0.1
third party added System.Reflection.Metadata 10.0.12
third party added System.Resources.Extensions 10.0.12
third party added System.Security.Cryptography.Xml 10.0.13
third party added ZstdSharp.Port 0.8.8
third party summary

More Information

How This Note Was Made

  • None of the 12 flagged items was already in the first build of 26.0 (10 new, 2 partly new with narrowed text); the one exclusion on content was refuted and its item is published.
  • Range: commits of origin/release-27.0 that are not reachable from the first build of release 26.0 (stamp 26.0.4, per repository). Commits that were ported to later builds of 26.0 are therefore included.
  • Scope: commits that touch a project of the product, found through the solution and its project references; test projects are left out.
  • Version stamp commits of the build pipeline are left out.
  • A change whose changed lines are for 70 % or more already in the first 26.0 build is left out; items between 50 % and 70 % and all such exclusions were checked by reading the code of that build.
  • A bug fix whose repaired lines were written by another commit of the same range is merged into its feature or left out.
  • Texts were written from the commit messages and from the changes themselves; items carry a confidence.
  • 1346 links between a change and a source commit are recorded.
  • 66 exclusions are recorded in the audit of the note.