I don't see the problem here. You have specified the count and offset in {{limit(1,10)}}, so why not use {{$table->fetchAll($select)}} then? In my opinion, the key use case here is do we have to assemble the select object or could we quick fetch a row like this ...

$row = $table->fetchRow(array('colour = ?' => 'orange'), null, 10);

Of course to get this work, we have to add an $offset parameter into the {{fetchRow}} method ...