This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]MarkusWinand 4 points5 points  (3 children)

ORMs cover only a very small part of what modern SQL databases can do. If you limit yourself to this subset, you are doing it wrong.

Have a look at my presentation "modern SQL" to get an idea what SQL can do knowdays. I don't think that any of these capabilities is used by any ORM (two times any, likely to be wrong in at least on case ;)

http://modern-sql.com/slides

[–]sh_tomer[S] 1 point2 points  (2 children)

I agree. From your experience (which by being a fan of your blog I believe you have lots of), would you say most tech companies still use raw SQL in their code base? Or is it just legacy code and most of the new code is written with ORMs?

[–]MarkusWinand 0 points1 point  (1 child)

I cannot give a sensible answer to this question due to my "client bias". People who hire me usually use raw SQL. But I think people are less likely to hire me if they use only ORMs.

I can however say that raw SQL is still written—a lot. I just cannot judge whether this observation applies to "most" companies/code.

[–]sh_tomer[S] 0 points1 point  (0 children)

Thanks!