A micro ORM is just an ORM, written well and modularly. It isn't a middle ground - it's choosing to use a well written library.
A lot of people conflate ORM's leaking because of poor designed library with ORM being a bad abstraction in general.
A lot of people conflate ORM's leaking because of poor designed library with ORM being a bad abstraction in general.
There is no real abstraction. You write standard SQL and it maps your recordset to an object. You know exactly what code is running.
There are extensions that will take a POCO object and create an insert statement and I believe updates, but where ORMs usually get obtuse and do magic are Selects. It’s hard to generate a suboptimal Insert or Update.
There are times I dislike things about it, and it can be quite heavy, but it’s very easy to mix and match ActiveRecord ORM code and raw SQL even within a single model class.