title: Is it possible to use SQL functions in Sort.Order in Spring Data JPA
body: <p>We have a query where we need to run a MySQL Function to get correct Order By results. We are using Spring Data JPA and the Where clause is made up of a Specification. The pagination and sorting is done by a Pageable instance. So I need to be able to pass the MySQL function convert() to the Sort.Order object in order to correctly sort our results. Since we use pagination, we need to be able to put that into the Sort.Order object. Is it possible? </p>
  
  <p>I tried countless Google Searches, and all I would get is the high level documentation of Spring Data, or the result set would all just be about MySQL.</p>