doctrine / orm

                $sqlParts = [];

                // Select all fields from the queried class

                foreach ($class->fieldMappings as $fieldName => $mapping) {

                    if ($partialFieldSet && ! in_array($fieldName, $partialFieldSet)) {

                        continue;

                    }

                    $tableName = (isset($mapping['inherited']))

                        ? $this->em->getClassMetadata($mapping['inherited'])->getTableName()

                        : $class->getTableName();

                    $sqlTableAlias    = $this->getSQLTableAlias($tableName, $dqlAlias);

                    $columnAlias      = $this->getSQLColumnAlias($mapping['columnName']);

                    $quotedColumnName = $this->quoteStrategy->getColumnName($fieldName, $class, $this->platform);

                    $col = $sqlTableAlias . '.' . $quotedColumnName;

                    if (isset($mapping['requireSQLConversion'])) {

                        $type = Type::getType($mapping['type']);

                        $col = $type->convertToPHPValueSQL($col, $this->platform);

                    }

                    $sqlParts[] = $col . ' AS '. $columnAlias;

                    $this->scalarResultAliasMap[$resultAlias][] = $columnAlias;

                    $this->rsm->addFieldResult($dqlAlias, $columnAlias, $fieldName, $class->name);

                }

                // Add any additional fields of subclasses (excluding inherited fields)

                // 1) on Single Table Inheritance: always, since its marginal overhead

                // 2) on Class Table Inheritance only if partial objects are disallowed,

                //    since it requires outer joining subtables.

                if ($class->isInheritanceTypeSingleTable() || ! $this->query->getHint(Query::HINT_FORCE_PARTIAL_LOAD)) {

                    foreach ($class->subClasses as $subClassName) {

                        $subClass      = $this->em->getClassMetadata($subClassName);

                        $sqlTableAlias = $this->getSQLTableAlias($subClass->getTableName(), $dqlAlias);

                        foreach ($subClass->fieldMappings as $fieldName => $mapping) {

                            if (isset($mapping['inherited']) || ($partialFieldSet && !in_array($fieldName, $partialFieldSet))) {

                                continue;

                            }

                            $columnAlias      = $this->getSQLColumnAlias($mapping['columnName']);

                            $quotedColumnName = $this->quoteStrategy->getColumnName($fieldName, $subClass, $this->platform);

                            $col = $sqlTableAlias . '.' . $quotedColumnName;

                            if (isset($mapping['requireSQLConversion'])) {

                                $type = Type::getType($mapping['type']);

                                $col = $type->convertToPHPValueSQL($col, $this->platform);

                            }

                            $sqlParts[] = $col . ' AS ' . $columnAlias;

                            $this->scalarResultAliasMap[$resultAlias][] = $columnAlias;

                            $this->rsm->addFieldResult($dqlAlias, $columnAlias, $fieldName, $subClassName);

                        }

                    }

                }

                $sql .= implode(', ', $sqlParts);