Do you agree with using ORM?

Question

Hi there coders ;-)
Do you agree with using ORM or not? why? please explain your respectful opinion regarding this so that many would benefit.
Thanks

Answer 1

Relational databases are better for “smaller” datasets, even though you can comfortably go up to many terabytes. NoSQL and bigdata are better for warehouse/DSS type systems with quicker access to multi-dimensional datasets, and with far less limitations on the size of dataset. 

The basic difference is that relational databases prefer “column-narrow” tables with many rows, and then rely on column indexes to point to rows, and on SQL to join those tables to retrieve data. NoSQL databases use “column-wide” tables that provide quick access to columnar clusters of data using storage technology that optimizes clusters of data as opposed to traditional storage that optimizes blocks/packets of data coming back via table rows.

More:
https://martinfowler.com/bliki/OrmHate.html

http://www.yegor256.com/2014/12/01/orm-offensive-anti-pattern.html