Undeprecate QueryUtils createCountQueryFor, or make DeclaredQuery public [DATAJPA-1670]

[spring-projects-issues]

Jean-Baptiste Nizet opened DATAJPA-1670 and commented

Sometimes, a static JPQL query isn't sufficient, but using the criteria API or QueryDSL is much harder than simply compose a JPQL query dynamically.

It would be nice however to be able to derive a count query automatically for such JPQL queries. It's currently possible using QueryUtils.createCountQueryFor(), but this metod is deprecated. And its replacement (DeclaredQuery.deriveCountQuery) is not usable because DeclaredQuery is not a public interface.

In general, it would be nice if there was an easy public API, usable from custom repository implementations, that provided the same support as the Query annotation to execute paged queries:

• ability to provide the JPQL
• ability to provide the Pageable
• ability to derive the count query, or pass a count projection, or pass a count query
• ability to pass a parameter binder (for example as a Consumer\, which would only have to call setParameter() on the query, which would be the actual query, or the count query)

It's not as easy as it could be to do that now, and relies on a deprecated method with no public replacement for the count query derivation

 

---

Affects: 2.2.4 (Moore SR4)

[spring-projects-issues]

Jens Schauder commented

In order to do this properly we would need to create a completely new abstraction which we right now are not able to support.

I'm therefore closing this issue.

This is based on our impression that the use case is very special and only few users would benefit from this. If you have a use case that has broad applicability this might change our mind