Snowflake Client by SQLPro

RESULTS GRID
- Selecting a range of cells now shows live statistics for that selection, including count, sum, average, minimum, maximum, median and mode. The summary can be turned on or off for each tab independently.
- Added "Select column" to the column header menu.
- Fixed the separator used when copying multiple cells, and added a "Copy with headers" option.
- Added a "Copy nulls as blank string" preference.

EDITOR AND AUTOCOMPLETE
- Fixed column suggestions being dropped for tables referenced without an alias.
- Refreshed the keyword and function lists used for highlighting and completion.
- Added a query formatter command.

DATABASE TREE AND SEARCH
- Added a preference for the sidebar text size.
- Search can now be narrowed to specific object types, such as tables and views only.
- Tables and views now sort consistently once loaded.
- Added shortcuts for renaming and dropping the selected object.

TABLE DESIGNER
- Duplicating a table now correctly carries across triggers, computed columns and existing data, and reveals the copy once it is created.
- Renaming a table no longer fails partway through when other objects reference it.
- Views and triggers that reference a renamed table are now rewritten correctly.
- Saving changes to a large table is faster and uses less memory.

CONNECTIONS
- Connections that have been idle long enough for the server to drop them are retried automatically rather than failing.
- Fixed connections being tested repeatedly in the background, which could cause a server to temporarily refuse new connections.

EXPORT
- Fixed exported data losing non-Latin characters.
- Fixed several issues with generated scripts, including quoting, computed columns and object dependency order.

STABILITY
- Fixed a number of crashes reported since the last release, including ones in the results grid, the messages pane, the connection window and the table designer.
- Long-running queries no longer block the interface while a connection is being opened.

OTHER
- Numerous corrections to spelling, grammar and layout throughout the interface.
- General performance and reliability improvements.

This release focuses on reliability and refinements:

- Improved licensing and activation handling
- Performance and stability improvements
- Various bug fixes

If your purchase isn't detected, tap "Restore Purchase" to reactivate it.

Thanks for using SQLPro! If you're enjoying the app, a rating or review is always appreciated.

+ Performance improvements with the query editor.
+ Crash fix related to the query editor.

+ Fixed an issue which could cause a crash for some users.

+ Improvements with cancelling snowflake queries.
+ Fix for Snowflake not displaying proper affected rows. [#407](https://github.com/hankinsoft/SQLPro/issues/407)
+ Fixed an issue with signed integers being treated as unsigned. [#410](https://github.com/hankinsoft/SQLPro/issues/410)

+ Performance improvements for autocomplete.
+ Fixed a crash which could occur with autocomplete.
+ 'Execute button' now has additional options.
+ Performance improvements for autocomplete.
+ Improvements to state restore where not all tabs were always being restored.
+ Result grid editing - Primary keys are no longer required (but are still encouraged).
+ Result grid editing - When editing cells, changes are no longer applied until the new 'Preview and Apply' button has been pressed. A discard button is also available.
+ Result grid editing - Shift-Tab now works to move to the previous cell (and regular tab now works better due to the previously mentioned change).
+ Improved background drawing in query text view when query execution style is 'execute query in cursor range'.
+ Quoted column names are now handled by syntax highlighting.
+ Creating a table in Postgres no longer displays as reversed schema/table name.
+ Fixed an issue where the 'databases' dropdown in the new/edit connection window could cause a crash.
+ Fixed an issue with could sometimes cause crashes when typing a query.
+ Fixed multiple issues with state restoration.
+ Many buttons now respect the systems accent color (macOS 10.14 and above).
+ Fixed an issue where CTE columns may display incorrect column names. [#314](https://github.com/hankinsoft/SQLPro/issues/314)
+ Fixed an issue autocomplete window may display below the bottom of the screen. [#315](https://github.com/hankinsoft/SQLPro/issues/315)
+ Postgres table designer now supports Table comments. [#313](https://github.com/hankinsoft/SQLPro/issues/313)
+ CTEs and Aliases are now highlighted in the query editor (there is a limitation on the maximum query length before this gets disabled).
+ Fix for a crash that could occur with autocomplete [317](https://github.com/hankinsoft/SQLPro/issues/317)
+ Fixed an issue with expand/collapse database tree sidebar (when search tab was selected) which could mess up the UI.
+ Fixed a crash that could occur when right clicking on some database tree nodes and choosing 'refresh'.
+ Fixed a few improvements with state restoration.
+ Improved performance with the search scope selector.
+ Fixed an issue where right clicking on the 'messages results' (contains text such as 'query finished successfully') could cause crashes.
+ Fixed an issue where some MySQL errors would not be displayed to the user.
+ Fixed a performance issue with the connection dialog on macOS 10.13 and before.
+ Fixed searching not working.
+ Fixed an issue you could sometimes not insert into a table from result sets. (Inserting from a result set still requires a 'simple query'). [#312](https://github.com/hankinsoft/SQLPro/issues/312)
+ Added advanced searching. [#180](https://github.com/hankinsoft/SQLPro/issues/180)
+ You can now right click on a table name in the query editor and perform a few actions such as 'select first 1,000 rows', 'script as create statement', 'script as drop and create statement' and 'script as drop statement'. This also works on aliases.
+ Fixed an issue where entering/exiting full screen could be slow.
+ Autocomplete now includes partial matches as well as full matches.
+ Autocomplete is now context sensitive. For example, if you enter `SELECT * FROM myTable WHERE ` autocomplete will suggest myTable and columns related to myTable.
+ Boolean fields now appear with color (green for true, red for false - this is a preference which can be disabled).
+ Boolean fields now display as true/false rather than 1/0 (this is a preference which can be disabled).
+ Autocomplete now includes partial word matches.
+ CTEs are now included in autocomplete.

+ Fixed an issue where NULLs appear as 0.
+ Fixed a connection issue (some users were seeing SSL error messages).
+ Fixed an issue with over aggressive object name escaping.