Typename for the Function parameter with %TYPE syntax is not coming up in datums of parsed json

[priyanshi-yb]

Example

CREATE OR REPLACE FUNCTION get_employee_details(emp_id employees.id%TYPE) 
RETURNS employees.name%TYPE AS $$
DECLARE
    employee_name employees.name%TYPE; -- Matches the type of employees.name column
BEGIN
    SELECT name INTO employee_name FROM employees WHERE id = emp_id;
    RETURN employee_name;
END;
$$ LANGUAGE plpgsql;

parsed json for the above -

 {
        "PLpgSQL_function": {
            "datums": [
                {
                    "PLpgSQL_var": {
                        "refname": "emp_id",
                        "datatype": {
                            "PLpgSQL_type": {
                                "typname": "UNKNOWN"
                            }
                        }
                    }
                },
                {
                    "PLpgSQL_var": {
                        "refname": "found",
                        "datatype": {
                            "PLpgSQL_type": {
                                "typname": "UNKNOWN"
                            }
                        }
                    }
                },
                {
                    "PLpgSQL_var": {
                        "refname": "employee_name",
                        "lineno": 3,
                        "datatype": {
                            "PLpgSQL_type": {
                                "typname": "employees.name%TYPE"
                            }
                        }
                    }
                },
                {
                    "PLpgSQL_row": {
                        "refname": "(unnamed row)",
                        "lineno": 5,
                        "fields": [
                            {
                                "name": "employee_name",
                                "varno": 2
                            }
                        ]
                    }
                }
            ],
            "action": {
                ....
            }
        }
    },

for parameter emp_id employees.id%TYPE the typename is coming up as "PLpgSQL_type": { "typname": "UNKNOWN" }