Set up connection

CREATE OR REPLACE FUNCTION public.execute_raw_sql(query text)
RETURNS jsonb
LANGUAGE plpgsql
SECURITY INVOKER
AS $$
DECLARE
    result jsonb;
BEGIN
    -- Execute the SQL query and store the result in a JSONB format
    EXECUTE format('SELECT json_agg(t) FROM (%s) AS t', query) INTO result;

    RETURN result;
EXCEPTION
    WHEN others THEN
        -- Handle errors gracefully by returning the error message in JSON
        RETURN jsonb_build_object('error', SQLERRM);
END;
$$;