This would help with usecases where the SQL API is currently used, and make some queries more compact (e.g. missions would not need to transfer the UISortOrder attribute over the wire to be sorted clientside).
Not sure if this is possible due to how deduplication is implemented (sorting by rowid). Filing this for future investigation.