Table introspection

[NicolasLM]

Hi, I am wondering if you have thought about introspecting tables so that their columns can be displayed in the tree. See https://www.jetbrains.com/help/pycharm/database-tool-window.html for an example.

Thank you for this helpful plugin!

[kristijanhusak]

Hi,

I think I already got a request for this somewhere. What's the value of having columns in the sidebar? What should happen when you select some of the column from sidebar?

[NicolasLM]

It is very helpful to understand the layout of the data when there is a large number of tables. For example when working on a feature that touches user_id I would just /user_id in the tables tree to find all related fields.

What should happen when you select some of the column from sidebar?

This is not the most useful thing but the behavior of IntelliJ IDEA when double clicking on a column name is to open a select * from table result and focus the column. It makes sense for tables with a large number of columns.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.