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