This post reminds me of what happened some weeks ago at my job. We use Clojure and yesql (a library where you write sql queries directly in .sql files and the

This post reminds me of what happened some weeks ago at my job. We use Clojure and yesql (a library where you write sql queries directly in .sql files and the library generates functions for you). The devops noticed one of our queries was slow and taking too much DB resources. He sent us the query which we promptly found and then asked us if we could change it to a more performant version he just wrote. We took his query, just replaced in our sql file and deployed. 10 minutes later he came back saying things look much better and the query update really helped. I wonder how much time it would take if we were using JPA/Hibernate as we used to, many years ago.