Changelog

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

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

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