SQL functions: Auto suggestions for sql function input parameters as query operators/comparisions #433
Donnerstagnacht
started this conversation in
Ideas
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Feature
I would love it if the PLS language server could suggest input parameters as operators in sql functions. The main usage would be where clauses.
Right now, the PLS detects the usage of incorrect named input parameters. That's why I believe it should be possible to suggest comparison operators in where clauses.
Example
Here I have a working sql function. I would like to find a user with a given
user_id
handed in as input. I think it would be nice if the PLS could suggest the input after the=
as<space><input_parameter_name>
and if possible, indicate, the type in the dropdown menu, too (similar DX as in select).Current behavior:
Prefered behaviour as for select:
Alternatives
Typing it yourself. Possible but worse DX experience.
Relevance
Low. More a quality-of-life improvement but probably not that hard to implement. What do you think @juleswritescode ?
Beta Was this translation helpful? Give feedback.
All reactions