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

[RandomFractals]

trafficstars

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

Tabular Data Viewer

Data Table Renderers in VS Code Notebooks:

Geo Data Viewer:

New Data Wrangler from Microsoft:

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