what we need is to kill ORM stile framework (think hybernate) and move the world toward mapper style frameworks (think mybatis)

sure, inserts are slightly more inconvenient. but the clarity and performance control on reads unparalleled.