SQL function: False error reports for function parameter references using explicit function name reference

[Donnerstagnacht]

Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

If a function takes in a named parameter and the parameter is used in the function body and referenced explicitly using the function name, the used function name is flagged as a false error claiming an incorrect FROM clause (probably because it expects a Select * from <function_name> statement).

To Reproduce

Create a function with a named parameter and use a explicit function parameter reference.

create or replace function users.select_with_function_ref (user_id uuid) returns table (
    first_name text
) language sql security invoker as $$
select
    first_name
FROM 
    users_hidden.users
where 
    id = select_with_function_ref.user_id;
$$;

Expected behavior

Named function parameters using an explicit function name as reference should be recognized as correct code.

System information

• OS: windows
• code editor: vs-code
• pls version: 0.5.0