• SQL Editor:
  • Added support for SELECT INTO query smart completion
  • Changed shortcuts for result set zoom: Ctrl+Aalt+0 and Ctrl+Alt+9
  • Fixed the order of completion suggestions in the proposals list
  • New completion engine:
    • Fixed a bug with duplicating alias part during column completion
    • Fixed autocomplete for join conditions when multiple joins are present
    • Proposals list now contains only objects from the next hierarchy level
    • Fixed autocompletion for SELECT statements with table hints for SQL Server
  • Fixed the issue where the old result set tab didn’t close when switching between multiple and single tab modes
  • Fixed a stack overflow error that occurred when a user tried to execute a script for an open result set with row coloring
  • When an error occurs, the last executed query is now displayed next to the error message
  • Fixed an exception that appeared while typing
• AI assistant: Fixed syntax issues in queries generated by Azure Open AI
• Data Editor:
  • Added hints for geometries with SRID and for timestamps with time zones
  • Added the ability to configure hint visibility for a table or a datasource
  • Hints presentation was enhanced
  • Added backslash escaping when generating scripts
  • Added an option to disable the dictionary view (set “Maximum amount of elements” to 0)
  • Fixed freezing issues when pasting big number of rows or when performing find/replace
  • Added an option to save XML and JSON files in compressed format
  • Fixed data editor filters for commoт table expressions
• Miscellaneous: Added the ability to create bookmarks from the context menu of object tabs
• Databases:
  • Cloudberry driver was added
  • CUBRID: Fixed view name generation in DDL (thanks to @longhaseng52)
  • MySQL:
    • USAGE privilege is now hidden if any other privilege has been granted
    • Fixed loading of DBA privileges
  • PostgreSQL: Fixed the display of infinity for date values

• SQL Editor:
  • New autocompletion engine was enabled by default
  • New autocompletion was enhanced with support for USING, INSERT statements, nested queries, and fixes for multiple issues
  • You can now use the @ai command followed by a natural language phrase to instantly execute it as a query (requires AI extension)
  • Icons in SQL Editor toolbar were redesigned
• Data Editor:
  • Dark theme support was improved, selection background was changed
  • Row hints were redesigned: key information is now displayed, the foreign key editor can be accessed via a right-click on the icon, icon rendering was improved
  • Context menu for Filters was simplified: all items are now on the same menu level
• Data Transfer: Added an option to replace line break character when exporting to CSV
• Connectivity:
  • Title for the Test Connection details was corrected
  • Fixed an issue with network profile saving
• Miscellaneous:
  • Performance of theme switching was improved to enhance the user experience
  • Localization files were converted to UTF-8 to improve the localization process and enhance code readability
  • Numerous minor UI improvements related to editors and dialogs coloring and fonts
• Databases:
  • MySQL/MariaDB: Removed redundant slashes in data export to SQL format
  • PostgreSQL: Both Asia/Calcutta and Asia/Kolkata time zones are now supported
  • Teradata driver was updated to version 20.00.00.38

• SQL Editor:
  • Added AS before table alias in FROM clause for all relevant databases
  • New autocompletion: added support for USING and some improvements for JOIN condition
  • Fixed indentation behavior when adding a new line
  • Added support for ${time} variable in data source variables for script templates (thanks to @pajonas)
• Data Editor:
  • Cell hints were redesigned. You can configure them on the Context menu
  • Added support for the composite types for Grouping panel
  • Items with the too long text in query history were truncated
• Navigator: Saving filter for database objects was fixed
• Data Transfer: Added the ability to use comma as a delimiter in the Advanced Copy option (thanks to @GFreitasW)
• Connectivity: Proxy configuration loading was fixed
• Miscellaneous:
  • Proper names for catalog/schema are now used for different drivers
  • Added word wrap for hints to controls
  • Search in Preferences was improved
  • Scrolling in the “Tip of the day” window was fixed
  • Metadata configuration files were moved to the .metadata/config folder
  • Localization of basic controls, settings, and menu items was fixed
  • We migrated to Eclipse 2024-12
• Development: Building of IDEA project was fixed
• New Drivers: Databend database was added (thanks to @rad-pat)
• Databases:
  • CUBRID: Added REUSE_OID, COLLATE, and COMMENT to the table DDL (thanks to @longhaseng52)
  • Google BigQuery driver was updated to version 42_1.5.4.1008
  • InterSystem IRIS driver was updated (thanks to @bdeboe)
  • MySQL:
    • Now users can change expired password
    • Added a setting to not export routines (thanks to @pajonas)
  • OpenEdge: query generation was fixed
  • OrientDB driver was updated
  • PostgreSQL:
    • Added default privileges grantor to DDL
    • Syntax error in DDL generated for the role settings was fixed
    • Default privileges for new roles were fixed
  • Salesforce Data Cloud driver was updated
  • Snowflake: Added support for table aliases in autocompletion
  • SQLite: creating new constraint from selection was fixed (thanks to @eusebe-cda)
  • SQL Server: Primary Key ordering in DDL generation is now respected

Changes since 24.2.5:

• Data Editor:
  • Row coloring mapping now respects the visual order of columns
  • Fixed invalid thread access on editing data in multiple results in one tab mode
  • Boolean icons display was fixed
  • Ability to detach result tabs is now limited to tabs with data
• SQL Editor: underscore in identifiers are now supported in query validation
• Navigator:
  • Multiline comment display was fixed
  • Scrolling during drag-n-drop was fixed
• Data Transfer:
  • Commit/rollback behavior during the data import was improved
  • It’s now possible to not specify quote and escape characters during the import of CSV files
• New Drivers: GBase 8s is now supported (thanks to @Wintianis)
• Miscellaneous:
  • Snap build was fixed again
  • Fixed connection creation from the “File” option in the main menu
  • Fixed an issue where reading generic foreign keys
  • Option “Open separate connection setting” on SQL Editor and Metadata pages was disabled for embedded databases
• Databases:
  • Azure SQL Server: restored the “Show all databases” option in the Connection dialog. And added an error message to guide users on creating a new connection to access other visible databases
  • BigQuery: Procedures handling is now supported in SQL editor, including LOOPS, IFs, BEGIN END, and CASE
  • MySQL: Fixed an issue with table refresh when the “Server-side object filters” option is disabled
  • Oracle: BOOLEAN type is now supported in Data Editor
  • PostgreSQL:
    • Schema permission editing was fixed
    • Default privileges rendering was fixed
  • RisingWave: array handling was improved
  • SQLite:
    • Fixed an issue with duplicate primary key generation in SQL scripts (thanks to @eusebe-cda)
  • Fixed an issue with deleting a column without a data type (thanks to @eusebe-cda)
  • CSV driver was renamed to CSV Basic

• New drivers: New LibSQL/Turso driver was added
• SQL Editor:
  • Fixed script execution on disconnected state
  • New autocompletion behavior was enhanced
  • Added execution time in statistics result (thanks to @tlm365)
• Query manager: Time column now orders chronologically
• Metadata: Indexes have been returned to the unique constraint list, and the proper data type is now set when creating a new column for a new foreign key
• Data Editor:
  • Fixed an issue with crash caused by too long tooltips
  • Row coloring mapping was fixed
• Data Transfer: “Minimum column length” was renamed to “Default column length”
• Connectivity: “Driver properties” tab in the driver editing dialog was renamed to “Default properties”
• Charts and Dashboards: Fixed charts COUNT for single value
• Miscellaneous:
  • Windows Server 2016, Windows Server 2012, and Windows 8.1 are supported again
  • Snap build was fixed
  • Eclipse extension installation was fixed
  • Query execution canceling was redesigned
  • Issues with unexpectedly closing connections were resolved
  • Added references to the actual boolean editor in Preferences
• Databases:
  • Added support for Hive 4
  • Altibase: Lock manager has been added (thanks to @zennken)
  • CUBRID:
    • Added the ability to create and edit triggers (thanks to @longhaseng52)
    • Added sargs, edge and Query parameters to the Execution plan (thanks to @rathana-pvs)
  • Oracle: Fixed highlighting for public schemas
  • PostgreSQL:
    • Added date picker and fixed data saving in the Role editor
    • Fixed highlighting for public schemas
    • Connection to custom schemas was fixed
    • Fixed data change saving in Value Panel
  • Teradata:
    • Multi-row insert was fixed in data import
    • Fixed incorrect display of PERIOD data type
    • Max rows handling was improved

• SQL Editor:
  • A warning is now shown instead of an error when a DROP TABLE statement contains IF EXISTS and the table does not exist
  • Fixed script execution on disconnected state
  • New autocomplete engine now expands the * symbol in SELECT statements when using “Ctrl + Space”
  • New autocomplete no longer suggests query-start keywords in the middle of queries
  • Metadata requests are no longer sent while typing a query when “Auto-activate on typing” is enabled
• Data Editor: exception on disconnection was fixed
• Navigator:
  • Added the ability to refresh the database connection
  • Filters were fixed
• Data Transfer: Added the ability to export JSON values as embedded JSON
• Connectivity:
  • Presentation of driver download errors has been improved for better clarity and user experience
  • Finding class in the Driver manager was fixed
• Miscellaneous: the Export Window now advances properly when pressing the Enter key
• Databases:
  • Altibase: Module Memory Usage was added to the system information folder in the navigator tree (thanks to @zennken)
  • ClickHouse: Array syntax highlighting has been improved
  • CUBRID: “Use SQL to limit fetch size” was set to true (thanks to @hwany7seo)
  • Fixed an exception that occurred when creating a column without specifying a data type
  • Ingres: driver download was fixed
  • Redshift: access to external databases was fixed
• Localization: Brazilian Portuguese localization was enhanced (thanks to @brlarini)

• SQL Editor:
  • “Show values setting” in the autocompletion section is disabled by default due to performance issues
  • Added highlighting and validation of synonyms
  • Semantic error style was changed
  • Fixed issues with highlighting that occurred when saving the script
• Metadata: Fixed and exception that appeared on right click on table properties
• Connectivity:
  • Fixed an issue where script execution would not stop when disconnected
  • Added an ability to export driver files from the “Edit driver” dialog
  • Fixed user name display in SSH profile
• Miscellaneous:
  • Added additional Java configuration file independent of the product version update
  • Added the ability to disable Windows Defender at startup, which speeds up application loading
  • Some SWT errors were fixed
  • Darkest Dark theme installation was fixed
  • Added the ability to work with OS usernames containing special characters
  • Git extension installation was fixed
  • Eclipse license text was updated
  • Fixed exception that appeared when loading procedure
• Databases:
  • BigQuery: Array and JSON display was improved
  • Db2 z/OS: Fixed broken configuration for generic drivers
  • DuckDB: BLOB display was fixed
  • MySQL: Added support for table name in backticks for SQL Editor
  • PostgreSQL: Permission editor was fixed

• SQL Editor:
  • ‘Cmd+Enter’ shortcut was added in addition to ‘Ctrl+Enter’ on macOS due to the conflict with new system hot keys in Sequoia
  • Fixed an error in multiple tab mode execution when the new execution results replaced old ones
  • The amount of problems being displayed per script query was limited
  • Complicated table qualifiers (database.catalog.schema.user) are now supported
  • Fixed incorrect highlighting after the database disconnect
  • Query execution time is now displayed in seconds/minutes
  • Added an ability to select the text between brackets using ‘Ctrl+Shift+]’ hot key
  • Background Tasks view now shows progress of autocompletion engine
• Data Editor:
  • Presentation and editing of struct and array data types was significantly improved
  • DBeaver can now correctly display negative dates in MySQL databases
• Data Transfer: changed icons for collapsed sections to improve the interface readability
• Connectivity: fixed error handling when a user loads a driver and has an error with certificates
• Navigator:
  • Table filters in Simple view were fixed
  • Disabled the ability to delete the currently active project
• Miscellaneous:
  • Incorrect sorting in Execution log was fixed
  • Issue with not working boolean setting editor was fixed
• Databases:
  • Altibase: added display of the list of tables and indexes within a tablespace (thanks to @zennken)
  • CUBRID:
    • Added the ability to create, edit, and drop Server via UI (thanks to @longhaseng52)
    • Added an ability to create, update, and delete users. (thanks to @rathana-pvs)
  • Oracle:
    • Added highlighting and validation of public synonyms
    • Table autocompletion was fixed
  • Virtuoso: replaced static jar file with Maven artifact

• SQL Editor:
  • Smart syntax highlighting was significantly improved
  • Pseudo columns highlighting was improved
  • Table aliases were fixed in smart completion
  • Issue with pinned tabs was resolved
  • Syntax highlighting fixed for single quoted strings (thanks to @tlm365)
  • SQL console save was redesigned (it now asks for confirmation)
• Data editor:
  • Commit/rollback buttons now enabled only when transactions are applicable
  • Column description rendering was improved for dark theme
• Database navigator: horizontal scrolling was fixed, now action icons are always visible
• Object editor: bottom toolbar layout was unified for all tabs
• Data transfer:
  • CSV parameters documentation was added
  • Database backup/restore dialog layout ws fixed
• General:
  • Snapcraft image now includes additional fonts
  • Embedded browser support was added for Linux/GTK
  • App command line parameters logging was was disabled because of security concerns
  • Issue with splash screen and error message overlapping was resolved
  • Resource leak detection logging was added by default
  • We migrated to Eclipse 2024-09 platform
• Databases:
  • Altibase: database replication metadata was supported (thaks to @zennken)
  • Azure SQL: “show all databases” option was removed
  • CUBRID:
    • Index drop command generation wad fixed (thanks to @longhaseng52)
    • Procedure create dialog was added (thanks to @longhaseng52)
    • List of reserved keywords was updated (thanks to @rathana-pvs)
  • DolphinDB driver was added (thanks to @peeyee)
  • MySQL: NULL geometry values handle was fixed (thanks to @EastLord)
  • Salesforce CDP: connection dialog layout was fixed
  • SAP HANA:
    • Connection dialog was improved for HANA Cloud (thanks to @kai-morich)
    • Expired password change feature was added (thanks to @kai-morich)
  • Trino: issue with long cursor reading was fixed (thanks to @schaffino)
• Localization:
  • Arabic localization was added (thanks to @AliElamir)
  • Brazilian Portuguese localization was updated (thanks to @brlarini)

Changes since 24.1.5:

• 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 fixed
  • SQL Server:
    • SQL Server driver was updated to version 12.8.0
    • Fixed DDL and column display with custom data types
• Localization: French localization was updated (thanks to @KawtharAlakri)