IntelliJ IDEA not recognizing SQL dialect

Question

We use IntelliJ IDEA actively and we have our wrappers for work with DB (PostgreSQL). The thing is that when we use placeholders, SQL is stopped being highlighted.

"select * from " + schema + ".users where id = " + id + ";";

This code is not recognised as SQL, so highlighting doesn't work.

Answer 1

I agree with Jesper, you should try using preparedStatements, not only would your Statements get more secure, also the problem which you are currently having should be solved by it.