• Connectivity:
  • Using multiple jumps tunnels when connecting via SSH was supported
  • Enable tunnel sharing option was added
  • Test connection was fixed
• SQL Editor:
  • WHERE TRUE and SELECT UNIQUE support was added
  • Error with single quoted string was fixed
  • Syntax highlighting after active schema change was fixed
• Data Editor:
  • Automatic row count option was added (thanks to @utsav1704)
• Metadata editor:
  • Deleting table comments was fixed
  • Linking with the editor was fixed
• General:
  • Ability to collect log files from the interface was added
  • Transaction rollback behavior was fixed
  • Metadata changes were removed from the commit counter
  • Autocommit in production databases was fixed
• Data transfer:
  • Ability to specify header case in the target file was added
  • Typo in the confirmation dialog was fixed
• Databases:
  • Cubrid: Query plan feature was added (thanks to @rathana-pvs)
  • Old MySQL drivers were repacked
  • PostgreSQL: Jobs, roles, and system information were hidden in the Hide Folders mode
  • SQLite: Deleting columns was fixed

• Connectivity:
  • Shared SSH sessions support was added
  • Connection via native proxy was fixed
  • Dark theme support on the Connection page was improved
• SQL Editor:
  • Highlighting, validation, and outline for INSERT, UPDATE, and DELETE were supported
  • Incorrect cursor position during autocomplete was fixed
  • QUALIFY keyword was supported (thanks to @ashu7896)
• Metadata editor: automatic reference column creation for a new foreign key was implemented
• Data Editor:
  • Opening of a table with empty data was fixed
  • SRID editing was fixed
• General:
  • SVG icons support was added
  • Error when checking checkboxes in the Formatting page in Preferences was fixed
  • Disappearance of renamed project was fixed (thanks to @saikotek)
• Databases
  • Dameng: Sequence creation was fixed
  • DuckDB:
    • Sequences, views, and table definitions were supported
    • Ability to add comments via UI was added
  • MySQL: link to the driver documentation was fixed
  • RisingWave: non-working functions and folders were removed
  • PostgreSQL: issues with scheduled jobs was resolved
  • SQLite: errors when creating table was fixed
  • SQL Server: redundant authentication types were hidden
  • Sybase: stored procedures support was improved
  • Teradata: procedures and functions DDLs reading was enhanced
• Localization:
  • Romanian language support was added (thanks to @v613)
  • French translation was updated (thanks to @Jean-BaptisteC)

Changes since 23.3.5:

• SQL Editor:
  • Syntax highlighting was improved
  • Highlighting in nested queries and on query editing was fixed
  • Scrolling with opened Outline was fixed
  • Applying settings to Outline was fixed
  • Order by i.* was supported in Outline
  • Joined tables presentation in Outline was fixed
• AI: Ability to send object descriptions to OpenAI was added
• Data Editor:
  • Scrolling multiple tab result was improved. You can scroll all result sets using Ctrl
  • Fetch next page shortcut was changed to CTRL+ALT+N
• ER Diagram: Connections rendering was improved
• Data transfer:
  • The Proceed button at the last step became more visible
  • On conflict expression was added to INSERT statements
  • Crash when importing CSV file was fixed
  • Extra space before the semicolon in export to SQL was removed
• General:
  • Close idle connection setting saving was fixed
  • Application launch was improved
  • Unexpected transaction ending was fixed
  • Settings are applied to new connections without a restart
  • User credential dialog was fixed
  • Issue with the background task of the dashboard update was fixed
  • Temporary directory creation was fixed
• Security: Added warning when trying to open an encrypted project and risk losing all connection credentials
• New driver:
  • StarRocks database support was added
• Databases:
  • MariaDB driver was updated to version 3.3.2
  • Oracle:
    • Keywords and schemes highlighting was improved
    • Default subpartition type was added
  • PostgreSQL:
    • Creating a new table from the user interface was fixed
    • Duplication of procedures was fixed
  • Snowflake: VIEW keyword highlighting and validation was improved
  • SQL Server: syntax highlighting was fixed
  • Sybase:
    • Stored procedure creation was added
    • Using create view instead of Alter view was fixed
    • Import with table mapping was fixed
• Localization:
  • French translation was updated (thanks to @Jean-BaptisteC)
  • Babel version was updated

• Metadata Editor:
  • Constraint creation was fixed
  • Editor performance on Linux was enhanced
• SQL Editor:
  • Autocomplete for aggregate functions was added
  • Arrays highlighting was added
  • SELECT query validation was fixed
  • Color and font settings with enabled semantic analysis was fixed
  • Small font in the editor and result set was fixed
  • Creating multiple parsing jobs was fixed
• Outline viewer:
  • Composite types and arrays support and validation was added
  • Data type decorations were added
  • Error when saving SQL console as a script was fixed
• AI: Issue with using chat format in completion dialog was fixed
• Data Editor:
  • Ignoring quotes option was added to Advanced paste
  • Issue with multiple checks in filters was fixed
• ER Diagram: Self-connection rendering was enhanced
• Data Transfer:
  • Delimiter selection when exporting in TXT format was added
  • Target table change on the mapping page was fixed
• General: Idle connections behavior has changed, now they are automatically closed by default after some time
• New drivers:
  • RisingWave driver support was added
  • Cubrid driver support was significantly enhanced (thanks to @longhaseng52)
• Databases:
  • Altibase:
    • Adding and renaming constraint in metadata editor was fixed
    • Reading data in columns with quote names was fixed
  • Clickhouse: Legacy driver was fixed
  • MySQL and MariaDB: ‘Grant option’ is checked only if grant permission exists
  • Snowflake:
    • Snowflake driver was updated to version 3.14.4
    • Double-dash single-line comments highlighting was fixed
    • Functions words were added to SQL Editor
  • SQLite driver was updated to version 3.44.1.0
  • TDengine: Unqoted table names presentation was fixed
  • PostgreSQL: Option ‘Show all databases’ was moved to the main page in the Connection settings
  • Redshift: Added extended support for stored procedures for early Redshift versions
• Misc:
  • Links to download PRO version were added
  • Ability to use waffle-jna in MariaDB, PostgeSQL, and Oracle was added
  • Flipped splash screen on macOS Sonoma was fixed

• Metadata editor:
  • Object creation dialog was redesigned
• SQL Editor:
  • Autocomplete for INSERT statements was fixed
  • Case sensitivity on highlighting and validation was fixed
  • Duplicated table aliases in autocomplete were fixed
  • Column aliases highlighting was fixed
  • Dot character is not allowed again in variable name
• Data Editor: Column descriptions are displayed again
• Database Tasks: Display of task execution time was fixed
• ER Diagram: One-to-one connection rendering for unique/primary key was fixed
• Data Transfer:
  • All columns can be marked as skipped when exporting data
  • Statistics was excluded from exported data
• General:
  • Changing the monospace font was fixed
  • Unique key creation was fixed
  • Finding local clients on Linux and macOS was improved
• Databases:
  • Altibase support was added (thanks to @zennken)
  • BigQuery: Structs and arrays are supported
  • Dameng:
    • Dameng driver was updated
    • Users, roles, and categories are supported (thanks to @Stkai)
  • MySQL: Path to the local client was fixed
  • MySQL and MariaDB: Rendering columns with unique identifiers was fixed
  • PostgreSQL:
    • Schema permissions display was fixed
    • Confirmation message for clean option of restore wizard was fixed
  • SQLite: Import with ‘truncate target tables before load’ option was fixed
  • SQL Server:
    • Check constraint option was removed from primary/unique key creation page
    • Displaying source in the index properties was fixed (thanks to @HansenChristoffer)
    • SQL Server driver was updated
• Localization:
  • Japanese localization was updated (thanks to @doew)
• Misc:
  • Microsoft Store version was fixed
  • Starting application when the workspace directory is a link was fixed

• Metadata editor:
  • New database objects wizard was redesigned
  • Primary/unique key can be created automatically along with new columns
• SQL Editor:
  • Outline viewer of SQL queries structure was added
  • Execution time format was improved
  • Toolbar customization page opening was fixed
  • Identifiers coloring was improved
  • Autocomplete was fixed for multiline comments
• Accessibility: notifications can be read with a screen reader (JAWs, NVDA or Narrator)
• ER Diagram: connection errors handling was added
• Data Transfer: Incorrect links in settings were fixed
• AI: legacy OpenAI models were removed
• General:
  • Incorrect links to help articles were fixed
  • Redundant items were deleted from the Context menu
  • Global network settings preferences page is available again
• Databases:
  • ClickHouse: leagacy driver configuration was fixed
  • Dameng: tablespaces are supported (thanks to @Stkai)
  • Google Cloud SQL: redundant options were removed from the context menu
  • MySQL: TLS 1.3 support was added
  • MySQL and PostgreSQL: local native database clients can be found on macOS and Linux
  • Teradata: metadata search was significantly enhanced
• Localization:
  • Ukrainian localization was added (thanks to @CrazyTapok-bit)
  • Italian translation was improved (thanks to @coluzziandrea)
  • Portuguese localization was fixed

• SQL Editor:
  • New highlighting and script validation were enabled by default
  • SQL highlighting performance was improved
  • Connection variables and system environment variables now accessible from SQ Leditor
  • Handling of special characters was fixed
• Data Editor:
  • Value selector panel was improved: you can switch the active panel with ‘Ctrl+Tab’ and change the active value in the context menu
  • Advanced paste of multiple records was enhanced
  • Spatial data zooming was improved (thanks to @kalkun)
• ER Diagrams:
  • Diagram layout was enhanced
• Data Transfer:
  • Users can change the data export task output format
  • Data export from table to table was fixed
• Security:
  • Oracle driver version was updated to 23.2.0.0
• General:
  • We switched to Eclipse 2023-12
  • Language detection for locale containing language and country was fixed
  • Workspace opening was fixed
  • ‘Statistic’ tab display was fixed
  • Broken links in connection dialogs were fixed
  • New foreign key name generation was fixed
• Databases:
  • DB2: Loading schema statistics was fixed
  • EDB: Packages duplicating schemas in the Database Navigator were removed
  • Firebird: Function and procedure presentation was enhanced
  • Google Bigtable name was corrected
  • Greenplum: Rows policies were supported
  • MariaDB: Result fetch size was fixed
  • PostgreSQL:
    • Indexes and constraints are displayed in partition DDL
    • Backup of several schemas and several tables was enhanced

Changes since 23.2.5:

• Security: database drivers were updated due to security reasons: DB2, Google BigQuery, Athena, and YugabyteDB
• SQL Editor:
  • Autocompletion of column names with special characters was fixed
  • Output panel display in the statistics tab was fixed
  • Selected query execution was fixed
  • Queries with CTE execution was fixed
• Data Editor:
  • Filter value search was fixed
  • Advanced Copy as HTML with spaces in the column names was fixed
  • Numeric value “infinity” representation was fixed
• ER Diagrams:
  • Diagram update on metadata changes was fixed
  • Automatic re-layout on notation or routing change was fixed
• General:
  • Tips of the day were updated
  • Constraints rename was fixed
  • Idle transaction rollback notification was fixed
• Data Transfer:
  • “Native clients” were renamed into “Local clients”
  • Update on conflict behavior was improved (now it respects indexes too)
  • Database restore was fixed
  • List of supported variables was updated
  • Database tasks: missing line break was added to the task log file
• Connections:
  • Driver download error handle was fixed was fixed
  • ‘Check for new driver version’ setting save was fixed
• Databases:
  • Firebird: default values for procedure parameters are now displayed
  • PostgreSQL/Greenplum: foreign key creation was fixed
  • MySQL5 driver is available again
  • Oracle: comments were added to the newly created columns
• A number of minor UI bugs were fixed

• SQL editor:
  • Syntax coloring and code completion: smart columns abd aliases recognition was added (experimental)
  • Numerous improvements in single-tab results visualization
  • Quoting of identifiers with special characters was fixed
  • Issue with read-only column in queries with comments was resolved
  • COMMIT/ROLLBACK statements are now recognized as transaction state change statements
• Data transfer:
  • Issue with unquoted column names was resolved (data import)
  • File import toolbar was redesigned
  • Library for XLSX export/import was updated, many minor issues were resolved
• Accessibility:
  • Screen-readers support was improved (JAWS)
  • Editor tab names reading was fixed
• ER diagrams: issues with notation switch were resolved
• General:
  • Issue with output file name after multiple executions of data export task was resolved
  • Error “Data transfer IO error” was resolved
  • Comments in generated DDL now can be disabled (configurable)
  • Countdown visualization before auto-close was added for idle transactions
  • Extra tips added in connection keep-alive configuration
  • Database navigator: click in empty space handle was fixed (thanks to @itsyfx)
• Databases:
  • MySQL:
    • Driver version was upgraded to 8.2
    • Legacy MySQL 5.x driver was deprecated and replaced with MySQL 8 driver
  • Oracle:
    • Materialized views indexes management was supported
    • Materialized views permissions and dependencies view was added
    • Column alter DDL was fixed (NULL clause)
  • PostgreSQL:
    • Issue with VARCHAR limit change was fixed
    • Function comment delete support was added
  • SQL Server: extra dialect keyword were added (thanks to @brunodmartins)