I've used Oracle PL/SQL and PL/pgSQL pretty extensively, as well as TSQL (MS equivalent). Mostly for HR, Finance and trading systems. Overall positive, but like

I've used Oracle PL/SQL and PL/pgSQL pretty extensively, as well as TSQL (MS equivalent). Mostly for HR, Finance and trading systems. Overall positive, but like many languages, it's easy to misuse and can quickly become unwieldy. DBMSs don't really have much support for arranging objects. In Oracle, you have packages, but overall it's up to you to maintain and document why certain objects exists.