I've used Oracle PL/SQL (and sometimes SQL Server TSQL) extensively for the last 20 years. It's way easier to write data manipulation in this specific type of l

I've used Oracle PL/SQL (and sometimes SQL Server TSQL) extensively for the last 20 years. It's way easier to write data manipulation in this specific type of language than to use Java/.net/C etc. Linq for sql has improved things within Microsoft ecosystem but then you have the big overhead of the ORM etc. I know the Postgres version is heavily based on the Oracle language which has been very successful and endures in big business: banks etc. It's a great language to get stuff done, but the ease of use can cause problems if you don't engineer your solution properly. For data it's great however my current site uses it for many other things such as heavy xml tranformations, web service calls etc and then the gaps in the language start to show through and you've be better off moving into something general purpose, but you can do almost anything with it if you want...