We prefer writing our own SELECTs so we have more predictable performance, also it makes debugging production issues easier. A poor ORM-generated query might b

We prefer writing our own SELECTs so we have more predictable performance, also it makes debugging production issues easier. A poor ORM-generated query might be fast enough during testing but crashes and burns when it hits client's database. Not us, but a perfect example was the recent story discussed here[1] on optimizing an ORM-generated query to get 1200x speedup. [1]: https://news.ycombinator.com/item?id=40069583 https://news.ycombinator.com/item?id=40069583