public function toDialectString(Dialect $dialect)
{
$string = '(' . $dialect->toFieldString($this->left) . ' ' . $this->logic . ' ';
$right = $this->right;
if ($right instanceof DialectString) {
$string .= '(' . $right->toDialectString($dialect) . ')';
} elseif (is_array($right)) {
$string .= SQLArray::create($right)->toDialectString($dialect);
} else {
throw new WrongArgumentException('sql select or array accepted by ' . $this->logic);
}
$string .= ')';
return $string;
}
public function toDialectString(Dialect $dialect)
{
return '(' . $dialect->toFieldString($this->field) . ' BETWEEN ' . $dialect->toValueString($this->left) . ' AND ' . $dialect->toValueString($this->right) . ')';
}
public function toDialectString(Dialect $dialect)
{
$sql = $dialect->toFieldString($this->left) . ' ' . $dialect->logicToString($this->logic) . ' ' . $dialect->toValueString($this->right);
return $this->brackets ? "({$sql})" : $sql;
}
public function toDialectString(Dialect $dialect)
{
return '(' . $dialect->toFieldString(SQLFunction::create('lower', $this->left)) . ' = ' . $dialect->toValueString(is_string($this->right) ? mb_strtolower($this->right) : SQLFunction::create('lower', $this->right)) . ')';
}
