• 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)

• SQL editor:
  • Code completion for update statements was added
  • Smart completion and replacements of quoted expressions was fixed
  • Redundant errors on opening SQL Editor for the first time were removed from the logs
• Database Navigator:
  • Filtered objects visualization was added
  • Script folder opening was fixed
• Data transfer:
  • Attributes names for quoted attributes are handled correctly
  • “Copy as HTML” result presentation is improved
• Data editor:
  • Background color reset was fixed
  • Message about content representation size limit was fixed
  • App freeze in binary editor was fixed (MacOS)
• ER diagrams: one-to-one connection rendering was fixed
• Connections:
  • SSH connection page validation is enhanced for jump servers
  • Complex JDBC driver support was improved (context classloader + driver cache)
• General:
  • Script names are sorted alphabetically
  • Refresh button was added to the “Generate DDL” dialog
  • Issue with app launch was fixed (rare case)
• Databases:
  • Oracle: search package bodies as packages was supported
  • PostgreSQL:
    • Default privileges presentation and editing was supported
    • Sequences permissions reading for quoted roles was fixed
  • SQLite: required columns creating was fixed

• Data editor:
  • Excel (XLSX) export now supports columns auto-fit
  • Copy from row bellow/above command was fixed
  • Shortcut for “Got to column” column was changed to Ctrl+Shift+G
• SQL editor:
  • Script statistics configuration was extended
  • AI completion bugs were fixed and configuration UI was redesigned
  • Tabs close in horizontal mode was fixed
  • Script to connection association save was fixed
• Data export:
  • Data import tasks wer fixed for schema-less databases
  • Columns value transform expressions evaluation was fixed
  • All data transfer were migrated to a new IO API
  • Export functionality now can be disabled completely
  • Tasks loading for missing database objects was fixed
• ER diagrams: one-to-one connections rendering was fixed
• General:
  • Default file encoding was changed to UTF-8. IT affects all external tools integration.
  • Web based authentication is now opened in external browser by default
  • Version update functionality now can be disabled completely
• Databases:
  • Clickhouse: map data type visualization was fixed
  • Databricks: issue with national encodings was resolved
  • Greenplum:
    • Issue with case-sensitive table names was resolved
    • FFL for function parameters was fixed
  • MySQL: session manager now shows info from performance_schema
  • OpenEdge: root catalog is now hidden; data export was fixed
  • PostgreSQL: foreign key DDL was fixed (MATCH FULL)
• Misc: we switched to Eclipse 2023-09

• SQL editor:
  • Aut-completion for complex SQL queries was improved
  • Reconnecting of open editors when switching between Simple and Advanced view was fixed
  • SQL console now can be saved as script
• ER diagrams:
  • Diagrams notations switcher was added
  • Connections rendering was improved
  • Crow’s foot notation was added
• Data editor:
  • Multiple query results now can be displayed vertically
  • `Go to column` (Ctrl+J) action was added
  • Column search was added to Metadata panel
  • Numeric formatting was fixed for floating point numbers
  • Issue with empty table after opening the Calc panel was resolved
  • Setting row color for the result set was fixed
• Data transfer: columns automating mapping is now configurable
• General:
  • `Restore defaults` on preference pages now resets to actual default preferences
  • Eclipse 2023-09 plugin API is now supported
  • Reset UI settings was fixed on macOS
  • App crash when running on Wayland was fixed
  • java.compiler and java.scripting modules were included in bundled Java
• Databases:
  • Dameng database extension was added (thanks to @Stkai)
  • Clickhouse: array map representation was fixed
  • Google Spanner: table DDL generation was fixed
  • DB2 LUW: trigger editor was fixed
  • Exasol: customer group creation was fixed
  • Fireberd: several keywords were added
  • Materialized: system schemas loading was fixed
  • PostgreSQL:
    • Backup/restore native tools execution was fixed
    • `Europe/Kyiv` timezone support was fixed
  • Redshift:
    • Schemas loading was fixed
    • Spectrum tables loading was fixed (for custom driver configurations)

• SQL Editor:
  • Aliases proposals for tables with joins were improved
  • SQL console can now be saved as a script
  • Enhanced smart completion is enabled (configurable)
  • Issue with big string contents (json, xml) edit was resolved
  • JSON formatting in the separate editor was fixed
  • Ctrl+Alt+6 shortcut was changed to Ctrl+Alt+T
  • JSON functions keywords were added to the SQL Assist
  • Representation of errors on query execution was fixed
• ER Diagrams: issue with duplicate relations on the diagram was fixed
• Data Editor:
  • Big content representation end editing was limited to 1MB (configurable)
  • User can now add a shortcut for setting row color
  • Issue with hiding the wrong column from the context menu was resolved
  • Grouping panel now shows actual executed SQL
  • Decimal rounding error was fixed
• General UI:
  • When exporting a project, a warning about replacing an existing project was added (thanks to @MontejoJorge)
  • Scroll bars were added on the connection page, and other wizards
  • Issue with broken quotes in localization files was resolved
• Connectivity:
  • Driver download UI was improved: already downloaded driver files are colored in grey
  • JDBC drivers maven artifacts resolve was fixed
  • The “Propagate driver properties” option was added to the driver settings
• New drivers:
  • JDBCX driver was added (thanks to @zhicwu)
• Databases:
  • Clickhouse: IPv4 data representation was fixed
  • Greenplum: External tables representation was fixe
  • MySQL: Unsupported engine types are replaced with the default one
  • Oceanbase:
    • Views editor was supported
    • Routines and procedure parameters read was fixed
  • PostgreSQL:
    • Foreign tables folder was added
    • Enum data types reading performance was enhanced
  • Redshift: Backup/Restore tools were deprecated and removed from UI
  • Snowflake:
    • Driver was updated to 3.13.25
    • Materialized views are now supported
    • Schema create UI was enhanced was enhanced
  • Trino: Views DDL support was added