I've only had experience in one full-stack project with supabase RLS so experience is limited. However it seemed like a mess. Seems much more human-maintainable to have a classic spring/golang backend. For sure in some projects, esp mobile apps, it makes more sense, and fable-level models might also keep it from being full spaghetti.

Also Supabase at that time wasn't reliable and it's not really made for self-hosting. Felt almost as bad as Github stability these days.

Still, based on this limited experience, I've been avoiding RLS and supabase.

I thought supabase was mainly for self hosting? Like it was self-hostable firebase... Not too familiar with it though.