Maybe I'm lucky but this is infrequent for me. There are better tools for most queries:

https://ebean.io/docs/query/background/typesafe

https://www.jooq.org/

http://www.querydsl.com/

https://scala-slick.org/

I find these tools only work well for simple queries. For anything complicated, you spend N units of time figuring out how to make the query, then 4N units of time figuring out how to represent it in the metalanguage (often hacking around it with custom functions and operators).

They are especially bad with exotic operators like postgres' JSONB columns. I ended up ripping jooq out of an app over this.

There's an argument that they bring type safety to SQL, but Intellij actually validates your string literal SQL against the schema, so the benefit is marginal.

If you're using JPA, add the Criteria API to the list.

At a previous job we started using Groovey files to store queries because of this.