An ORM is pretty darn useful for CRUD

Use a query tool like QueryDSL or Jooq for querying.

It's not surprising that you fail if you don't use the right tool for the job