2022.23
2022-04-30
+ Fixed an issue which could cause a crash for some users.
2020.42
2020-05-08
+ 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)
2019.59
2019-11-25
+ 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.
2019.09.06
2019-09-07
+ 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.