mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.43k stars 291 forks source link

Provide alternative data viewer setting and API to use for displaying SQL query results #1239

Open RandomFractals opened 8 months ago

RandomFractals commented 8 months ago

Would it be possible to provide alternative query results viewer interface and API in the upcoming SQL Tools releases?

While we find current results viewer sufficient, we think it would be beneficial for the whole SQL Tools and drivers ecosystem to have a new dataViewer setting and API for users to choose how SQL query results are displayed.

Currently there are limitations in integrating SQL Tools with VS Code Notebooks and there are a number of data table and other viewers in VS Code that might provide more elaborate data views when viewing results from querying various data sources your and community drivers support.

Some examples:

Data Preview

![Data Preview](https://github.com/RandomFractals/vscode-data-preview/blob/master/images/vscode-data-preview.png?raw=true "Data Preview")

Tabular Data Viewer

![Tabular Data View 中](https://github.com/RandomFractals/tabular-data-viewer/blob/main/docs/images/tabular-data-view.png?raw=true "Tabular Data View 中")

![Data Perspective View 中](https://github.com/RandomFractals/tabular-data-viewer/blob/main/docs/images/tabular-data-perspective-view.png?raw=true "Data Perspective View 中")

Data Table Renderers in VS Code Notebooks:

![Data Table 🈸 Renderers](https://github.com/RandomFractals/vscode-data-table/blob/main/docs/images/data-table-renderers.png?raw=true "Data Table 🈸 Renderers")

Geo Data Viewer:

![Geo Data Viewer Ultri Wide](https://github.com/RandomFractals/geo-data-viewer/blob/master/images/geo-data-viewer-ultri-wide.png?raw=true "Geo Data Viewer Ultri Wide")

New Data Wrangler from Microsoft:

image

Originally posted by @RandomFractals in https://github.com/mtxr/vscode-sqltools/issues/1238#issuecomment-1792616429