e.g.

declare @1 table (a int, b int)
declare @2 table (a INT, b int)

SELECT a, b FROM
@1 a
CROSS JOIN @2 b

Here there are 2 possibilities for columns a and b, however SQL prompt only suggests the second one. Both should be shown and the user given the chance to choose.

When using the Script as Insert, it generates the Create Table with the table name as #temptable. If you want to change that name, you have to then change it in the Create, Insert, and Drop locations.

Would be nice if this defaulted as a snippet placeholder so that editing one would edit the other two as well.

Like the snippet placeholder $SERVER$ inserts the name of the connected SQL server and $DBNAME$ inserts the name of the connected database I would like a placeholder $OBJECTNAME$ that will insert the name of the object already selected in Object Explorer.

Currently the files write out to a temporary file location. Add pane in settings window to change the location (e.g. a folder in my one drive that is not read only)

Allow an option when saving / running a file that you format the sql to the format selected. Will make sure the whole team follow the standards and does not forget to run the formatter.

I am installing SQL Prompt into SSMS only. every time I run an update I need to change the install location to SSMS only (from SSMS and VS). Please make the installer remember my selection and default to it

Add support for intellisense in SQL MultiScript using SQLPrompt

SSMS homes files other than .SQL scripts. Sometimes an you closed an execution plan or a deadlock graph you wish you had saved. Tab history should cache non-SQL file types along with standard SQL scripts so you can get these back when you accidentally closed SSMS or after a crash.

Add "Clean install" checkbox with appropriate warnings and option to back up styles and tab history where the user can specify and/or change the suggested backup location by default. Offer an easy option (inside menu?) to restore from the backup once installed. Take a look at Visual Studio editor options can be exported (backed up to a file) and subsequently restored later.

Also, take a look at nVidia, AMD Radeon (formerly ATI) and perhaps Intel network card driver installers as an example for "clean install".

When adding brackets via CTRL+B,CTRL+B, Windows-based principals (users, groups, etc.) are not correctly bracketed. The brackets are placed around the domain or computer name portion of the principal, instead of the combination of the domain/computer and user/group name.

For example, if this statement is entered

ALTER SERVER ROLE sysadmin ADD MEMBER MYDOMAIN\USER

using CTRL+B,CTRL+B will yield this:

ALTER SERVER ROLE [sysadmin] ADD MEMBER [MYDOMAIN]\USER

instead of the correct syntax:

ALTER SERVER ROLE [sysadmin] ADD MEMBER [MYDOMAIN\USER]

Would also be helpful if principals from NT AUTHORITY and NT SERVICE could be correctly handled.

Include SQL statements to grant existing permissions with the object definition DDL statements.
i.e. GRANT SELECT ON dbo.table TO sql_user

Have buttons to add/remove square brackets rather than tucked away under Options, so they can be toggled on or off easily.

And/or move the square brackets option out of Options and into the actual formatting style (like the option to remove additional whitespace) so it can be saved and shared as a template

As AI powered tools like codepilot, kite or tabnine are on the rise, It would be so great to add an AI assistant to SQL Prompt to support developers on their way to write t-sql code effortless.

I do not see Intellisense for AZURE sql. Please, please, please. There's code formatting, but no actual intellisense like ssms.

SQL Prompt doesn't allow to exclude servers, only way we can filter out server if we add each database under SQL prompt settings (Suggestions>Connections).

We have busy production server and if we connect to production server, SQL prompt execute series of SQL queries against system database tables. Even though impact is minimal, It would be nice if there is a way filtering out servers rather than just the database objects.

Please add support for Synapse Serverless Databases for Intellisense!