Track our development progress with detailed updates, improvements,
and bug fixes.
v1.16.6
Changed
Execution Plans: Initial preview of execution plan support has been added. #376.
Connection Pinning: Added Oracle, DB2, ClickHouse, and Snowflake (with SSO token caching) support for connection pinning to maintain session state across query executions. #663
BigQuery: Use table list api when opening a table (only possible when no sorting or filtering applied). #693
BigQuery: Added support for dry run query execution. #693
BigQuery: Always show bytes billed, even if 0. #693
BigQuery: Added BI Engine information to the meta data display when present. #693
v1.16.5
Changed
Keyboard Shortcut: shift+cmd/ctrl+d shift+cmd/ctrl+b will open up selector to choose database (or connection) when in a SQL file. #690
Connection Pinning: Added MariaDB, and MySQL to pin a connection to the editor. #663
Connection Settings: Added variable substitution support for file paths in connection configurations. Supports ${workspaceFolder}, ${workspaceRoot}, ${home}, ${env:VARIABLE_NAME}, and relative paths. #683
USE Command: Will update displayed database when database supports USE command and connection pinning.
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
v1.14.30
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
v1.14.29
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
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.