[hibernate-issues] [JIRA] (HHH-16902) Query.setOrder() for native SQL queries

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZGEwZjBmODU3... ) / New Feature ( https://hibernate.atlassian.net/browse/HHH-16902?atlOrigin=eyJpIjoiZGEwZj... ) HHH-16902 ( https://hibernate.atlassian.net/browse/HHH-16902?atlOrigin=eyJpIjoiZGEwZj... ) Query.setOrder() for native SQL queries ( https://hibernate.atlassian.net/browse/HHH-16902?atlOrigin=eyJpIjoiZGEwZj... ) Issue Type: New Feature Assignee: Unassigned Components: query-sql Created: 05/Jul/2023 14:23 PM Priority: Major Reporter: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) It should be quite straightforward to implement support for setOrder() in NativeQuery. (We can just wrap the given query in an outer select with the appropriate order by.) This is important because we want people to be able to easily swap out HQL for SQL. ( https://hibernate.atlassian.net/browse/HHH-16902#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16902#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100230- sha1:e339e49 )