use SQL::Abstract::Limit;

my $syntax = 'LimitOffset';

# others include: Top RowNum LimitXY Fetch RowsTo

my $sql = SQL::Abstract::Limit->new( limit => $syntax );

my($stmt, @bind) = $sql->select($table, \@fields, \%where, \@order, $limit, $offset);