I don't understand why everyone hates ORMs so much. It makes no sense. For any non-trivial project, you are all but guaranteed to want one. Probably sooner than you think. Why not just use one from the beginning that you know to be robust and well understood, instead of half reinventing the whole concept, ad-hoc, one query at a time?
@jenniferplusplus None of my day job stuff uses SQL databases - we have Cosmos, Azure File storage, http and message queues. Before that, AWS Dynamo and S3 with SNS/SQS.
Last job that used a SQL database as well, Dapper did all that we wanted, with minimal fuss. ORMS have never done that for me. We did not "reinvent" that heavyweight stuff.
@anthony_steele Dapper is an ORM, it's just light on features
@jenniferplusplus You can call Dapper an ORM if you want, I have heard it called a "Micro ORM".
It was near the right level of features and ceremony as far as I was concerned.