function toDialectString(IDialect $dialect)
{
$querySlices = array();
$querySlices[] = 'SELECT';
if ($this->distinct) {
$querySlices[] = 'DISTINCT';
}
$querySlices[] = $this->get->toDialectString($dialect);
if (!$this->sources->isEmpty()) {
$querySlices[] = 'FROM';
$querySlices[] = $this->sources->toDialectString($dialect);
}
// WHERE
if ($this->condition) {
$querySlices[] = 'WHERE';
$querySlices[] = $this->condition->toDialectString($dialect);
}
// GROUP BY
if (!$this->groups->isEmpty()) {
$querySlices[] = 'GROUP BY';
$querySlices[] = $this->groups->toDialectString($dialect);
}
// HAVING
if ($this->having) {
$querySlices[] = 'HAVING';
$querySlices[] = $this->having->toDialectString($dialect);
}
if (!$this->order->isEmpty()) {
$querySlices[] = $this->order->toDialectString($dialect);
}
if ($this->limit) {
$querySlices[] = 'LIMIT';
$querySlices[] = $this->limit;
}
if ($this->offset) {
$querySlices[] = 'OFFSET';
$querySlices[] = $this->offset;
}
$queryString = join(' ', $querySlices);
return $queryString;
}
