View results table in rotated/transposed/vertical layout (rows become columns)

[hi2u]

• It's often useful to view the table of results with the layout of the columns vs rows swapped around, i.e. layout is rotated 90 degrees.
  • ...in fact when working on queries I actually find this layout more useful like 90% of the time (I even wish that other clients that already have the feature could also include an option to make it the default).
• It would be especially handy in SQLTools, seeing it already opens the results in a left + right split by default (which makes a lot of sense for landscape monitors, also something that I wish other clients could do).

Example of it in some other SQL clients:

• datagrip: https://www.jetbrains.com/help/datagrip/tables-view-data.html#transposing_table
• dbeaver: Show all rows in Record with horizontal scrolling Mode like a spreadsheet dbeaver/dbeaver#7014
• vscode-database-client Possible to rotate results table 90 degrees? (swap rows/columns) cweijan/vscode-database-client#914

This is kinda similar to #634, or viewing results as JSON (table columns/fields go "downward" instead of "rightward")... however the difference is that what I'm asking for still lets you view results side-by-side to easily visually compare them against each other (and you can horizontally scroll to see the rest that are off-screen).

I've searched around the options, and existing github issues, but didn't see it mentioned. So I don't think the feature exists yet?

Layout switching

If being added, it would also be great if we could assign 2 different keyboard shortcuts to execute queries for each type of layout, rather than it always opening in normal first, and then having to change. This would also effectively meet my wish mentioned above re how other clients don't let you set a default preference. As we could just assign whichever layout we prefer to our main key-combo we use to run queries, then have another key assigned for the other layout.

i.e. I think it would make sense for the sqltools.executeCurrentQuery key ID to remain as-is (opens results in regular table layout)... and then add an additional one called something like sqltools.executeCurrentQueryRotated

But it does still make sense to be able to toggle the layout of existing results table too, ideally also with its own keyboard shortcut to toggle between the 2 layouts.