Row_Number 和按函数分区的 Spring 引导 Hibernate Criteria 逻辑 如何将 row_number （或具有相同行为的任何内容）与 Hibernate Criteria API 一起使用？

下面是 SQL 查询，如何在 Spring Boot Hibernate Criteria 构建器逻辑中构建相同的查询。

SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY LEAST(from_user, to_user), GREATEST(from_user, to_user) ORDER BY id DESC) AS row_num FROM message_status
    WHERE 
        ((from_user IN ('+91XXXX','e7a526cd-8526-435e-89bc-a46400e4c68c','+91XXXX') AND to_user='+91XXXX') 
        OR (to_user IN ('(+91XXXX','e7a526cd-8526-435e-89bc-a46400e4c68c','+91XXXX') AND from_user='+91XXXX')) and message_type not in('video', 'text')
) AS ranked_messages
WHERE row_num = 1;

是否可以在标准生成器中构建，以将条件添加为更动态。请分享任何人的答案！