About LIMIT and OFFSET as query tokens

Hi,

I would like to know why the query tokens OFFSET AND LIMIT are not available and if they will be in a near future. Is there any equivalent way to get, from the database, the object at given position i as well as a given number of objects that follow such object?

Thanks you in advance

MiguelGT

Thanks you in advance

In JPA you specify a result range using setFirstResult and setMaxResults.

Thanks you!!!