I need to change one property of entity to be calculated as SQL aggregate function, where the query must join certain tables on the value which is known at runtime.

The example query is following

select count(1) cnt
from foo foo
left join bar bar on (bar.foo_id = foo.id)
where
   foo.type= 'X' and bar.username= 'Y' and
   foo.creation_date >= sysdate -  ( Z / (24*60) );

Where X is retrieved from an association of the particular entity, Y is the authenticated user in the Spring SecurityContext, and Z is property defined in the maven profile.

Is it possible to use Hibernate's @Formula annotation with runtime built query?