Lately, it was usually the abysmal state of aggregate functions that bit me. That and wanting to use "with" to make readable sql.

I really should just change my main complaint to be that most options should have an easy to setup and tear down local equivalent for testing.

I feel that. Postgres has dump/restore at least, though that's less portable than a unit testing fake. And the thing I use at work lacks a dump/restore feature somehow :/