The native query execution in Jmix

Support
#1

Is there any way to execute sql native query in Jmix.
It was possible in CUBA:
https://doc.cuba-platform.com/manual-latest-ru/nativeQuery.html

But I found nothing similar in Jmix documentation.
Only simple jpql queries with dataManager:
https://docs.jmix.io/jmix/data-access/data-manager.html

Is it still possible to execute sql native query in Jmix? Are there any examples or docs about this?

#2

I found the answer here:

It says, that Jmix doesn’t support native query, but it’s possible to do it via javax.persistence.EntityManager

#3

Spring’s JdbcTemplate also works.

1 Like