Not everyone uses C# and SQL to write their webapps. Or for that matter, even OOP.
Also any web app that is not using some form of OOP must be a very small or very confusion application (confusing to modify not use).
I do think o/r mappers are the way to go, although having better tools does not mean that you should start handwaving when it comes to db internals.