Working with relational databases might be difficult for those not acquainted with them. However, I think the SQL language as an interface primarily for relati

Working with relational databases might be difficult for those not acquainted with them. However, I think the SQL language as an interface primarily for relation databases is a great language. I think, invariably when you use ORM, you end up having query-specific object structures. For example [1]. You also might be passed objects with deferred fields [2]. This will be completely opaque to someone consuming the resulting object. You'll eventually run into this problem [3]. Solving the lazy load problem requires an understanding of how SQL works in the first place. And if you look at the solution in that example, it's an ORM-wrapped series of joins. From 3: > For good measure, we add a raiseload to throw an exception if we try to load anything that we didn’t load here. Who wants to live in this world? 1: https://stackoverflow.com/a/45905714/5573538 https://stackoverflow.com/a/45905714/5573538 2: https://docs.sqlalchemy.org/en/13/orm/loading_columns.html#column-deferral-api https://docs.sqlalchemy.org/en/13/orm/loading_columns.html#c... 3: https://engineering.shopspring.com/speed-up-with-eager-loading-in-sqlalchemy-87a176cfd7ad?gi=2e66321199fc https://engineering.shopspring.com/speed-up-with-eager-loadi...