microsoft / microsoft/vscode-mssql

[Feature Request]: DBeaver "Record View" equivalent (transpose of columns and rows)

Open
#20,767 0 comments 2 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

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

### Problem statement:
It's always a struggle to navigate through a query result with a large amount of columns in the result set.
You need to either select a subset of columns or horizontally scroll through the results.

### Feature description:
**Record view** equivalent like in DBeaver (transpose of a couple of records, showing column names as rows and values as columns)

The table view is a standard table (Excel-like) in which columns are vertical and rows are horizontal. This view is the default one.

I'd like the option for the rows and columns to switch positions. So to transpose the result set.
The columns will appear as rows, and the rows will be hidden in one Value column which will show only one row of data. The column headers will shift from the top of the table to its left side. See additional context for more info.

### Alternatives:
Copy a record with headers to excel and transpose results

### Additional context:

https://dbeaver.com/docs/dbeaver/Data-View-and-Format/

Image

### Problem and Motivation

It's always a struggle to navigate through a query result with a large amount of columns in the result set.
You need to either select a subset of columns or horizontally scroll through the results.

With this feature, I could more easily explore the columns that are available in the resultset.

### 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

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the query results panel and its existing table view, then trace how result-set rows and column headers are rendered. Done means providing an option to transpose the view so columns become rows and the selected records appear as value columns, with the behavior verified in the results panel.

Written by the indexing model from the issue text.

Assessment

Tech stack
typescript
Domain
frontend
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.