I hack SQL and PL/pgSQL every day, and have been doing so since 2002.
I work on a real-time bank payment system called Trustly, which is written entirely using PostgreSQL using pretty much all it capabilities.