You mean MSSQL? Because Postgres has an excellent procedural language built-in, as well as support for lots of others....
Perhaps it does. I've dealt with horrible procedural code in t-sql and pl/SQL and maybe Postgres is better but I'm in no hurry to find out.
I'm a Scala developer by profession and have dealt with horrible Scala code. People can write horribly in any language.
The day every .NET shop on Earth admits this is the day I'll be a happy man. A SQL server is not for writing business code.