title: Spring custom sorting in Sort.of
body: <p>Is there any way to use <code>Sort.of</code> with this kind of sorting?</p>
  <pre><code>    @Query(&quot;SELECT l FROM Livestream l WHERE l.status IN ('LIVE', 'FUTURE') ORDER BY CASE WHEN l.status = 'LIVE' THEN -1 ELSE 0 END ASC&quot;)
      fun findLiveAndFuture(pageable: Pageable): Page&lt;Livestream&gt;
  </code></pre>