Connections are pretty expensive in PG how can you do pooling if every user connects directly?
[1] https://www.pgbouncer.org/ [2] https://github.com/supabase/supavisor
That said, there are quite a lot of CRUD apps in the world that don't need to support lots of simultaneous users, or where you can just add read replicas quite cheaply. Think internal apps, dashboards, etc.