SQL Plugin "select data" action for tables
Small Quality of Life improvement, that adds "select data" to table right click actions
Lack of this feature caused me huge amount of frustration
And I hope that now, people not gonna have to go through this PIA to view table data
-
Open new tab
-
select "select" from "generate query" menu to paste query in this tab
-
press "run query" in separate menu
-
Either Close tab and have to repeat step 1. for every table I want to view OR constantly have one extra tab open that I still have to clear to view other table (since default action generates "select" query with all fields, instead of generic "select * from X" where I can easily change the table name)
A bit reworked schemawidget for this
Made that so "generateStatement" function return statement instead of creating it and automatically pasting it into active view. (For this functionality to be still available added "generateAndPasteStatement" function. And (purely for naming consistency) renamed functions that use it from "GenerateX" into "GenerateXIntoView")
Added "generic" function "execute statement" so it can be reused when/if "bind parameters" for "insert"/"delete" query is added. (and, of course, it's used by "executeSelect" function that I bound to new menu action)