+ Fixed an issue with searching when using MSSQL connections.

+ Improvement to 'Run current query'. [#1057](https://github.com/hankinsoft/SQLPro/issues/1057) + Improvement to MySQL comments. [#1055](https://github.com/hankinsoft/SQLPro/issues/1055) + Improvements to scripts Postgres tables with multiple primary keys. [#1056](https://github.com/hankinsoft/SQLPro/issues/1056) + Fixed a crash some users could see when importing csv files.

+ Fixed an issue with formatting queries.

+ Fixed a crash some users were seeing at startup.

+ Fixed a crash users could see when deleting records.

+ Fixed an issue where copy as markdown and copy as formatted text monospaced could have empty fields. [#1020](https://github.com/hankinsoft/SQLPro/issues/1020) + Added an export keyboard shortcut for 'execute secondary query style'. [#1017](https://github.com/hankinsoft/SQLPro/issues/1017)

+ Fixed an issue with column sizing.

+ Added options for autosize columns. [#966](https://github.com/hankinsoft/SQLPro/issues/966) + Fixed an issue with SSH tunnels. [#989](https://github.com/hankinsoft/SQLPro/issues/989)

+ Removed some un-used files. [#985](https://github.com/hankinsoft/SQLPro/issues/985)

+ Fixed an issue where when modifying results inline, after applying or discarding changes there woulds still be a partial visible changes UI. + Fixed an issue that could cause crashes for some users when viewing preferences.

+ Fixed a crash that could occur when modifying MySQL table structures.

+ Fixed an issue that could cause a crash when deleting records. [#965](https://github.com/hankinsoft/SQLPro/issues/965) + Fixed an issue that could cause a crash when removing the 'format query' shortcut. [#964](https://github.com/hankinsoft/SQLPro/issues/964)

+ Fixed a crash that could occur during autocomplete.

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

+ Added an option to set a default query for a table. [#940](https://github.com/hankinsoft/SQLPro/issues/940) + Added an option for generic tabs to not be promoted for a save. [#949](https://github.com/hankinsoft/SQLPro/issues/949) + Added an option to disable the cmd + number shortcuts. [#942](https://github.com/hankinsoft/SQLPro/issues/942) + Added the option to set a default query to be executed for tables. [#940](https://github.com/hankinsoft/SQLPro/issues/940)

+ 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) + You can now delete a MySQL database from the database tree by right clicking on the database and choosing 'Drop database'. (There are confirmations before any deletions). [#911](https://github.com/hankinsoft/SQLPro/issues/911)

+ Fixed an issue with paste.

+ Fixed an issue with CR vs LF. [#904](https://github.com/hankinsoft/SQLPro/issues/904) + Fixed an export issue.

+ Added support for STRICT sqlite tables. + Added FTS3,FTS4 and FTS5 support in sqlite. + When exporting, you can now choose create to create a folder for each entry. [https://github.com/hankinsoft/SQLPro/issues/899](https://github.com/hankinsoft/SQLPro/issues/899)

+ There is now an option to sync preferences via iCloud. [#686](https://github.com/hankinsoft/SQLPro/issues/686) + There is now a preference to auto-capatialize as you type. [#536](https://github.com/hankinsoft/SQLPro/issues/536)

+ Fixed an issue with decimal display. [#890](https://github.com/hankinsoft/SQLPro/issues/890) + Fixed an issue with csv export not showing all schemas in postgres. [#889](https://github.com/hankinsoft/SQLPro/issues/889)

+ Fixed horizontal grid setting not working properly. [#880](https://github.com/hankinsoft/SQLPro/issues/880) + The 'export as csv' settings will now persist. [#885](https://github.com/hankinsoft/SQLPro/issues/885) + Added 'decimal separator' and 'thousands separator' to the results appearance section in preferences. + Made improvements to MySQL connections (there is now an option to disable compression - which is disabled by default). [#884](https://github.com/hankinsoft/SQLPro/issues/884)

+ Fixed an issue where grid appearance was not working properly. [#880](https://github.com/hankinsoft/SQLPro/issues/880) + Fixed an issue with column wildcard search in autocomplete. [#879](https://github.com/hankinsoft/SQLPro/issues/879) + Select all occences context menu will now select the word in scope if no selection has already been made. [#789](https://github.com/hankinsoft/SQLPro/issues/789) + Added support for MSSQL 'table shortcut' in autocomplete. [#877](https://github.com/hankinsoft/SQLPro/issues/877)

+ Added a 'Select All Occurrences' context menu item to the editor. [#789](https://github.com/hankinsoft/SQLPro/issues/789)

+ Improvements with connection storage. + You can now specify the 'focus database tree' and 'focus database tree search' shortcuts. [#870](https://github.com/hankinsoft/SQLPro/issues/870)

+ Made some improvements with storing history. + Fixed a crash which could occur when cancelling a mysql query. + Added a readonly option for connections.

+ Fixed an issue which could cause a crash when discarding changes to edited rows.

+ MSSQL user-created types now show the type details in the database tree.

+ Resolved an issue with 'format query'.

+ Fixed an issue where device sleeping may not properly close all connections. [#847](https://github.com/hankinsoft/SQLPro/issues/847) + Autocomplete insertion can now be toggled to include/exclude tab and enter. [#845](https://github.com/hankinsoft/SQLPro/issues/845) + Improved alias scope detection. [#844](https://github.com/hankinsoft/SQLPro/issues/844) + Fixed an issue where query formatting could skip some objects. [#815](https://github.com/hankinsoft/SQLPro/issues/815)

+ Fixed an issue where views in postgres were being treated as tables. + Fixed an issue where expanding triggers in postgres could cause a crash. [#842](https://github.com/hankinsoft/SQLPro/issues/842)

+ Postgres connection string support. [810](https://github.com/hankinsoft/SQLPro/issues/810) + Fixed an issue with postgres connection speed. [#749](https://github.com/hankinsoft/SQLPro/issues/749) + Fixed an issue with snowflake and variables. [#840](https://github.com/hankinsoft/SQLPro/issues/840)

+ Fixed keyboard shortcut for search in result sets. + You can now re-order result columns. [#818](https://github.com/hankinsoft/SQLPro/issues/818) + Fixed an issue with searching and modify columns. + Fixed an issue with right click -> edit on some postgres result sets. [#821](https://github.com/hankinsoft/SQLPro/issues/821)

+ The truncate table dialog now includes the hostname and database details on the confirmation panel. + Fixed an issue with mssql IDENTITY_INSERT. [#825](https://github.com/hankinsoft/SQLPro/issues/825) + Added a 'find column' hotkey. [#819](https://github.com/hankinsoft/SQLPro/issues/819) + Added a 'make uppercase' and 'make lowercase' hotkey. [#814](https://github.com/hankinsoft/SQLPro/issues/814)

+ Shift + Enter no longer indents. [#813](https://github.com/hankinsoft/SQLPro/issues/813) + You can right click and 'switch to tab' on the tab bar now. [#808](https://github.com/hankinsoft/SQLPro/issues/808)

+ Fixed a crash that could occur when adding a new theme.

+ Added support for changing background color [#805](https://github.com/hankinsoft/SQLPro/issues/805). + Fixed an issue where a new tab may not select the proper database. [#](https://github.com/hankinsoft/SQLPro/issues/806)

+ Fixed an issue which could cause a crash when filtering results.

+ Fixed an issue where removing the default connection group could cause issues with creating and viewing existing connections.

+ Fixed an issue where move/duplicate line up/down would insert extra blank lines.

+ Fixed an issue where some users could not remove connections.

+ Fixed a crash that could occur when editing postgres foreign keys. + Fixed a crash that could occur with the text editor.

+ Fixed a crash that could occur when removing full words or sentences from the query editor and autocomplete was visible. [#672](https://github.com/hankinsoft/SQLPro/issues/672)

+ Fixed an issue which could cause CREATE statements to fail.

+ Fixed a crash that could occur for some users.

+ Fix for crash on setting an empty shortcut preference. + You can now move multiple lines with the `Shift+up` keyboard shortcut. [#763](https://github.com/hankinsoft/SQLPro/issues/763) + You can now duplicate the selected line(s) with the `Shift+option+up` keyboard shortcut. [#764](https://github.com/hankinsoft/SQLPro/issues/764)

+ Potentially fixed a crash that could occur with MySQL connections. + Added the option to set a shortcut for switching between results and messages. [#716](https://github.com/hankinsoft/SQLPro/issues/716)

+ You can now resize the history window. [#399](https://github.com/hankinsoft/SQLPro/issues/399) + Sidebar and window size now store properly. [#411](https://github.com/hankinsoft/SQLPro/issues/411) + Changing the case of a favorites name now works works properly. [#741](https://github.com/hankinsoft/SQLPro/issues/741) + Fixed an issue with multiple select statements not separated with semicolons when using SQL Server. [#758](https://github.com/hankinsoft/SQLPro/issues/758) + Fixed a crash that could occur when exporting mssql encrypted procedures. [#747](https://github.com/hankinsoft/SQLPro/issues/747)

+ Fixed an issue where multiple SQL Server statements without a semicolon could mess up delete/inserts. For MSSQL if a semicolon or go is not used to split statements, then primary keys will not be detected and the results cannot be modified. [#758](https://github.com/hankinsoft/SQLPro/issues/758) + Fixed a crash when exporting encrypted mssql stored procedures. [#747](https://github.com/hankinsoft/SQLPro/issues/747) + You can now resize the history window (and the size will persist). [#399](https://github.com/hankinsoft/SQLPro/issues/399)

+ Fixed an issue with aliases in table names when updating records. [#748](https://github.com/hankinsoft/SQLPro/issues/748)

+ Fixed an issue where some users were not having their purchases recognized.

+ Fixed an issue with connecting to snowflake on Mac silicon systems. + When inserting a row via MySQL, SQLite or SQL Server DEFAULT values will now be processed/displayed instantly. MySQL requires a primary key. SQL Server requires an identity field. SQLite requires rowid to be enabled.

+ Diagnostics for foreign keys.

+ Exporting and scripting MSSQL tables, now includes their triggers. [#327](https://github.com/hankinsoft/SQLPro/issues/327) + MSSQL now includes constraints in the database tree. [#656](https://github.com/hankinsoft/SQLPro/issues/656)

+ Fixed an issue where MSSQL calculated fields were not being scripted. [#711](https://github.com/hankinsoft/SQLPro/issues/711) + Additional fix for crash that could occur when using the filter keyboard shortcut. [#708](https://github.com/hankinsoft/SQLPro/issues/708)

+ Fixed an issue where postgres primary keys would stop loading (causing update and delete commands to fail). [#709](https://github.com/hankinsoft/SQLPro/issues/709) + Fixed a crash that could occur when hitting 'Filter column'. [#708](https://github.com/hankinsoft/SQLPro/issues/708) + Fixed an issue where editing MSSQL tables may miss a closing bracket on default values. [#707](https://github.com/hankinsoft/SQLPro/issues/707) + Fixed an issue where the cancel button could take additional time. [#706](https://github.com/hankinsoft/SQLPro/issues/706) + Favourites have been moved to the file system.

+ Improvements for connecting to MySQL servers.

+ Fixed a crash that could occur when using menu items.

+ You can now copy results 'as update statement'. [#698](https://github.com/hankinsoft/SQLPro/issues/698) + Fixed an issue with MySQL where some users would be unable authenticate. [#703](https://github.com/hankinsoft/SQLPro/issues/703) + Added an 'Enforce SSL' preference to MySQL connections which can be Preferred, Enabled, or Disabled. [#685](https://github.com/hankinsoft/SQLPro/issues/685)

+ Oracle support has been temporary removed. (Until Oracle supports Apple Silicon). [#696](https://github.com/hankinsoft/SQLPro/issues/696) + SQLPro Studio now fully supports Apple Silicon (M1/M1 Pro/M1 Max). [#696](https://github.com/hankinsoft/SQLPro/issues/696) + Improvements for MySQL connections and SSH. [#685](https://github.com/hankinsoft/SQLPro/issues/685] and [#693](https://github.com/hankinsoft/SQLPro/issues/693)

+ Fixed a crash that could occur when modifying MSSQL tables.