I use ORMs to create custom line of business apps, mostly CRUD-ish and it works fine. The ORMs I've worked with have a way to write your own queries if the need arises.