My biggest issue with it is how everytime I open it, it asks me to install a new version. Like, I am glad they're working on the software, but I'm getting fatigued from the inevitable popup

Mostly great, but I had an intermittent key remapping bug on the Mac not fixed for years. The default home/end document on Mac is not useful. Annoying enough to consider options.

I'd like to know too, because I think it's really great

For me, the biggest problem is its startup time (it takes at least 30-60s on my work laptop). It also randomly crashes for me when viewing any postgis related result sets.

If you like using psql, you might want to try out https://pxlapp.com/home

It can be pretty awkward to work with, although I've not found anything comparable, free, and cross-platform.

Sometimes the FK links in cells break. Other times views don't get invalidated when pressing refresh until a reboot. There are different refresh buttons all over the place for different contexts. Lots of minor quibbles despite almost weekly updates. It does have a gamut of features though - and it's free and cross-platform though, so it's one of those love-hate relationships for me.