microsoft / microsoft/vscode-mssql

[Feature Request]: Export SQL query on result export to sql

Open
#22,306 0 comments 0 reactions 0 assignees View on GitHub
Area - Query Result Enhancement User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Feature Description

To mimic SSMS I would like to also have the ability to export the sql query to excel when results are exported fromt he result pane.

### Problem and Motivation

this will allow the ability to have the query that was run for the result set in case something changes in the query that is saved.

### Related Area

- [ ] Connection dialog (SQL Server | Azure browse/Fabric browse)
- [ ] Query editor
- [x] Query results panel
- [ ] Object Explorer
- [ ] GitHub Copilot integration
- [ ] Preview/Edit data
- [ ] Table Designer
- [ ] Schema Designer
- [ ] Schema Compare
- [ ] Local SQL Server Container provisioning
- [ ] SQL database in Fabric provisioning
- [ ] DACPAC/BACPAC export/import
- [ ] SQL Database projects
- [ ] Query Plan Visualizer
- [ ] Other (please describe below)

### If you selected "Other", please describe the area

_No response_

### Confirmation

- [x] I have searched existing feature requests and couldn't find a match
- [ ] I want to help implement this feature

Contributor guide

No contributing guide indexed for this repository

Research direction

The issue points to the query results panel and its result export-to-Excel flow; start by tracing how that export is initiated and how the executed query is available. Done means the exported Excel output also contains the SQL query that produced the result set, while the existing result export still works.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql, typescript
Domain
databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.