Java developers mix object-oriented thinking with imperative thinking, depending on their levels of:
But when Java developers write SQL, everything changes. SQL is a declarative language that has nothing to do with either object-oriented or imperative thinking. It is very easy to express a query in SQL. It is not so easy to express it optimally or correctly. Not only do developers need to re-think their programming paradigm, they also need to think in terms of set theory.
In this post, I have listed some common mistakes that a Java developer makes when writing SQL