Changelog

Changed

• Results: Added keyboard shortcuts to the tooltips.

Fixed

• SQLite: Fixed issue where primary keys were not detected when not present in PRAGMA_index_list.
• Cassandra: Fixed SSL certificate validation errors. #640
• Oracle: Fixed crash when using Instant Client after initialization. #674

Changed

• Firebase: Added support for editing sub collections.
• Firebase: Added support for multiple Firestore databases.
• Code Completion: Experimental LS now provides table/column context and CTE understanding.

Fixed

• Trino: Fixed map, array, and row types displaying as “[object Object]” in query results. #670

Changed

• Firebase: Handles setting (undefined) for a value to make the key undefined.
• MongoDB: Handles setting (undefined) for a value to make the key undefined.

Fixed

• Added groups to escaped identifier list.

Changed

• Result: Editor now auto formats and focuses when opened, as well as auto detecting language.
• Firebase: Will destructure data into keys where possible allowing specific key editing.
• Code Completion: Will use new experimental language server if enabled.

Fixed

• SQL Server: Fixed BIT columns incorrectly exported as ‘true’/‘false’ instead of 1/0 in SQL Insert statements. #658

Changed

• Firebase: Added initial preview support for Firestore and Realtime (editing not supported yet, might be some bugs.) #295
• Syntax validation: Fixed semantic validation not working, enhanced grammar support, added fallback ANSI grammar.

Changed

• Parquet: Added support for parquet files. #177
• Avro: Added support for Avro files.
• Redis: Added editing support (update, delete, insert), as well as editor logic for hash/sets. #39
• CSV and Excel: Underlying files will be watched for changes, and re-load the data if the underlying file changes.

Fixed

• Tunnels: Will now better handle reconnecting, and if it fails, will close connections that were using them to avoid connections attempting to use closed tunnels.
• Notebooks: Fixed issue with canceling and connection pinning. #663

Changed

• Syntax validation: Experimental support for SQL syntax validation added (Postgres and Maria/MySQL initially).

Fixed

• Postgres: Would not format data types correctly on initial table load in some cases. #107
• Excel: Was not filtering reserved words in sheet names. #659

Changed

• Results: VSCode editor now used in JSON/XML datatypes, and can be opened on any field using the open in editor icon (replaces old open in editor). #107
• Connection Pinning: Will now destroy a connection if keep alive statement fails. #578 #648

Fixed

• Trino: Uses line numbers in errors to reduce highlighting when present.
• Export: Fixed issue with SQL Insert statement export. #655
• Inspector: Show correct data types in the JSON view.
• Inspector: Added proper editor to JSON and XML data types. #107

Changed

• Results: Support for data formatting completed.
• Inspector: Updated to use VSCode editor.

Fixed

• DB2: Fixed issue with SSL connections. #652

Changed

• Results: Added support for data formatting (work in progress).
• Results: Selecting a full row and pressing delete/backspace will now delete the row, rather than clear the contents (cmd/ctrl+delete/backspace will delete partially selected row).

Fixed

• Dragging a table to a new window did not load the data.
• Greenplum: Fixed introspection issue. #651
• Doris: Fixed introspection issue. #645
• Results: Fixed issue with sorting other columns, when primary key sorting setting was enabled.

Fixed

• Autocomplete: Fixed issue where it was not working for some databases. #643
• Redshift: Removed JSON method from introspection. #644

Changed

• Connection Pinning: Added support in notebooks, and for Postgres. #578
• Redshift: Added support for external tables (Spectrum). #613

Fixed

• Postgres: Introspection does not get columns for partitioned tables (redundant).
• Postgres: Don’t change schemas for non user based SQL execution. #507
• Oracle: Fixed syntax error being displayed rather than driver error in certain cases.

Changed

• Export/Share: Added support for tab delimiters in CSV export.

Fixed

• Improved introspection performance for large schemas (1000+ schemas)

Fixed

• Explorer mapping columns to incorrect tables in some cases. #628
• IBM DB2: Added latest bindings. #636
• MySQL/MariaDB: Filtering for year was using date rather than number. #633
• Postgres: Updated to support AWS Aurora DSQL. #637
• Parameters: The data type dropdown was not always visible.

Changed

• Data: Transpose mode finalized. #554

Fixed

• Oracle: executing of begin.. end; blocks fixed. #619