I mainly use Postico but I’ve noticed coworkers using DBeaver. I like how the tabs are named whereas in Postico I have to leave comments at the top of the query for later. I had to use DBeaver to access a non-Postgres database. I may end up trying it out as my primary tool for a bit.
I absolutely love Postico. For postgres, there really is no comparison for a Mac native db client. DBeaver seems so clunky in comparison, but I use that for everything non postgres.
DBeaver is somewhat clunky, yes, but for me that's a minor downside since it acts as a Swiss army knife, regardless of what DB I'm trying to access. That saves cognitive load from having to learn multiple tools. Pretty much anything with a JDBC driver is fair game. It being cross platform is a big boon as well since I use all 3 major OS fairly regularly - Mac at work, Windows and Linux at home.