In some databases, this operation might not be supported or will require
the query to be transformed in order to limit the result set size.
### Examples
$query->limit(10) // generates LIMIT 10
$query->limit($query->newExpr()->add(['1 + 1'])); // LIMIT (1 + 1)