Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
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.
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
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.
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/