Has anyone used Row Level Security in Postgres? I am exploring this for future uses but I can't figure out how I can make a query using a created role. From the docs I understand that you need to assume the role before making the query but I can't really find any more practical examples (also checked the Supabase repo but haven't managed to find the place yet where they do queries using this feature)

I followed this for supabase. youtube.com/watch?v=Ow_Uzedfohk