I agree that a new annotation definitely seems the nicer (user perspective) approach. I think @SQLOrderBy is a bit more descriptive of intent by name which is always nice.

Of course, given that our @jakarta.persistence.OrderBy handling also handles SQL fragments (assuming non-strict compliance) maybe its enough to just deprecate org.hibernate.annotations.OrderBy.

For @Where, not sure