I played around with that a little, but it seemed like once you start trying to auto-generate SQL from objects you are basically writing a simple ORM. So you either spend time writing queries, spend time building an ORM, spend time fixing an existing ORM, or some combination of those.
Sure, but it's about finding that sweet spot. I dislike large ORMs
The majority of queries are simple and trivial to auto generate. The more entities you add the more value you get from it.