In DBeaver, when viewing a table (especially with very few rows, e.g., <10 rows), it can be helpful to press the "Tab" button to view the columns as rows (transpose the table).
It would be so awesome if this extension supported it with a shortcut or status bar toggle or similar (honestly, what ever is easier).
There is a generic DuckDB expression to do this transpose (which involves somewhat of a hack on the PIVOT operation). Not sure if a query-level or presentation-level operation is best.
Example from DBeaver:
After pressing "Tab" to transpose:
In DBeaver, when viewing a table (especially with very few rows, e.g., <10 rows), it can be helpful to press the "Tab" button to view the columns as rows (transpose the table).
It would be so awesome if this extension supported it with a shortcut or status bar toggle or similar (honestly, what ever is easier).
There is a generic DuckDB expression to do this transpose (which involves somewhat of a hack on the PIVOT operation). Not sure if a query-level or presentation-level operation is best.
Example from DBeaver:
After pressing "Tab" to transpose: