2 ms·
ORM are indeed, in my opinion, not very helpful, except in relatively narrow cases when operation only on single records matches the task well. OTOH what most
by nine_k 9y ago
ORM are indeed, in my opinion, not very helpful, except in relatively narrow cases when operation only on single records matches the task well.
OTOH what most ORMs offer behind the scenes is a DSL for SQL, which may be very useful. In better cases, that DSL can be accessed separately from the object-mapping proper.
For instance, I greatly appreciate SQLAlchemy as a way to write composable, readable SQL that operates on Python tuples from the host language side. I did not use the object-mapping part of it for years, and don't miss it.