public String mapToSqlQuery(OffsetBasedPageRequest pageRequest, Sql table) {
        table.with("limit", pageRequest.getLimit());
        table.with("offset", pageRequest.getOffset());
        return orderClause(pageRequest) + " " + dialect.limitAndOffset();
    }
@Test
    void sqlOffsetBasedPageRequestMapperMapsOrder() {
        OffsetBasedPageRequest offsetBasedPageRequest = Paging.OffsetBasedPage.ascOnScheduledAt(10);

        String filter = offsetBasedPageRequestMapper.mapToSqlQuery(offsetBasedPageRequest, jobTable);

        verify(jobTable).with("offset", 0L);
        verify(jobTable).with("limit", 10);
        assertThat(filter).isEqualTo(" ORDER BY scheduledAt ASC LIMIT :limit OFFSET :offset");
    }