• ChatGPT smart completion:
  • Completion popup UI was improved
  • Metadata scope configuration was added
  • Redundant config options wer removed
• Data editor:
  • Accessibility support was significantly improved (context menu, additional keyboard shortcuts)
  • Filtering and ordering icons visibility configuration was added again
  • Dictionary viewer was fixed (issue with missing dictionary values)
  • “Save filters” button was removed from custom SQL queries results
  • App crash on geometry viewer opening was resolved in the latest version of MacOS
• SQL editor: query text extraction was fixed (issue with trailing comment after query text)
• Database backup/restore: issue with external tools running was resolved (Linux)
• Application fonts were unified. Now we have only Main and Monospace fonts configuration
• Data transfer: data type mapping now respects type name case (for databases with different default case)
• Variables support in database tasks was fixed
• Database tools wizard: redundant task configuration page was removed
• SQL generator dialog now show progress to avoid UI freeze on big schemas
• Issue with opening ERD files from disk ws resolved
• Clickhouse: DDL for array columns was fixed
• Databricks: additional metadata was added
• Exasol: default connection parameters were updated (thanks to @allipatev)
• IRIS (ex Cache): driver version was updated
• Oracle: stored procedures invocation syntax was improved
• Snowflake: driver now uses single database connection for all editors (configurable)
• SQL Server:
  • Driver version was updated to 11.2.3. Trust server certificate option was moved to the main connection page
  • Server messages (printed on raiserror) reading was fixed
  • Multiple resultsets reading was fixed (extra error handling was added)
  • VARCHAR(MAX) data type support was added
• SQLite: converting binary columns into string representation was fixed

• ChatGPT integration for smart completion and code generation (as optional extension)
• Accessibility:
  • Text reader for entity editor was improved
  • Text reader for data grid was improved
• SQL editor:
  • Query generation from human language text was added
  • Server output log levels configuration was improved
  • Global metadata search was fixed
  • Variables resolution is fixed in strings and comments
  • Issue with queries with invalid line feeds was resolved
• Data editor:
  • Grouping panel messages were improved
  • Datetime calendar editor was fixed (in panel and inline editor)
• Database navigator: issue with rename/refresh was resolved
• Dashboards were fixed for inherited databases
• Project import now sets DBeaver nature (thanks to @froque
• ERD: custom diagram editor was fixed (issue wth missing notes and connections was resolved)
• Databricks: table DDL reading was fixed, extra SQL keywords were added (thanks to @mixam24)
• DB2 BigSQL: table with RID_BIT columns data reading was fixed (thanks to @bkyle)
• MySQL: numeric identifiers quoting was fixed
• Netezza: tables/views search query was improved
• PostgreSQL:
  • Procedures invocation was improved (thanks to @plotn)
  • Filter by enum was fixed (thanks to @plotn)
• Redshift: triggers DDL reading was fixed
• Snowflake: table constraints reading was fixed
• We switched to Java 17 so now DBeaver supports all newest JDBC drivers

• SQL editor:
  • Output logs viewer now respects log levels and supports log search
  • Auto-completion for mixed case schema name was fixed
  • Result tabs count message was fixed
  • Auto-completion of cell values is now configurable
  • Query execute time is now populated in statistics (thanks to @bob27aggiustatutto)
  • Mixed-case variables resolution was fixed
  • Execute statistics UI was fixed (redundant info was removed)
  • NPEs during auto-completion were fixed
• Data editor:
  • Column name ordering in record mode was fixed
  • Chart type configuration added to the context menu
  • Issue with column focus in context menus was fixed
• General UI:
  • Database navigator now respects font size customization
  • Dashboard graphs now support dark themes
• DB2: client application name population was fixed
• Exasol: privileges reading was fixed for SaaS (thanks to @allipatev)
• MySQ:/MariaDB: schema privileges save was fixed (issue with UI refresh)
• Oracle: complex data types resolution was fixed for resultsets
• PostgreSQL:
  • Full backup with roles and groups is now supported
  • View triggers DDL was added
  • Procedure debugger was fixed
  • Issue with URL-baes connections backup was resolved
  • Vector data types support was fixed
  • Aggregate functions DDL was fixed
• Redshift: incorrect schemas info read in different databases was fixed
• Snowflake:
  • Java 17 support has been added
  • Complex DDL statements parser was improved
• SQL Server: procedures and functions rename was fixed
• Vertica: comments read can e disabled for all metadata (for performance)

• SQL editor:
  • Execution plain visualization was improved
  • Variables binding was fixed for query execution plan explain
  • SQL templates completion was fixed
  • Auto-completion of complex names was fixed (issue with missing schema name)
  • Hippie auto-completion was disabled for complex identifiers
• Data editor:
  • Drop-down menu icon rendering was fixed
  • Filter panel ordering was fixed
  • Filter values save/restore was fixed
  • Column context menu was enhanced
  • Context menu now respects column in focus
  • Pinned columns scrolling was fixed
• General UI: host info was fixed for URL-based connections
• SSH: issue with host validation popup was fixed
• Exasol:
  • Driver version was updated to 7.1.16
  • Connection encryption support was improved
• MariaDB: json data type support was fixed
• MS Access: identifiers quoting was fixed
• Snowflake: SQL procedures parser was improved (IF statements support)
• SAP HANA:
  • Schema create/delete/rename functions were added
  • Tables statistics read was added
  • Additional keywords highlighting was added
  • Case-sensitive schema names support was fixed
• SQLite:
  • Utility tables (sqlite_autoindex_%) support was fixed
  • View DDL generator was fixed
• Vertica: expired password change was implemented

• Data editor:
  • Columns filtering/ordering menu was redesigned
  • Virtual key definition behavior was redesigned
• SQL editor:
  • Script statistics visualization was fixed
  • NullPointer error during new script opening was fixed
• Data transfer: variables resolve in saved tasks was fixed
• Folders drag-n-drop was improved. Drop into root is now possible
• Drag-n-drop from navigator window was fixed for GTK
• Native SQL script execute wizard UI was improved
• Debug log file rotation was added, solves problem with huge log files
• Errors during driver files download are now handled properly
• SSL certificates configuration on Windows was fixed
• Proxy settings are saved between app installations (Windows installer)
• Confirmation dialogs were redesigned
• “Reset UI settings” and “Reset workspace” behavior was redesigned.
• Tasks view now shows tooltips
• Data export in SQL INSERT format now supports custom target table name configuration
• Issue with columns visibility in metadata editor was resolved
• Chinese localization was extended (thanks to @bianyun1981)
• Eclipse plugin now supports the latest Eclipse IDE version
• DBeaver base platform was changed to Eclipse 2022-12
• AWS Athena driver version was upgraded
• PostgreSQL:
  • SSL keys automatic conversion was added
  • Template databases duplication was fixed
  • Object dependencies read query was fixed
• Azure SQL Server driver configuration was fixed (multi-factor authentication support)
• MySQL NDB driver configuration was fixed
• MySQL: user name quoting was fixed
• Multiple minor UI bugs were fixed

Changes since 22.2.5:

• Data editor:
  • Data export button UI was enhanced
  • Fetch all data and fetch size controls were returned to status bar
  • Lasso tool was added to spatial viewer
  • Bug in spatial viewer initialization was fixed
  • BLOB contents opening in external editor was fixed for MacOS and Linux
  • Browser-based image viewer control was fixed (null or invalid images handle)
• SQL editor:
  • Big SQL files support was improved (automatic disablement of syntax validation)
  • Table auto-completion tooltips UI was redesigned
  • Error on unassociated script opening was fixed
• General:
  • Default SSL truststore selection was fixed (it is now configurable)
  • Connection edit/create dialog performance was improved
  • Database server version is now shown in connections’ tooltip
  • Object delete dialog was redesigned
  • Database create button was removed from the connection dialog for databases which don’t support it
  • Security patch for packaged drivers (additional validation of zip archives was added)
• SSH: tunnel invalidation was fixed for SSHJ
• Tasks: problem with tasks operating with missing (deleted) tables was fixed
• Clickhouse: identifiers quoting was fixed (for non ASCII characters)
• Intersystems Cache: community driver was added again
• MySQL:
  • Hyperlinks navigation was fixed for procedures
  • Complex identifiers quoting was fixed
• Netezza: columns metadataread ws improved
• PostgreSQL:
  • Role create/edit command was fixed
  • PostgreSQL 15 support was improved (new data type category)

• Data editor:
  • Top and bottom action toolbars were redesigned
  • Action buttons now show hints
  • Data export toolbar button is now configurable
  • Image viewer was switched to embedded web-browser mode (configurable)
  • The issue with spatial data viewer was fixed (“no more handles” error)
  • Errors in virtual column definition now handled properly
  • “Count nulls” function was added to the Calc panel
• SQL editor:
  • Auto-completion with TAB key was implemented (!)
  • Hyperlink navigation was fixed for quoted identifiers and identifiers with spaces
  • The issue with keyword case auto-conversion was solved
  • Editor tabs now shows connection state icon (connected/failed)
  • Client-side commands prefix configuration was fixed
  • The issue with cursor position change on mouse right-click was resolved
• Data transfer: tables/column mapping dialog was improved, problems with target column name were fixed
• Database drivers:
  • License information was added to the most drivers
  • It is no longer need to restart DBeaver after driver settings change (bug in recent versions)
• Connections:
  • SSH jump servers support was added for SSHJ implementation
  • Network profile edit UI was fixed
  • Connection error messages
• General UI:
  • Dark theme support was added to XML editor
  • Dialog font settings is now applied to most popup dialogs
  • Database navigator quick filter now supports composite identifiers (thanks to @plotn)
• Clickhouse: driver version was updated, this resolves many issues with different data types support
• Oracle: DATE data type rendering is now configurable
• PostgreSQL: auth role editor was moved to the database level
• SQL server: it is now possible to disable TOP clause in select queries

• SQL editor:
  • SQL script active database/schema restore was fixed
  • Parameters prefix configuration was fixed
  • Issue with cursor change on context menu invocation was fixed
  • Option to disable all code completions/foldings was added
  • Auto completion inside SQL package was fixed
  • Table aliases auto-completion was fixed
  • SQL blocks auto-completion was fixed
  • SQL variables/parameters disable configuration was fixed
• Data editor:
  • Table columns resolution was improved for custom SQL queries
  • Hidden columns restore was fixed
• Data transfer:
  • Columns mapping dialog was redesigned and improved
  • Columns scale/precision mapping was fixed
  • Import from XML format was fixed
• Multiple MFA attempts were resolved (in drivers with MFA authentication)
• Tasks: variable value prompt was added (configurable)
• SSH tunnels: issue with private key password prompt was fixed
• RPM package: issue with remaining symlinks after uninstall was fixed
• UI perspective customization was fixed
• Clickhouse: driver version was updated (solves many data type conversion problems)
• PostgreSQL: inherited roles support was added
• Snowflake:
  • Java 17 support was added
  • Stored procedure and functions management was added
• SQLite: table column delete was fixed

• Data editor:
  • Value display format option was added to grid data view
  • Dictionary view panel now saves its ordering state
  • Row number in the record mode was fixed
  • Ability to open external editors for BLOB values was added
• Database backup: variable ${schema} was added
• SSH:
  • Problem with redundant password prompt was fixed
  • Tunnel config tab is now hidden for databases which don’t support SSH
• Drivers:
  • Driver version auto-update feature added
  • Issue with driver download dialog was fixed (non-clickable dialog)
  • Driver license info button was added to the connection edit page
• Data transfer:
  • Export to XLSX now support different modes for spreadsheet rows append
  • Description column was added to XLSX format (configurable)
  • An additional confirmation is shown if output file will be overwritten
  • Fallback directory was added for data export tasks
• Tasks:
  • Tasks viewer now shows tasks only for the active project
  • New task create command enablement was fixed
  • Running tasks are now checked and confirmation is shown on DBeaver app shutdown
  • Additional logging was added for tasks execution
• Clickhouse: SSL support was fixed
• Greenplum: table list read was fixed for recent GP server versions 6+.
• MariaDB: UUID data type support was fixed
• MySQL/MariaDB: problem with grave accent quoting was fixed
• Oracle: DATE data type rendering was fixed (time part was removed)
• PostgreSQL:
  • Problem with result sets fetch was fixed (OutOfMemory on big results)
  • Driver version was updated to 42.5.0 (security update)
  • Issue with numeric fields formatting in struct types was fixed
• OpenSearch driver configuration was added
• General:
  • Multi-connections behavior configuration was improved. Possibility to forcibly disable or enable additional metadata or SQL editor connections was added.
  • Additional localization was done in many places of application
  • We switched to a new Eclipse platform version (2022-09)