select
    *
from
    sys_role
where
    del_flag = 0
LIMIT {{.rows}} OFFSET {{.offset}}