title: Spring Data - Why it's not possible to have paging with native query
body: <p>Let's say we have an entity called <code>MyEntity</code>. It is possible to query pageable results using <code>@Query</code> and with named queries, e.g.</p>
  
  <pre><code> @Query(value = "select e from MyEntity e where e.enabled = true")
   Page&lt;MyEntity&gt; findAllEnabled(Pageable pageable);
  </code></pre>
  
  <p>However, it is not possible to achieve the same with native query, so this</p>
  
  <pre><code> @Query(value = "select * from my_entity where enabled = true", nativeQuery = true)
   Page&lt;MyEntity&gt; findAllEnabled(Pageable pageable);
  </code></pre>
  
  <p>won't work. </p>
  
  <p>What are the reasons behind this? Is it possible to make Pageable working with native queries?</p>