Anyway to on-demand revalidate a dynamic page that fetches data from supabase database? revalidateTag works as intended for fetch api but using the supabase api so not useable.

revalidatePath does not on-demand revalidate the specific path. It revalidates all pages in that dynamic route only when the specific page is next visited. Shows stale content the first time the page is visited after revalidating