title: Room - Is it possible to use OFFSET and FETCH NEXT in a query?
body: <p>I'm trying to implement a pagination build in <strong>Room</strong> database android, and I need to have the clause <code>OFFSET</code> and <code>FETCH NEXT</code> which is not alowing me to use, what's the way to implement a query using these clauses. Did some research but no results gained. The SQL query I'm trying to implement on ROOM dao looks like this:</p>
  <pre><code>SELECT * FROM Persons ORDER BY id OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;
  </code></pre>