I'd like to be able to give hints about how to join two tables. For example, column A in table 1 is the key for column B in table 2. It's not always possible to make that a real reference column so it would be nice if SQL Prompt knew that it should present it as an option when doing a JOIN clause.

The only edge Apex has over SQL Prompt formatting, at least for my use, is being able to organize long equations. If I am using a large number of columns for an equation, I'd like to place each new column on a new line.

I would really like the option to select the occurrence of a synonym in DML statement and have SQL Prompt replace it with the synonym's target object.

Themes, Dark mode mainly. Ability to add company logo when you log in via browser, like we can in reports.

Very often I need to create a temp table, table variable, or UDTT that is a duplicate or subset of an existing table. I'd like the @table definition to include primary key and unique constraints and any check constraints and default constraints that are in the actual table. No foreign key constraints obviously. SSMS object scripting botches this up by creating a bunch of alter statements instead of including constraints inside the CREATE statement.

If any stored procedures in the database are encrypted then "Find Invalid Objects" will get a null reference and prompt to restart SSMS.

Enabled Intellisense conflicts with SQL Prompt and needs to be disabled. This also disables Code Folding feature (Outline Statements) of SSMS, which is very useful for large coding projects.
It would be helpful if SQL Prompt were to offer the similar feature.

When hovering over an object like a Proc or a View, and you click the link in the pop-up to view the contents of that object. It would be nice if there was a simple search function. Many times when I'm viewing the contents of an object, it's just because I want to see where it's making a particular reference, so I have to copy, open a new tab and then search.

Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".

Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".

It helps avoiding join on the same column (especially at inner join).
Example:
UPDATE A SET Column1 = B.Column2 FROM TableA AS A INNER JOIN Table B ON A.Column3 = A.Column3.
It happens usually by accident. The statement should be:
UPDATE A SET Column1 = B.Column2 FROM TableA AS A INNER JOIN Table B ON A.Column3 = B.Column3.

There are times when want to be able to reference a specific file name in, for example, bug reports. This option is to allow the selected filename (or filename with path) to be copied so that is can be pasted into other documentation.

Please introduce Schema-Folders in SQL-Server Object Explorer
as shown in
https://github.com/nicholas-ross/SSMS-Schema-Folders

Or make SQL-Prompt working together with
https://github.com/nicholas-ross/SSMS-Schema-Folders.

The Features "Show in Object Eplorer" and "Skript Object as ALTER"
don't work together with Nicolas Ross' Schema Folders

Please introduce Schema-Folders in SQL-Server Object Explorer
as shown in
https://github.com/nicholas-ross/SSMS-Schema-Folders

Or make SQL-Prompt working together with
https://github.com/nicholas-ross/SSMS-Schema-Folders.

The Features "Show in Object Eplorer" and "Skript Object as ALTER"
don't work together with Nicolas Ross' Schema Folders

Sometimes SQL Prompt generates an alias that matches an existing snippet key. My suggestion would be to ignore snippets when it's an auto generated alias.
example:
select * from DataEnvironment de (where de is the automatic alias) becomes
select * from DataEnvironment DELETE

It's rather annoying :)

As we are using a dedicated group of virtual machines for using our high privilege accounts, we don't know at login time on which machine we will have a session. Currently the settings of SQL Prompt are stored under “…\AppData\Local\...”. After each logoff we loose these settings. According to the Microsoft standards, the settings should be stored under “…\Appdata\Roaming\...”. Could this be changed in a future version?

Changing

SELECT TOP 10...

to

SELECT TOP (10)... should be a formatting option.

When putting a COUNT in a select field, the default option in intellisense is sysxmitbody.count. I understand if I have a field that contains the aggregate name in my table that you suggest it first, but I never want sysxmitbody.count - and if I do, I'd expect to go looking for it.

I feel like I've hit this problem with other aggregates as well, but can't find another example at the moment.

Not sure the best fix, maybe list all system tables after user tables and functions?

w.sysLocationXY.STX, should not generate an code analysis error.