thecodingmachine / magic-query

        return substr($sql, 0, -1);

    }

    protected function processWhereExpression($parsed)

    {

        if ($parsed['expr_type'] !== ExpressionType::EXPRESSION) {

            return '';

        }

        $sql = '';

        foreach ($parsed['sub_tree'] as $k => $v) {

            $len = strlen($sql);

            $sql .= $this->processColRef($v);

            $sql .= $this->processConstant($v);

            $sql .= $this->processOperator($v);

            $sql .= $this->processInList($v);

            $sql .= $this->processFunction($v);

            $sql .= $this->processWhereExpression($v);

            $sql .= $this->processWhereBracketExpression($v);

            if ($len == strlen($sql)) {

                throw new UnableToCreateSQLException('WHERE expression subtree', $k, $v, 'expr_type');

            }

            $sql .= ' ';

        }

        $sql = substr($sql, 0, -1);

        return $sql;

    }

    protected function processWhereBracketExpression($parsed)

    {

        return $sql;

    }

    protected function processWhereBracketExpression($parsed)

    {

        if ($parsed['expr_type'] !== ExpressionType::BRACKET_EXPRESSION) {

            return '';

        }

        $sql = '';

        foreach ($parsed['sub_tree'] as $k => $v) {

            $len = strlen($sql);

            $sql .= $this->processColRef($v);

            $sql .= $this->processConstant($v);

            $sql .= $this->processOperator($v);

            $sql .= $this->processInList($v);

            $sql .= $this->processFunction($v);

            $sql .= $this->processWhereExpression($v);

            $sql .= $this->processWhereBracketExpression($v);

            if ($len == strlen($sql)) {

                throw new UnableToCreateSQLException('WHERE expression subtree', $k, $v, 'expr_type');

            }

            $sql .= ' ';

        }

        $sql = '('.substr($sql, 0, -1).')';

        return $sql;

    }

    protected function processOrderByAlias($parsed)

    {