BroadSQLWhat's new with BroadSQL 5.2.0 (2026-09-12)
New features
- Excel exports now open with AutoFilter enabled, a frozen header row, and column widths sized to fit their content
- SQL value lists can now be pulled directly from the clipboard, a CSV file, or an Excel column with <@clipboard>, <@csv:...> and <@excel:...>
- new COPY RESULT command copies the current query result to the clipboard as tab-separated text, ready to paste into Excel
- PULL ... AS XLSX/ODS accepts a trailing OPEN to open the exported file with the operating system's default application right after export
- every PULL ... AS H2 export now records its source query, target, timestamp and row count in a BROADSQL_PULL_AUDIT table for provenance
- / <environment> re-runs the last query against a different environment of the same Database Group, without retyping it
- <@last:column> reuses a column from the last query's result as a value list, without exporting it first
- bare HELP now lists commands grouped into 13 logical categories instead of one flat alphabetical dump, and this grouping can no longer silently regress
- HELP categories now also accept short aliases (e.g. CONN, GROUPS, ENV, QUERY, EXPORT) alongside their full names
- the CONFIG screen's Connections, Database Groups and Environments tabs now share one consistent Active/Inactive/All lifecycle model, with bulk actions and a search box
- the CONFIG screen now uses a modern FlatLaf appearance instead of the stock Swing look
- new EXPAND command replaces SELECT * / alias.* in the current SQL with the real column names from database metadata
- new FORMAT command reformats the current SQL for readability without changing what it does
- SQL errors are now shown in a clearer, structured block, with a caret pointing at the exact error location where the driver supports it
- LOAD now safely loads a CSV file into a table with parameter-bound INSERT statements: PREVIEW validates without writing, EXECUTE authorizes the write, and every value is checked before anything is written
- BATCHLOAD is deprecated in favor of LOAD, which now provides the same batched performance internally
Problems solved
- Excel exports no longer mishandle NULL values in binary columns
- Apache Derby connections no longer fail to load their JDBC driver class
- SQL Library, Script and JS commands consistently say "Database Group" instead of a leftover "instance"
- HELP <command> no longer silently discards the result of your last query
- the Database Groups/Environments tabs' "Show:" filter row no longer gets clipped, and the CONFIG screen's visual hierarchy is now clearly distinguishable from stock Swing
- LOAD/BATCHLOAD no longer build SQL by concatenating CSV header names into the query; unrecognized or malicious-looking columns are rejected instead
- a LOAD/BATCHLOAD failure now rolls back every row of that load, instead of leaving a partially-committed table
Installing BroadSQL 5.2.0
See Installation.
Upgrading from previous releases
No special steps required for this release.
Known issues
None known at release time.