Supabase RLS with auth.uid() not working? Causes and fixes

You wrote a tidy Row Level Security policy, something like auth.uid() = user_id, and now one of two...