Anyway to do Ranked Text Searches with the CriteriaBuilder?

[erkieh]

Currently I have a search built with the CriteriaBuilder and would like to add support for doing a text Search with ranked Results.
https://www.postgresql.org/docs/current/textsearch-controls.html#TEXTSEARCH-RANKING

The resulting Select should ideally be

SELECT title, ts_rank_cd(textsearch, query) AS rank
FROM apod, to_tsquery('neutrino|(dark & matter)') query
WHERE query @@ textsearch
ORDER BY rank DESC
LIMIT 10;

Is there any way to do this through the criteria builder? With the amount of columns, joins and conditions I have, doing this with a fully raw String query is hard.

[dstepanov]

The functions are supported but the operator @@ is not

[dstepanov]

Maybe we can support a custom operator expression

[erkieh]

I couldn't find a proper way to inject dynamic SQL expressions into the FROM clause.
I ended up creating an injection point through a Custom Naming Strategy, context usage and a "Virtual" MappedEntity.