The default user that creates a table in postgres always has access to all rows inside the table. The default user is not restricted to the RLS policies.

Therefore we need to use a second role whenever we want to make a query with RLS enabled. Basically for every query we do, we'll wrap it in a transaction and then use 'SET LOCAL ROLE ..' to switch to our second role for the duration of the transaction.