PG function to autocomplete fields

autocomplete.sql

CREATE OR REPLACE FUNCTION dynamic_autocomplete(
    table_name TEXT,
    field_name TEXT,
    search_input TEXT
) RETURNS TABLE(count INT, value TEXT) 
LANGUAGE plpgsql AS 
$$
DECLARE
    query TEXT;
BEGIN
    -- Construct the dynamic SQL query
    query := format(
        'SELECT COUNT(*)::INT, MIN(%I)::TEXT AS value
         FROM %I 
         WHERE LOWER(%I) LIKE LOWER(''%%%s%%'') 
         GROUP BY LOWER(%I) 
         ORDER BY COUNT(*) DESC;',
        field_name, table_name, field_name, search_input, field_name
    );

    -- Execute the query and return results
    RETURN QUERY EXECUTE query;
END;
$$;