Support Table Function in PostgreSQL

[Eric-zch]

Hi there,
I really love SQLLineage—it’s an excellent tool!
We have many PostgreSQL functions, including some table functions such as:

CREATE OR REPLACE FUNCTION get_active_users()
RETURNS TABLE(user_id INT, username TEXT, last_login TIMESTAMP) AS $$
BEGIN
    RETURN QUERY
    SELECT user_id, username, last_login
    FROM users
    WHERE is_active = TRUE
    ORDER BY last_login DESC;
END;
$$ LANGUAGE plpgsql;

could you add a feature to extract valid SQL statements from a function and make the function name as Target Functions rather than Target Tables?

[reata]

since this is dialect specific feature, it will be planned with lower priority. This is similar to Stored Procedure Support (#643)