Changelog

Changed

• Results: Added option to count all rows when red row count is shown. #509
• SQLite: Added sqlite-js and sqlean extensions.
• Editor: If you use the keyboard shortcut, or execute icon without the cursor in an active statement, you will be prompted to confirm executing the whole document.

Changed

• Import: Auto match columns based on name. #555

Fixed

• SQL Server: Windows Authentication was broken after version 1.13.17. #563

Changed

• Azure Synapse: Added support for Synapse. #544
• Explorer: Added right click options to create, drop and rename schemas where applicable.
• Colors: Added dbcode.activeStatementBackground and dbcode.activeStatementBackground. #542

Fixed

• Postgres: Re worked detection of support for using internal PG functions in introspection. #548
• Clickhouse: Decode map data types #562

Changed

• Query Parameters: Support reuse of parameters.. eg &actorId||1||number can be re used in the same query as just &actorId

Fixed

• Postgres: Introspection was failing on 9.3 #551
• SQL Server: Support Microsoft Fabric SQL Servers. #382
• Query Parameters: Fixed dates with time in them.
• Results: Removed contains and other non support filter types on UUID columns.

Fixed

• Clickhouse: Re working this to pick up the standard ones as a fallback. #538
• SQL Server: Introspection performance improvements. #425
• SQL: Various engines need backslash \ escaped in string literals. #540

Fixed

• Supabase: Was not correctly switching projects for db account creation. #536
• Clickhouse: Catch a few more non standard SQL statements that need to run through the command path. #538
• Redis: Show empty keyspace is none are found. #535

Fixed

• Postgres: Was not handling search path’s with escape characters “$user”. #537
• Notebooks: Export was incorrectly ordering code blocks. #206
• Notebooks: Not always restoring output in some cases when output was saved with the notebook.

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