Ditto for entity framework in the .NET world, in my experience.

Of course everybody has a horror story about some abomination of a query that they had to fix some time but the productivity gains are worth it.