Why does hibernate cut window functions like row_number in @Formula?

Question

Java

Hey!

Tell me, did anyone make a formula with row_number () in hibernate (java) in Entity? At me something window functions are not got at all. Hibernate turns them into something unreadable and crashes itself.

Maybe there are better ways?

I need to get the index of a post within the same user_id sorted by date. The problem is that there are places where my entity is requested in a single instance. And I need to know what it is in a row :(

Well, I don’t want to make a view at all. I have more than one such entity :(

An example of a formula:

@Formula(value = "(select row_number () over (order by created_at) from table where user_id=5)")