Release notes

Developed as 3.25. Five areas changed enough that a minor number would have understated it, so 3.24 is followed by 4.00. Installing and updating work as before.

If you used the old Query Cloud, read the migration note in the full changelog before you update — the old source definitions are not carried over, and the file they lived in holds your source passwords in plain text.

• ENH Query Cloud now joins several databases in a single query. An IRIS table against a PostgreSQL table and a CSV folder, in one statement. The old local copy is gone; the federation runs on Apache Calcite and queries every source through its own connection, pushing filters, joins and aggregations down into each source wherever it can. It is now a paid feature: Named User and Team federate up to five sources, Enterprise has no limit.
• ENH SQL History has become a searchable table. The day-by-day tree is replaced by sortable columns — pin, time, connection, duration, rows, status and your own comment — with a quick filter over SQL and comments, filters by connection, time range and status, and export as .sql or .csv. Failed and cancelled statements are recorded too, not just successful ones.
• ENH The SQL Scanner checks more and covers additional cases. Its foreign-key check now reports findings on IRIS and Caché: it lists 40 unindexed foreign keys in the AdventureWorks sample, where earlier releases reported none. Two new tabs cover stale optimiser statistics and everything that was scanned, IRIS index types are assessed against column cardinality, and every finding now carries a reason and a suggested statement you can copy or open in an editor.
• NEW One click from a table to its class and to its globals. The class name in the table view is a hyperlink that opens the class; the global names in the Storage tab jump straight into the Global Browser. The same two steps sit in the table’s context menu as Open class and Open global(s). On IRIS and Caché the route from SQL metadata down to what actually stores the rows is now a single click.
• ENH Execution plans have become readable, and more sources deliver them. The plan tab was rebuilt as plain, selectable, copyable text instead of a tree view that could silently show an empty pane for a perfectly valid plan. DuckDB, SQL Server and PostgreSQL now return a text plan as well, and the Query Cloud explains its own work through Show Federation Plan — which part of your query ran where.
• FIX 38 further fixes, among them several that matter beyond convenience: a valid licence could be rejected because of how its expiry date was written and silently drop you into the free edition; Send connection details by email included the password in reversible obfuscation; and the SQL Gateway wrote its password into a concatenated statement in clear text. Class operations on IRIS — Delete, Copy, Export, Import, Compile — were empty stubs and are now disabled with the reason in the menu text; they remain available on Caché.

All 59 changes, with the detail behind each of these, are in the complete 4.00 changelog.

• ENH New InterSystems IRIS driver 3.10.5 added (from IRIS 2026.1)
• ENH DuckDB driver upgraded to 1.5.5.1
• ENH H2 driver upgraded to 2.4.240
• ENH Trino driver upgraded to 483
• ENH MariaDB driver upgraded to 3.5.10
• FIX Global Viewer: an invalid global value format is now shown to the user (for example $LB selected when the value is not in that format)
• FIX Global Viewer: mixed data types in global keys on the same subscript level are now handled correctly

• ENH The licensing system has been completely revised to make it easier to use SQL DATA LENS. The former “Home Edition” has been replaced by a new Free Edition, and all previous restrictions — such as localhost-only access or limits on the number of connections — have been removed completely.

  The Free Edition supports any connection to a free, community or developer edition, for example InterSystems IRIS Community Edition or Microsoft SQL Server Developer Edition. It also provides free, permanent access to the free database systems DuckDB, PostgreSQL, Trino, H2, Apache Derby and SQLite.

• ENH Table Viewer: more per-table detail for InterSystems IRIS available in the grid, for example LAST_COMPILED and OWNER

• ENH Table Viewer: the table view is refreshed after tuning tables for an entire namespace

• ENH Table Viewer: the repeated calculation of the table size added up with each run, so the value was only correct on the first run

• ENH SQLite driver upgraded to sqlite-jdbc-3.49.1.0.jar

• ENH MariaDB driver upgraded to mariadb-java-client-3.5.3.jar

• ENH MySQL driver removed

• ENH DuckDB upgraded to 1.2.2.0

• FIX “Nullpointer: Name cannot be null” occurred when opening the SQL editor on some connections

• NEW New and improved SQL scripting features.
• NEW Legacy systems that bypass the SQL or object layer safeguards can introduce hidden issues:
  • Access failures — values that cannot be read at all
  • Silent corruption — values that appear valid but do not match the metadata
  • Undetected mutation — values that are silently changed to fit the expected type
• NEW These problems are hard to spot but can cause serious trouble in downstream processes that depend on reliable metadata. SQL DATA LENS can now generate comprehensive integrity checks for tables, views and stored procedures with a single click, saving time and helping you stay ahead of hidden data quality issues.

• ENH Data Pumper: new feature to copy data from one table to another, including between different databases and namespaces
• ENH SQL editor: improved error handling for values that do not match their metadata
• ENH General: a new toggle button on the main toolbar configures read-error handling globally
• ENH Table Viewer: table sources (DDL) improved; IRIS default entries for AUTO_INCREMENT columns are now handled correctly
• ENH Test connections now show a maximum of five namespaces, to keep the dialogue from growing too large
• ENH Some small improvements, such as text on the Execute toolbar button
• ENH Many internal libraries upgraded, including POI 5.3.1

• ENH New driver 3.10.2 from InterSystems IRIS 2024.x added
• ENH New driver 3.9.0 from InterSystems IRIS 2024.2 added
• ENH Runtime environment upgraded from 11.0.14 to 21.0.3, bringing faster startup and reduced memory usage
• ENH Many internal libraries upgraded
• ENH SQL formatter upgraded
• ENH Many database drivers upgraded
• ENH Dragging and dropping CSV, Parquet or JSON files onto DuckDB now also generates DESCRIBE and SUMMARIZE statements for faster file analysis
• ENH Stored procedures: generation of CALL scripts improved
• ENH SQL editor: the way a cell is analysed can now be influenced. By default, reading the result set stops as soon as the first faulty cell is encountered. The improved value parsing makes it easier to find values that do not match the metadata: for the erroneous cell you get row and column information, and SQL DATA LENS also tries to retrieve the erroneous value as a string.
• ENH SQL editor: the configuration for how results are displayed (text or grid) is now available directly from the toolbar (Results as text)
• ENH Improved layout of the text result output
• ENH Database diagrams: views can now be processed, and system objects are shown when the connection is configured for them
• FIX Server Navigator: sorting fixed
• FIX SQL editor: the execution plan can be displayed again
• FIX Table Viewer: null pointer when viewing linked foreign tables
• FIX Restarting SQL DATA LENS did not restore the SQL editor from the previous session
• FIX Some old XML libraries removed. This is a breaking change for database diagrams.

• ENH Setup improved
• ENH The licensing system has been updated to fix issues with error code 28 caused by a disabled network adapter (part 2). Activation has to read all of a computer’s components to build an accurate fingerprint of the machine, and that includes every real (non-virtualised) network adapter attached to it.
• ENH JNA interface library updated to 5.14

• ENH DuckDB driver upgraded to 1.0
• ENH New shortcut to create an in-memory DuckDB connection
• ENH Drag and drop a CSV, Parquet or JSON file onto the DuckDB connection and the SQL statements needed to read the file are generated for you
• ENH SQL editor: more InterSystems IRIS keywords integrated
• ENH Table Viewer: shows storage details for IRIS, such as table (global) sizes
• ENH Server Navigator: database metadata viewer improved with more detail and better sorting
• ENH The licensing system has been updated to fix issues with error code 28 caused by a disabled network adapter. Activation has to read all of a computer’s components to build an accurate fingerprint of the machine, and that includes every real (non-virtualised) network adapter attached to it.
• FIX The connection dialogue box is now centred on the main frame
• FIX DuckDB connections are created with the correct DuckDB icon. Existing connections have to be recreated to pick up the fix.

• ENH New driver 3.8.4 from InterSystems IRIS 2024.1 added
• ENH Table Viewer: some drivers, DuckDB among them, ignore the setMaxRows parameter, so for those databases the row limit is applied with TOP x or LIMIT x
• ENH Table Viewer: column widths in the grid optimised
• ENH Table Viewer: the row count function now recognises keywords in object names that need quoting, so counting on system tables produces fewer errors
• ENH Flat look and feel updated to 3.4.1 (FlatLaf) — more Windows 11 features
• ENH DuckDB driver upgraded to 0.10.3
• ENH Many internal libraries upgraded
• FIX Notepad content was multiplied after closing and reopening the notepad tab
• FIX SQL history: threading issue fixed

• NEW Support and driver for DuckDB added
• ENH Removed Caché database drivers older than 2018.1. This is now the only bundled driver for Caché.
• ENH Removed the IRIS database drivers for IRIS 2019.1, 2020.1, 2021.1 and 2022.1. The new default driver for InterSystems is IRIS 2023.1.
• ENH Table Viewer: “open in new tab” improved
• ENH Cached queries: deleting the selected cached query and deleting all cached queries for the selected table now work for IRIS
• ENH SQL editor: server-side table copy now works for IRIS, using the CREATE TABLE <table> AS SELECT … syntax
• ENH SQL editor: the plain execution plan can now be shown for IRIS
• ENH SQL editor: new connect button on the toolbar to switch quickly to another server or database
• ENH Management / Databases: more detail is now displayed for IRIS and Caché database files
• ENH Management / Log files: the log file viewer now uses a monospaced font
• ENH Management / Log files: journal.log entries are now displayed for IRIS
• ENH Management / SQL Gateway: SQL Gateway entries can now be deleted
• ENH Management / SQL Gateway: create a server-side IRIS SQL Gateway connection from a local connection configured in SQL DATA LENS
• FIX The Cached Queries node shows the correct item count
• FIX The Globals node shows the correct item count
• FIX SQL editor: better query plan support for IRIS
• FIX Profiling: PStats support added for IRIS

• ENH The licensing system has been changed completely, with a simpler trial mode.

  Unfortunately the licensing system had to be replaced at short notice. From version 3.15 onwards a new licence key is required. It is supplied free of charge: send your current licence details to the sales address listed on the contact page and you will receive the new key shortly. We apologise for the inconvenience.

  Please request the new key before updating to version 3.15 or later — an old key does not work with 3.15 and higher.

• ENH New driver 3.7.1 from InterSystems IRIS 2023.1 added

• ENH Flat look and feel updated to 3.1.1 (FlatLaf) — Windows 11 rounded popup borders

• ENH Object names are only quoted where quoting is required

• FIX Constraints are shown again in database diagrams

• ENH Table Viewer: Rebuild Index now works for IRIS, executed with %NOLOCK %NOJOURN
• ENH Table Viewer: Tune Table now works for IRIS
• ENH Table Viewer: new Tune Table action with %RECOMPILE_CQ, which recompiles the cached query classes using the new Tune Table statistics
• ENH New driver 3.6.1 from InterSystems IRIS 2022.2 added
• ENH SQL editor: more new IRIS keywords are highlighted, for example the window functions
• ENH SQL editor: new code completion for SET OPTION
• ENH SQL editor: new generic code completion provider for all databases other than IRIS and Caché, for example Microsoft SQL Server
• ENH The Windows setup now runs with the lowest privileges and can be executed in non-administrative mode
• ENH Setup: the uninstaller is now signed, so the “unknown publisher” message no longer appears when uninstalling SQL DATA LENS
• ENH Flat look and feel updated to 3.0 (FlatLaf)
• ENH Many internal libraries upgraded
• FIX SQL editor: connection handling improved — each SQL editor now uses a single private connection. Querying the namespace objects previously created a second public connection, which made the editor open more slowly. A public connection is now created only for navigation, and the Server Navigator uses its own connection, independent of any open editor.
• FIX Script Manager: scrollbars in the Script Manager window fixed
• FIX Server Navigator: connection handling is now faster

• ENH SQL editor: min, max, average and sum values are calculated for the current selection in the table grid
• ENH SQL editor: sorting performance in the grid improved
• ENH New “Copy pretty formatted” option available from table results
• ENH More visible connection details for IRIS, for example whether shared memory is used and whether the server is local
• ENH Table Viewer: performance improvements for SQL Server connections
• FIX Opening the top 1000 rows of a table produced an invalid SQL statement in some situations

• ENH POI dependency log4j-1.2.17.jar removed
• FIX Stored procedures: generation of CALL scripts now recognises parameters and result set metadata correctly

• NEW Added support for Trino
• NEW Added support for MariaDB
• ENH New driver 3.3.1 from InterSystems IRIS 2022.1 added
• ENH The connection name in the status bar now includes the icon for the connection type
• FIX Null pointer when connecting to PostgreSQL fixed

• FIX Stored procedures are shown when the “Show system objects” option is not selected (that is, when system objects are ignored)

• FIX Test Connection for non-InterSystems databases (JDBC) fixed
• FIX Query Cloud: downgraded to H2 database version 1.x to fix incompatibilities with the Query Cloud handling
• ENH Some internal libraries upgraded

• NEW SQL DATA LENS now contains an updater for fully automatic updating with small update patches

• ENH EXE files are now signed
• ENH Upgraded to runtime 11.0.14.2
• ENH Many internal libraries upgraded
• ENH “Open in Microsoft Excel” works natively again
• ENH New Microsoft SQL Server driver DLL: mssql-jdbc_auth-9.4.1.x64.dll

• ENH Default font changed to JetBrains Mono for a better reading experience
• ENH New Java runtime 11.0.14 integrated, with many bug fixes and performance improvements
• ENH Many internal libraries upgraded
• ENH Driver updated to H2 Database Engine 2.1.210 (h2-2.1.210.jar)

This release contains smaller general fixes and improvements.

• NEW New built-in SQL formatter
• ENH Many database drivers updated

This release contains smaller general fixes and improvements.

• NEW Driver added for InterSystems IRIS 2021.2 preview (intersystems-jdbc-3.3.0.jar). Note that the driver reports its own version as IRIS JDBC 2019.1.0.999 even though it ships with InterSystems IRIS 2021.2 (build 617U, xDBC protocol version 65) — beware of the misleading driver version information.
• ENH IRIS improvement: iboot.log, messages.log, journal.log and alerts.log can be displayed for an IRIS server
• ENH Some smaller fixes for IRIS, such as the new LOAD DATA keywords

This release contains smaller general fixes and improvements.

• ENH Server Navigator: copy JDBC connection details
• ENH Server Navigator: send JDBC connection details
• ENH Server Navigator: the JDBC connections dialogue shows example URLs
• ENH Driver updated to Microsoft SQL Server 9.4.0 (mssql-jdbc-9.4.0.jre11)
• FIX Microsoft SQL Server: Windows authentication fixed

• NEW Rename: Caché Monitor is now SQL DATA LENS
• NEW New Flat Light and Flat Dark look and feel integrated, from FlatLaf
• NEW Shipped with a minimised private JRE (based on JetBrains JDK 11)
• ENH HiDPI support improved. The menu item has been removed: the system scale factor is configured at operating system level, in the Display settings dialogue, so per-monitor DPI is now supported.
• ENH Improvements for dark mode support
• ENH Intercell spacing removed for all table components
• ENH Improved connection testing
• ENH Improved SQL formatting
• ENH Better positioning of dialogues relative to the main window
• ENH Table Viewer: shows more detail for an IRIS database server
• ENH Server Navigator: improved connection testing
• ENH Server Navigator: stored procedures are loaded asynchronously
• ENH SP Viewer: for stored procedures, SQL DATA LENS creates CALL scripts from the metadata. It can also create a SELECT script for calling a stored procedure using %ODBCIN for each result column, using %INTERNAL for each result column, or using CAST(col AS VARCHAR(255)) for each result column. These variants help to find and identify data type problems inside a stored procedure.
• ENH SQL editor: scrollbar position is restored after a reload
• ENH SQL editor: column completion fixed
• ENH SQL editor: hyperlink navigation from the connection name in the status bar to the Server Navigator
• ENH SQL editor: the grid result is refreshed while data is being fetched
• ENH SQL editor: auto-save of the session state fixed, ordering is restored
• ENH SQL editor: improved syntax highlighting
• ENH SQL editor: improved SQL formatter
• ENH Driver updated to Microsoft SQL Server 9.2.1 (mssql-jdbc-9.2.1.jre11)
• ENH Driver updated to PostgreSQL 42.2.19 (postgresql-42.2.19.jar)
• ENH Driver updated to H2 Database Engine 1.4.200 (h2-1.4.200.jar)
• ENH CsvJdbc driver updated — added support for DBF files
• ENH Driver added for InterSystems IRIS 2021.1 (JDBC version 2021.1.0.215)
• ENH “Open in Excel” feature improved
• ENH Export improved: “Save query result to file” ignores read errors, so the process continues with the next value instead of stopping
• FIX Server Navigator: expanding a node while it is already connecting no longer starts additional connection attempts