DBeaver full changelog

SQL Editor:
Fixed highlighting of block $$ for functions and procedures when the semantic analysis option is enabled
Warning and errors handling and presentation was improved
Subquery semantic analysis was enhanced
Improved CREATE and DROP queries handling
Autocompletion for fully qualified names was fixed
Duplication of proposals with new completion engine enabled was fixed
Incorrect suggestions with new completion engine enabled were fixed
AI Assistant:
Added new model ‘gpt-4o-mini’
Removed deprecated model ‘gpt-3.5-turbo-16K’
Fixed query generation when enabled formatting
Data Editor:
Some datatypes icons were changed
Fixed filtering on columns with spaces
Added an ability to render geometry shapes in their assigned color if a ‘color’ column is present in the result set
Improved handling of fully qualified names in Grouping panel according to SQL dialect
Local links opening was restricted
Datatransfer: Data transfer windows width was fixed
Connectivity: Fixed verification of the 127.0.01 host when connecting via SSH
General:
Fixed flipping splash screen on macOS Sequoia
Foreign Data wrappers configurator was fixed
‘Open auth links in embedded browser’ setting was disabled by default
Search in Preferences was improved: added keywords for reopen, open, Hippie, autosave, and others
Fixed selection of wrong database when changing connection for database with similar names
Folder display in Simple view was fixed
Numeric (DWORD) type parameters in Windows Registry are now supported
‘Ctrl+Alt+Left / Right’ hotkeys for ‘Previous Edit Location’ and ‘Next Edit Location’ were fixed
Databases:
Clickhouse: Filtering by the Date data type was fixed
MySQL: Error/output log dump was fixed
PostgreSQL:
Ordering by interval datatypes in the Data grid was fixed
Added regexp functions support in SQL Editor (thanks to @anton-erofeev)
Redshift:
Connection stability was significantly improved
DDL presentation was fixed
Role, User, and Group presentation was f

SQL Editor:
Added semantic analysis and Outline viewer support for CREATE and ALTER TABLE queries
Added presentation for warnings in semantic analysis results
Data type icons were redesigned
SQL error presentation was redesigned
‘Execute SQL Script’ option behavior was fixed
SQL Output for SQL scripts was fixed
Output panel opening was fixed
Column aliases can now be copied with Advanced Copy option (thanks to @dstivanov)
Column validation for UPDATE SET clause was fixed
Issue with invalid table name was fixed
If all tabs with query results are pinned, a new tab with a new query result is created
Data Editor:
Paste into the table with no foreign key was fixed
Database Navigator:
Connection visualization was fixed
Navigator icons were redesigned
Connectivity: Connection page for custom drivers with the URL template was fixed
General:
Opening links to local files has been restricted due to a security issue discovered by @LuskaBol
Improved error handling when trying to use not allowed characters in project name
Databases:
Altibase: Non-schema objects like Job, Database Link, Directory, and Library are now supported (thanks to @zennken)
BigQuery: Database monitoring dashboards were added
GaussDB driver was updated to version 4-1.1 (thanks to @GaussDB-Fans)
MariaDB: Geometry data type is now supported
Ocient: Incorrect DDL generation was fixed (thanks to @mjsterckx)
SQLite: Full text search was improved
SQL Server: Saving changes in procedures was fixed

InterSystems IRIS driver was updated to version 2024.1
PostgreSQL: If the database name is empty, it will be set to the same as the username
SAP Hana: Additional system table prefix was added
SQL Server: Ability to upgrade/install the driver was fixed
SQL Editor:
Problem markers with semantic error descriptions were added. You can click on the problem description in the tooltip to find out what is wrong with the query.
INSERT, DELETE, UPDATE, DROP, CREATE, and ALTER statements execution in read-only mode was prohibited
Smart mode for Blank line state delimiter was improved
Simultaneous query execution was fixed: if a query is already being executed, you can execute another query in a new tab only
Composite type field color became visible in the Dark theme
Completion analyzer performance was enhanced
Data Editor:
Inline editing of geometry fields was fixed
New keyboard shortcut Ctrl+Shift+Alt+C has been added to use the advanced copy option with the latest settings, without opening a popup window
Metadata Editor: Generate SQL option in the context menu was fixed
Connectivity: Closing idle connections and default timeout were fixed
General:
Users can import connections from SQL Workbench and DbVizualizer
Wayland support on Linux was fixed
Several code improvements have been made
Databases:
GaussDB driver was added
Couchbase: Legacy Couchbase driver was removed
CUBRID:
Execution plan was enhanced
Issue with Null datatype was fixed
Creating partition option was removed
InterSystems IRIS driver was updated to version 2024.1
PostgreSQL: If the database name is empty, it will be set to the same as the username
SAP Hana: Additional system table prefix was added
SQL Server: Ability to upgrade/install the driver was fixed