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

createfunctiontest_auto_suggesstions_in_where_comparison(user_id uuid) returnsusers_hidden.users  language sqlas$$select*fromusers_hidden.users uwhereu.id= user_id;$$;

Here I have a working sql function. I would like to find a user with a givenuser_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 ?