I have a query that indexs on several columns and has complex logic. I can't write a complete query to describe the exact set of rows that I want. More specifically, I really need to calla Java method to find out if the object/row is really what I want. For example, something like, IsApproved() where the logic is not simple for determining success.

My question is, would it be wise to store isApproved in the database and map it so the query is simple, or is it better to return more results from Hibernate queries, even if I don't need them?