infinite recursion detected in policy for relation (42P17)

What the Postgres 42P17 RLS recursion error means in Supabase, and the safe fix with a private SECURITY DEFINER helper, without turning RLS off.