SQLPro for MSSQL

+ Added support for right aligning numericals. [#914](https://github.com/hankinsoft/SQLPro/issues/914)
+ Added support for importing from JSON files. [#924](https://github.com/hankinsoft/SQLPro/issues/924)
+ Added support for exporting tables directly to Json via the database tree table context menu.
+ Moved themes location on file system. [#780](https://github.com/hankinsoft/SQLPro/issues/780)
+ Added support for keyboard shortcuts to export result sets as csv/json/xml. [#913](https://github.com/hankinsoft/SQLPro/issues/913)
+ Renaming a table will instantly update the autocomplete. [#922](https://github.com/hankinsoft/SQLPro/issues/922)
+ You can refresh a tab loaded from the file system by right clicking the tab and choosing 'Reload file'. [#902](https://github.com/hankinsoft/SQLPro/issues/902)

+ CSV export new remembers the previous settings. [#885](https://github.com/hankinsoft/SQLPro/issues/885)

+ Fixed an issue which could cause crashes when skipping columns during CSV import. [#424](https://github.com/hankinsoft/SQLPro/issues/424)
+ Fixed an issue which could cause crashes when cancelling a query or closing an tab with an active query running. [#416](https://github.com/hankinsoft/SQLPro/issues/416)
+ Fixed an issue where right clicking on an escaped table name in the query editor would sometimes result in a 'No object selected' issue. [#396](https://github.com/hankinsoft/SQLPro/issues/396)
+ Fixed an issue with keyboard shortcuts would not save properly if tab characters were used. [#403](https://github.com/hankinsoft/SQLPro/issues/403)
+ Fixed an issue where when importing from CSV, the focused table may not be defaulted. [#405](https://github.com/hankinsoft/SQLPro/issues/405)
+ No longer setting `SET QUOTED_IDENTIFIER OFF` when updating results.
+ You can now specify IDENTITY details when creating a new table or adding a new column. [#374](https://github.com/hankinsoft/SQLPro/issues/374)
+ You can now reorder columns when creating a table.

+ Fixed a crash that could when inserting a new row.
+ Fixed a crash that could occur with autocomplete.
+ Improvements to database search.
+ Fixed an issue with CSV import into existing table.
+ Fixed an issue with state restoration. The database tree was not getting preserved when you disconnect from a database.
+ Fixed a crash that could occur when duplicating tables.
+ Fixed an issue when duplicating tables where the source table was not always the one duplicated if the source table was not the table select in the database tree.
+ Fixed an issue which could cause crashes when inserting into a result set.

+ Fixed an issue with the 'Disable' option of 'Execute query in cursor range' where the current query would still be highlighted when modifying a query.

+ Fixed an issue which could cause duplicate databases in the server/database dropdown.
+ If you have true/false setup for boolean display, 'Copy as insert' will now keep 1/0 (as true/false is not valid for insert).
+ Fixed a crash that could occur when selecting 'Duplicate table' from the database tree view.
+ Fixed an issue when setting a column value - pressing the disclosure indicator (dropdown arrow) before hitting apply, the old value would still be displayed.
+ Fixed an issue when setting a column value to a large string value an error may occur.
+ Fixed an issue where the 'update row value' text editing window line numbers may appear incorrect colors.

+ You can now duplicate tables (including data) via the database tree.
+ Autocomplete is now context sensitive when using the UPDATE command.
+ The 'current query highlighting' is now disabled by default (matches previous versions of the app). It can be enabled in the Application preferences.

+ Fixed an issue with setting the current theme (the theme preference display would be incorrect upon next app launch).
+ Fixed an issue where running multiple queries with result sets may collapse the results.
+ Fixed an issue with scripting procedures which could reset QUOTED_IDENTIFIERS to the incorrect value.
+ Split `Copy as -> Formatted text` into two separate options. `Formatted text (Markdown)` and `Formatted text (Monospace)`.

+ Performance improvements for autocomplete.
+ Fixed a crash which could occur with autocomplete.
+ 'Execute button' now has additional options.
+ Fixed an issue with datetime columns applying a timezone offset.
+ 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).
+ Importing CSVs into Oracle is now quicker to list tables.
+ 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.

+ Fixed an issue where some users were unable to open files.

+ Fixed an issue with some MSSQL connections which could crash when failing to determine default schemas.

SQLPro 2019.53
+ [macOS] Fixed an issue where some MSSQL users may not see tables when the database tree is expanded.
+ [macOS] Fixed an issue where the 'databases' dropdown in the new/edit connection window could cause a crash.

SQLPro 2019.52
+ [macOS] Fixed an issue with could sometimes cause crashes when typing a query.

SQLPro 2019.51
+ [macOS] Fixed compatibility with macOS 10.11 and MSSQL connections (connecting to MSSQL would crash).
+ [macOS] Fixed multiple issues with state restoration.
+ [macOS] Many buttons now respect the systems accent color (macOS 10.14 and above).

SQLPro 2019.50
+ [macOS] Fixed an issue where CTE columns may display incorrect column names. [#314](https://github.com/hankinsoft/SQLPro/issues/314)
+ [macOS] Fixed an issue autocomplete window may display below the bottom of the screen. [#315](https://github.com/hankinsoft/SQLPro/issues/315)
+ [macOS] Postgres table designer now supports Table comments. [#313](https://github.com/hankinsoft/SQLPro/issues/313)
+ [macOS] CTEs and Aliases are now highlighted in the query editor (there is a limitation on the maximum query length before this gets disabled).
+ [macOS] Fix for a crash that could occur with autocomplete [317](https://github.com/hankinsoft/SQLPro/issues/317)

SQLPro 2019.49
+ [macOS] Fixed an issue with expand/collapse database tree sidebar (when search tab was selected) which could mess up the UI.
+ [macOS] Fixed a crash that could occur when right clicking on some database tree nodes and choosing 'refresh'.
+ [macOS] Fixed a few improvements with state restoration.
+ [macOS] Improved performance with the search scope selector.

SQLPro 2019.48
+ [macOS] Fixed an issue where right clicking on the 'messages results' (contains text such as 'query finished successfully') could cause crashes.
+ [macOS] Fixed an issue where some MySQL errors would not be displayed to the user.
+ [macOS] Fixed a performance issue with the connection dialog on macOS 10.13 and before.
+ [macOS] 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)
+ [macOS] Added advanced searching. [#180](https://github.com/hankinsoft/SQLPro/issues/180)

SQLPro 2019.47
+ [macOS] The `update available` database tree node, now includes a `Changelog` link. [#266](https://github.com/hankinsoft/SQLPro/issues/266)
+ [MSSQL] Fixed an issue where datetime(2) fields were not properly displaying milliseconds.

+ [MSSQL] Fixed an issue where datetime(2) fields were not properly displaying milliseconds.

+ Fixed an issue with setting values from result sets.
+ 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 prefernce which can be disabled).
+ Boolean fields now display as true/false rather than 1/0 (this is a preference which can be disabled).
+ CTEs are now included in autocomplete.

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

+ Fixed a case where connections to a MSSQL server could fail.

+ Fixed an issue with numeric data types not displaying scale.
+ Fixed an issue with 'Format Query' not handling GO statements.

+ Fixed a crash that could occur when pasting queries overplace of existing queries.

+ MSSQL script tables now includes foreign keys.
+ Fixed an issue where many 'Untitled files' would appear in iCloud Drive.
+ Resolved some issues with SSH Tunneling.
+ You can now duplicate connections.
+ You can now customize results grid appearance.

+ Fixed an issue where the app could close for some users when opening preferences.
+ The connections window is now resizable on systems running macOS 10.14 and above.
+ Autocomplete no longer requires the AS keyword to detect table aliases.
+ Fixed a crash that could occur when connecting to sample database.

+ Fixed an issue where the app could close for some users when opening preferences.
+ The connections window is now resizable on systems running macOS 10.14 and above.
+ Autocomplete no longer requires the AS keyword to detect table aliases.

Added a new 'keyboard' preferences panel.
+ Query execute shortcut has been moved to this panel.
+ Comment/uncomment keyboard shortcut has been added.
+ Default separator and qualifier for copying results can now be specified. It defaults to comma and double quote, but you can change it as needed.
+ You can now use CTRL + ] to switch between the beginning/end of control statements.

+ Improvements with CSV importing (specifically around handling blank/empty values).