Changelog

Changed

• Accounts: Added support for offline/air gapped licenses More. #486

Fixed

• BigQuery: Was not handling structs (the driver internally calls them record’s as it turns out). #533

Fixed

• Oracle: Introspection was hanging on some versions. #160
• Snowflake: Fixed issue with manual authentication.
• Redshift: Fixed issue moving across schemas. #493
• Notebook: Export code blocks now style correctly. #206

Changed

• Notebook: Export now supports PDF. #206

Fixed

• SQL: Added from as a reserved word. #531
• Postgres: Fixed compatibility with 9.2 #530

Changed

• Snowflake: Added support for security role in the connection. #271

Fixed

• Stored Procedures: Were not editable. #525
• Clickhouse: Support for passing format null to ignore results, fixing more statements with non standard result returns. #526
• Definition Provider: Handle database.schema notation, also handle quoted identifiers. #528
• Redis: Fixed opening All Keys. #522

Fixed

• Excel: Will now ignore type conversion errors, and make cell null #521
• Postgres: Don’t use information_schema to get tables/views, it was filtering out tables the user did not have permissions for. #512

Changed

• Notebook: Export feature has been added in preview, cannot save pdf/publish yet, chart rendering is still a work in progress. #206
• Favorites: Add items from the DB Explorer, files and text to save items as favorites in the current workspace.

Fixed

• Clickhouse: Delete and insert queries were failing. #518
• Cloud providers: Fixed issue with expanding some providers. #517

Changed

• SQL Server: Included support for SQL Server 2012 and above. #487

Fixed

• Oracle: 12.1 support fixed, also fixed an error with primary key mapping. #160, #505 #499
• Output tab: Was too big in notebook output. #513

Changed

• DB Explorer: Is now decoupled from connections, should be faster, and be more explicit about when connections are connecting/refreshing.

Fixed

• SQLite: Better detection of when to use raw method. #511
• Results: Inserts cross schema were not reflecting the correct schema. #510

Changed

• New schema storage model.
• Clickhouse: Now has a request timeout setting in the configuration. #508

Fixed

• Oracle: Changed compatibility to 12.1.0
• Explorer in some cases could miss map columns to a table.

Changed

• Cassandra: Moved to new introspection model.
• Mongo: Moved to new introspection model.
• Files associated to connections will be remembered per workspace. #412
• Removed the @dbcode Chat Participant in favor of copilot tools and providing context.
• Setting: Workspace Connection: You can set a workspaces default connection, it will be stored in settings and used in quick open, and Copilot Tools. #237
• Copilot/MCP: Added a tool that will get the default connection that if configured for a workspace.

Fixed

• Oracle: Getting support for 12c sorted. #160
• Right click opening files in windows was incorrectly setting file path.

Changed

• Trino: Preview support added. #172
• DuckDB: Supports using a memory only database. #501

Fixed

• Definition on hover will match schemas regardless of case. #488
• Clickhouse: Datatypes are better supported. #462 #463
• Create Database: Was not working in the context menu.

Changed

• Oracle: Moved to new introspection model.

Fixed

• Oracle: Fixed byte sequence error. #477 #456
• Oracle: Use version rather than version_full. #160
• Fixed: Sample database no longer includes extension version in the path. #498

Changed

• Tab Reuse: Changed to follow VSCode enabled limit and limit value, will recycle only if limit editable and tab limit reached.
• Output tab: Shows the execution history and output statements for Databases that support them (SQL Server, Postgres).
• Allow air gapped computers to provide required packages manually. #486

Fixed

• Clickhouse: Support describe statements

Changed

• Accounts: Added a refresh to the account section to refresh information and not require a logout/in.

Fixed

• Autocomplete: Fixed issue with alias not always being matched. #484
• CockroachDB: Error with cluster id caused by SSL configuration in #445
• Tab Reuse: if workbench.list.openMode is set to doubleClick tabs wont be re used, since no way to track the double click, and without it only one tab can be opened.

Fixed

• Postgres: Was not handling infinity/-infinity dates. #482
• Quick Script: Was not setting connection on the new file. #349
• Open new file: Was not working when executed from the command pallet instead of the tree. #483