Denis Stepanov

For now, you can inject `JpaRepositoryOperations` and use `getEntityManagerFactory`, `getEntityManagerFactory` to build queries. I will try to fix it to be used in the repositories for the next release.

Yes, looking to fix it in 4.3.0 https://github.com/micronaut-projects/micronaut-core/discussions/10137

If you use Hibernate it should use the criteria builder from it.

I will take a look to support custom functions

I'm working on a query builder rewrite that should enable the quick addition of more criteria features. Please create an additional issue of what operations are needed to assess what...

Changes look fine, but IMHO different parameters count might indicate an error. We might want to fail at the compilation time.

@graemerocher WDYT?

Well, the example added is incorrect and will lead to the count being different than the pagination.

To implement it, first, we need to support query parameters resolved outside of the method scope. My idea is to support syntax: `select * from users where my_column = #outside_param...

`@TenantId` can be implemented as an annotation annotated with something like `@RuntimeQueryParameter(resolver = TenantResolver.class)`