• SQL Editor:
  • Autocomplete now supports [ ] and ` as quotes for identifiers
  • Shortcut confict on macOS was fixed
  • JSQLParser was reverted to the version 4.5 and is now faster
  • Issue with substitution variables in text with \n line feeds was fixed
  • Autocomplete case with FROM right after SELECT is now handled
  • Autocomplete for SELECT query without FROM was fixed
  • ‘Go to Matching Bracket’ shortcut was changed to CTRL+SHIFT+[
  • Autocomplete for columns in tables without alias was fixed
  • Completion analyze errors are now written to the debug log
  • Comment with a tab after a double dash is now handle
  • Issue with hiding cursor position after resizing the editor was fixed
  • Exeption when updating editor annotations was fixed
• Data Editor:
  • Data ordering was improved
• General UI:
  • Changing the size and position of the connection dialog is now saved
  • Issue with the application freezing when creating a table when the connection hangs was fixed
  • Tips of the day were revised
• Connectivity:
  • Option to disable SSHJ hostname verification was added (thanks to @ryanc-me)
  • Issue when switching from Community to PRO version and vice versa was fixed
• Databases:
  • ClickHouse: display of large numbers was fixed
  • MariaDB: partition support was added
  • Oracle:
    • Issue issue with native clients hanging when running SQLPlus scripts was fixed
    • Issue with setting the wrong schema after connecting or changing the Data Editor was fixed
  • PostgreSQL:
    • Issue with an exception when loading attribute information was fixed
    • Reading a numeric array was fixed
  • Trino: error handling was improved
• Localization:
  • German localization was improved (thanks to @hype11)
  • Italian localization was improved (thanks to @Gnafu)
• Misc:
  • Images for all DBeaver Eclipse extensions were added
  • Legacy ODBC driver based on the obsolete Java 7 was deprecated due to many issues

• SQL Editor:
  • Autocomplete for WHERE and SELECT shows aliases with the aliased table
  • Hovering information for SQL errors and spelling annotations was added
  • Variable and parameter names in the binding dialog are now displayed in their original case
  • Information about assigning a non-dynamic variable was added to the binding dialog
  • Issue with incorrect icon for Execute SQL Statement after opening Output tab was fixed
  • Query Manager: ‘Restore Default’ button behavior was improved
  • Ability to directly execute SQL scripts in native clients was added
• Data transfer:
  • Ability to trim string values when exporting to XLSX was added
  • Handling of datetimeoffset was added
• General UI:
  • Part divider UI was redesigned
  • Option to increase formatting time was added in Preferences
  • Issue with closing pinned tabs using ‘Close Tabs to the Left’ was fixed
• Connectivity:
  • Issue with driver fallback not being updated was fixed
• Databases:
  • ClickHouse: driver was updated to 0.4.6 (thanks to @zhicwu)
  • Databricks: handling of data types without parameters was added
  • Hana: comments handling was fixed
  • MySQL: partitions are now supported
  • Oracle: TNS import was fixed
  • PostgreSQL:
    • Issue with duplicate tables with generated columns in Database Navigator was fixed
    • Error message about line on the map created with a single point was added
    • Schema refresh was fixed
  • SQLite: ability to open ER Diagram in the Simple View was added
• Localization:
  • German localization was improved (thanks to @hype11)
  • Italian localization was improved (thanks to @Gnafu)

• Data Editor:
  • Bottom toolbar became customizable
  • Disconnected editors can be easily reconnected
  • Issue with Ctrl+1 shortcut not working was fixed
• SQL Editor:
  • Issue with refresh button closing active resul tab was fixed
  • Issue with not correct dislaying of \r\n sequence was fixed
  • Issue when generating the same UUID for all rows was fixed (thanks to @SiyaoIsHiding)
• Data Transfer:
  • Ability to change the target column type on import to BIGINT was added
  • Export from query to CSV was fixed
• Git: Missing git buttons and menus were added on macOS (Apple Silicon)
• Databases:
  • ClickHouse: Catalog support was added
  • Informix: issue with extra spaces in table name was fixed
  • MySQL:
    • Event reading for quoted schemas was fixed
    • Time handling in MySQL was improved
  • Oracle:
    • Issue with parcing IF EXISTS statements was fixed
    • The display of DATE with additional settings in the Result Set was fixed
    • Inromation about latest statistics update was added
  • PostgreSQL:
    • Generation of ALTER table SQL for foreign tables was improved
    • Role settings were added in generated DDL
    • IDENTITY SEQUENCE were added in generated DDL
  • Snowflake: issue with incorrect import with BIGINT, INT, REAL, FLOAT, DOUBLE PRECISION, and DECIMAL data types was fixed
  • Trino: issue with import files with varchar data type was fixed
• Misc:
  • SalesForce driver was updated
  • ODBC connection error was fixed
  • Java native libraries were added to DBeaver installation directly to avoid app crash cased by system restrictions.
  • DBeaver started to collect user statistics. It is anonymous and optional

• General UI:
  • Issue with zoom in and out with Ctrl++ and Ctrl+
  • in SQL Editor and Data gird was fixed
  • ER Diagram font now depends on the Main font
  • A lot of UI rendering improvements were made
• SQL Editor:
  • Moving with Ctrl+Right/Left now considers words with an underscore and a dollar as a whole word (configurable)
  • Autocomplete for mixed-case was improved
  • Issue with crashing when closing the SQL Editor tab was fixed
  • Order by parsing was improved
• AI: issue with changing settings was fixed
• Data Editor:
  • Data filters support in the Grouping panel was added
  • Opening TXT, JSON, and XML files in external editors was improved on macOS and Linux
  • Rendering of non-display characters was improved
  • Issue with disappearing filter option, when a query returns nothing, was fixed
  • Microseconds epoch transformer was added (thanks to @BobrPetr)
  • Database Navigator: issue with creating a new view was fixed
• Data transfer:
  • Issue with set max column length when exporting in TXT was fixed
  • Issue with export JSON to TXT was fixed
• Databases:
  • Firebird: recognition of procedure parameter data types was improved
  • SQLite: issue with database synchronization with the server was fixed
  • Redshift: issue with renaming a view in Database Navigator was fixed
  • MySQL: issue with the empty privileges list was fixed
  • Snowflake: displaying the creation time of Snowflake views was added
  • TiDB Cloud: telemetry support was added (thanks to @Icemap)
  • PostgreSQL: array presentation was improved
• Localization of Brazilian Portuguese was improved (thanks to @brlarini)

• ER Diagrams:
  • Accessibility support (text reader) was added
  • Many keyboard shortcuts were added
  • Issue with diagram re-layout after options change was resolved
  • Issue with moving focus when searching was fixed
• General UI:
  • Database editors remain open after disconnect (configurable)
  • Clickable hints are now displayed as links
  • Issue with missing icons in the toolbar on MacOS was fixed
  • Font and color changes in the Result Set were improved
  • Large fonts now display correctly on MacOS
• SQL Editor:
  • Auto-completion for INSERT/UPDATE/DELETE queries was improved
  • Font changes are now applied without a restart
• Data Editor:
  • Show numeric values (e.g. infinity) rendering was improved
  • Issue with opening images from value panel in external editor was fixed
• Connectivity:
  • Legacy SSH algorithms support was added
  • Confirmation dialogs now remember user selection
  • The number of attempts to reopen the connection was reduced
  • Ability to connect via SSHJ with unsaved password was added
  • Maven artifacts configuration now supports classifier
• Data transfer: column description support was added for CSV and XLS formats
• AI (ChatGPT): unsupported AI models were replaced with new ones
• Databases:
  • Firebird: default parameters in procedure definitions were added
  • PostgresSQL: materialized views dependencies were added
  • Databricks: support of table comments were added
  • Oracle: issue with cropped ‘q’ at the end of the string was fixed
  • SQLite: triggers delete was implemented
  • SQL Server: issue with duplicated data types was resolved
• Localization:
  • Traditional Chinese localization was updated (thanks to @hwhsu1231)
  • Traditional Chinese language was added to Windows installer
• Misc:
  • Microsoft store: issue with application installation was fixed on most machines
  • We switched to Java 17 (again)
  • We switched to Eclipse 2023-03 as a base platform

• SQL editor:
  • Results tab now can be detached
  • Editor toolbar now can be customized in preferences
  • Query statistics tab now can be turned off
  • Table metadata search was improved
• SSH:
  • Support of new crypto ciphers was added
  • SHH agents now works properly in Linux
• General UI:
  • Zoom in text editors and data editors was fixed
  • Navigator tree refresh after metadata change was fixed
  • Default font size was increased for MacOS
  • Text font configuration was fixed in multiple dialog windows
  • Connection type settings change now affects UI properly
• Data export: exporting of BLOB values in TXT format was improved
• Native network proxy configuration was fixed
• TiDB: new driver was added (thanks to @Icemap)
• Clickhouse: driver version was updated to 0.4.2
• Firebird: procedure parameters defualt values support was added
• Oracle: additional properties in table info were added
• PostgreSQL: composite data type support was improved
• SQLite: STRICT mode support was added
• Sybase/SQL Anywhere: result set size limitation in SQL was fixed
• Vertica: expired password change feature was added

Changes since 22.3.5:

• SQL editor:
  • Column metadata resolution was fixed for quoted column names
  • SQL console now respects “open separate connection” option
  • Variables resolve in @set and other commands was fixed
  • Copy/paste command was fixed for editors without associated connection
• Data editor:
  • Spatial viewer: lasso tool was fixed for Safari browser
  • Support of WKT format stored in BLOB columns was added
  • Issues with image viewer and BLOB columns was fixed (NullPointer error))
  • Selected columns/rows data export was fixed (issue with BLOB value turning into NULL in UI)
• Accessibility:
  • Font settings are now respected in all editors/popups
  • New keyboard shortcuts schema was added “DBeaver Keyboard Only”
  • Many new keyboard shortcuts were added
  • Catalog/schema selector now supports keyboard only mode
  • Results tab pin/unpin command is now accessible from keyboard (thanks to @hawthorne3341)
  • Reader texts were localized
• Database dashboard create wizard UI was fixed
• Generate SQL dialog now supports connection invalidation
• Clickhouse: driver version was updated to 0.4.1
• Dremio: driver version was updated to 24.0
• Firebird: table colum comments support was added
• PostgreSQL:
  • Issue with URL-based connections was resolved (invalid host name)
  • Execution plan parameters are now saved
• Redshift: varbyte datatype suport was fixed
• SQL Server:
  • UI for Kerberos authentication configuration was fixed
  • Table colum comments support was added
• French localization was fixed (thanks to @alexgille)
• Problems with Kerberos were resolved (we have reverted to Java 11)

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