Dynamic sorting on multiple fields and via a parametrised JPA native query [Spring, JPA, Kotlin]

[Geane Norm]

I have a requirement whereby my native query would need to have an ORDER BY on potentially multiple sorting fields and directions. I have a native query in my repository that looks something like this (it has been made much simpler than the current one):  

    @Query(value = "SELECT * from someTable ORDER_BY ?1, ?2", nativeQuery = true)
    fun someMethod(sortBy: String, direction: String): Collection<SomeObject>

My issue is that `?1` can ideally be matched to multiple fields in my `someTable` whose data types are different. For example, it can be an ID of type UUID as much an integer, etc. Is it possible to perform sorting on multiple fields (over 15 potential ones) and attached directions? I am getting the values of the sorting fields and corresponding directions from a method querying an external service and getting such values from the body of a `ResponseEntity<Any>`.

Thank you

[Dave Tolls]

With SQL you bind variables to values, not column names or chunks of SQL.
So that query won't work anyway.

[Geane Norm]

Dave Tolls wrote:With SQL you bind variables to values, not column names or chunks of SQL.
So that query won't work anyway.

Thanks, is this even possible? Is there any way to achieve that?