$q = $dbHandler->createSelectQuery();
$q->select( '*' )->from( 'table' )
->where( $q->expr->between( 'id', $q->bindValue( 1 ), $q->bindValue( 5 ) ) );
public function between($expression, $value1, $value2)
{
return "{$expression} BETWEEN {$value1} AND {$value2}";
}