Ultimately we will see more and more of this from the likes of LINQ and other ORM tools.

Admittedly these aren't particularly complex SQL most of the time, and we can mitigate some of this by enforcing data access throuhg stored procedures, but they're still generating SQL.