> People think writing DTOs is challenging I don't think this is true. Writing these objects isn't difficult, it's tedious and repetitive. That's why people ke

> People think writing DTOs is challenging I don't think this is true. Writing these objects isn't difficult, it's tedious and repetitive. That's why people keep trying to automate it! The problem is that you can't quite automate it smoothly, because SQL doesn't work like objects. You avoid this interface issue by taking the hit for the tedious-and-repetitive stuff directly (and I agree that's often the right choice) - but that doesn't dissolve the problem.