I guess in the domains I work in, I have to do a lot of CRUD stuff where DAOs work well enough. Then there's the reporting/analytics style queries that I always prototype in plain SQL - these I find tedious to convert to some type safe builder, criteria api or ORM dialect