Description
Currently, in Azure Data Studio (ADS), the command workbench.action.query.shortcut1 allows users to execute predefined SQL queries like sp_help tableName without opening a new editor or modifying the active query editor. However, in VS Code, the mssql extension does not provide a similar command for running queries in the background without affecting the active editor.
I would like the mssql extension in VS Code to support a command similar to workbench.action.query.shortcut1 from ADS. This new command should:
Run a SQL query in the background (e.g., sp_help ${selectedText}) without creating or modifying an editor.
Show the query results in the results panel, similar to mssql.runQuery.
Work with a keybinding, so users can quickly retrieve table definitions (or other metadata) without disrupting their workflow.
This feature would help users transitioning from ADS to VS Code, ensuring a smoother workflow for database developers and administrators.