FoolCode / SphinxQL-Query-Builder

        if ($this->type == 'select') {

            $query .= 'SELECT ';

            if (!empty($this->select)) {

                $query .= implode(', ', $this->getConnection()->quoteIdentifierArr($this->select)).' ';

            } else {

                $query .= '* ';

            }

        }

        if (!empty($this->from)) {

        $query .= $this->compileMatch().$this->compileWhere();

        if (!empty($this->group_by)) {

            $query .= 'GROUP BY '.implode(', ', $this->getConnection()->quoteIdentifierArr($this->group_by)).' ';

        }

        if (!empty($this->within_group_order_by)) {

            $query .= 'WITHIN GROUP ORDER BY ';

            $query .= 'INTO '.$this->into.' ';

        }

        if (!empty($this->columns)) {

            $query .= '('.implode(', ', $this->getConnection()->quoteIdentifierArr($this->columns)).') ';

        }

        if (!empty($this->values)) {

            $query .= 'VALUES ';