Changelog

Fixed

• Snowflake now supports Key Pair Auth #113
• CoPilot will now quote identifiers in case sensitive dialects #154

Changed

• Snowflake supports full introspection, and procedures are now supported.

Fixed

• Handle urls that cannot be parsed in autodisovery and manual discovery. #152

Changed

• Updated Snowflake connections to support SSO, Warehouse, and Secondary Roles. #113
• Updated Redshift to the new introspection model. #146

Changed

• Updated MySQL/MariaDB to new introspection model. #145 #132 #122

Fixed

• MySQL/Maria null dates (0000-00-00) were causing a results not to render. #137
• Notebook results windows were incorrectly sized. #144

• Added preview support for IBM DB2
• Added a completion item to include all fields in a table when typing table.*

Fixed

• Result columns are now resized sooner to avoid the flash of resizing on initial loading.
• Result columns can now be dragged as wide as needed.

Changed

• Added support for MotherDuck. #136

Fixed

• Fixed Snowflake schema to default to public.

Changed

• Preview of Snowflake support. #113

Changed

• Added a setting to control the date/time format. #85
• Added a setting to control if dates should be shown in your computers local time, or UTC when timezone information is present. #85
• Changed Postgres supported version to 9.5 or higher. #129

Fixed

• Maria text fields were showing as binary.
• Postgres introspection error on version 9.5 through 10. #129

Changed

• Datetime columns with timezone information now show in the local time. #85
• Datetime columns now display in the locale/region format of the computer. #85
• Editing a datetime column will highlight the cell in red if the value does not parse.
• Datetime columns that are edited are converted to ISO format when sent to the database.

Fixed

• Tab did not set the cell value when editing data and the cell contained a drop down.

• Keybinding to show DB Explorer does not break find next (cmd/ctrl+d). #121
• Executing tabs can be closed, will prompt to cancel execution. #125
• Potential fix for Postgres queries not returning. #125
• Bit fields handled correctly in the data editor.

Fixed

• SQL Server was not handling UTF strings correctly in data changes.
• Checkbox removed from the table editor.

Changed

• Moved create database context menu item to the Connection in the DB Explorer.
• Added context menu item to add a connection to a group.

Fixed

• Connection error with MariaDB 10.5 through 10.6.10.
• Added OUTPUT clause to procedure parameters.

Changed

• Added a fallback autocomplete to use when parser cannot parse the SQL.

Changed

• Prevented autocomplete from suggesting a lot of syntax, single character tokens.

Fixed

• Tables with foreign keys across schemas would not open correctly in the grid detail feature.
• Tables with foreign keys to tables in other schemas which the user did not have access to caused an error. #118
• Change MongoDB to use direct connection when not using SVR protocol. #119