vscode-postgres
vscode-postgres copied to clipboard
Support for running parameterized queries
I do not know how feasible this is, but if we were able to run queries with supplied set of parameters (whether or not named ones are supported) directly through this extension that would be a huge QoL improvement!
We frequently have parameterized queries stored in files adjacent to the code that uses them, and when we want to use a query manually we either have to copy it and run via a different source, run through the actual application, or alter the code in-place and remember to not to commit the invalid changes! If this plugin added a small area to, idk, the existing sidebar for connections? or anywhere else that would make sense, it would help keep us focused and inside a single application, without risking the persistence of unnecessary changes.
My personal ideal version of this would be a space where I could specify the parameters to use to persist between runs, so I don't have to re-enter the information between invocations as some input can be large or annoying to manually assemble. There's a lot more that could be done past this point, but anything else would just be icing!