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.

+ Fixed a crash some users could see when restoring app state.

+ Fixed the app icon. It was slightly larger than it should be. [#627](https://github.com/hankinsoft/SQLPro/issues/627) + Fixed an issue where table detection may detect the wrong table if a comment proceeded the query. [#650](https://github.com/hankinsoft/SQLPro/issues/650) + Added autocomplete/syntax highlight support for additional Snowflake functions. [#655](https://github.com/hankinsoft/SQLPro/issues/655) + Fixed a crash that some users were seeing when exporting results. + Fixed a crash that some users were seeing when hitting 'Apply without preview' when editing results.

+ macOS 10.12 or above is now the minimum version supported. + Fixed a crash which could occur when running large queries. [#514](https://github.com/hankinsoft/SQLPro/issues/514) + Importing a CSV file now has the option to truncate the target table before importing. [#511](https://github.com/hankinsoft/SQLPro/issues/511) + Autocomplete with Functions and Keywords will now always default to uppercase. + Fixed a keyboard shortcut issue when using Dvorak layout. + Multi cursor improvements with arrow up/down cursor selection. + Fixed an issue with query line numbers display. + Fixed a crash that could occur on the connections list window. + Fixed an issue that could cause a crash when inserting/duplicating rows, deleting rows, then cancelling actions together on the results grid. + Added the common enter/exit full-screen keyboard shortcut. [#497](https://github.com/hankinsoft/SQLPro/issues/497). + Added some missing Snowflake keywords and functions. [#495](https://github.com/hankinsoft/SQLPro/issues/495) + [492](https://github.com/hankinsoft/SQLPro/issues/492) + Multi-cursor improvements. Cmd+Delete and Opt+Delete now work properly. + Keyboard support added for selecting multi-cursors. Cmd+Option+Up/Down arrows. + Fixed a few crashes which could occur with multi-cursors. + Improved pasting with multi-cursors. + Fixed an issue when inserting rows where the string 'default' could sometimes be used rather than the default value. + You can now rename a MySQL column from the database tree, by right clicking the column name and choosing 'Rename'. + When connecting to MySQL or MSSQL server with an expired password, you can now set a password. + Some improvements with the autocomplete cache. + Fixed an issue where when creating tables, the database tree UI may show garbage values for the table name. + Fixed an issue with shift + click to select text. + Sorting results from a 'basic select' will now use the database server to perform the sort. [#381](https://github.com/hankinsoft/SQLPro/issues/381) + Fixed a crash which could occur when right clicking a result and choosing 'edit'. + Fixed an issue where pasting was sometimes using overwrite rather than insert. [#483](https://github.com/hankinsoft/SQLPro/issues/483) + Multicursor support. [#200](https://github.com/hankinsoft/SQLPro/issues/200) + You can now 'reverse-cycle' the autocomplete window. [#473](https://github.com/hankinsoft/SQLPro/issues/473) + Working on resolving an issue where the cursor position might jump when autocomplete is entered. [#476](https://github.com/hankinsoft/SQLPro/issues/476) + Autocomplete delay has been reset to the default (1.25 seconds). Due to a bug which had caused some users autocomplete to set to zero. + Adding or removing tables via the query editor (ie CREATE TABLE/DROP TABLE) will now update the database tree and autocomplete. [#10](https://github.com/hankinsoft/SQLPro/issues/10) + Autocomplete now wraps when using up/down keys. [#473](https://github.com/hankinsoft/SQLPro/issues/473) + Selected rows in the results grid now highlight the row numbers. [#465](https://github.com/hankinsoft/SQLPro/issues/465) + Added COALESCE keyword. [#469](https://github.com/hankinsoft/SQLPro/issues/469) + Adding/removing/altering a table will now update the database tree and autocomplete. [#10](https://github.com/hankinsoft/SQLPro/issues/10) + Fixed insertion text for CTEs and aliases. [#296](https://github.com/hankinsoft/SQLPro/issues/296) + Snowflake will now display // as single line comments. [#456](https://github.com/hankinsoft/SQLPro/issues/456) + Database names colors are now customizable for the query editor. [#404](https://github.com/hankinsoft/SQLPro/issues/404) + Made some attempts at fixing autocomplete window sometimes appearing in the incorrect location. [#377](https://github.com/hankinsoft/SQLPro/issues/377) + Autocomplete delay now has a preference. [#394](https://github.com/hankinsoft/SQLPro/issues/394) + Fixed a crash some MSSQL users would see.

+ 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.