I have a use case where I am fetching results from hibernate search documents after indexing. However its not a simple matching query. I need to apply SQL aggregate functions while fetching data from document.
Since it is not supported currently I had to implement all such function in Java itself after fetching a list of entities.

I have attached a document which will illustrate this use case in more detail.