how to add caching to supabase functions tags

  const supabase = SupabaseServerComponent();
  const { data, error } = await supabase.from("User").select("UserRole(Role(permissions))").eq("uid", userData.user.id).single();

i want to cache that

Note : export revalidate doesnt work

export revalidate = 37000

i doesnt cache it when i try build version of project
i want to have access to these stuff in fetch method

    next: {
      revalidate: 7200,
      tags: [`get-user-${uid}`],
    },

so is there a wrapper or something to wrapper non fetch method or idk what they are called to cache it
Note one more thing that may help supabase does use postgrest which run a fetch method i can see it in console of my api the fetch request but idk how to access or doo something with