doctrine / orm

        }

        // check if a column alias was used (column_name as field_name)

        if (preg_match("/(\w+)\sas\s(\w+)/i", $column['name'], $matches)) {

            $name = $matches[1];

            $column['name'] = $name;

            $column['alias'] = $matches[2];

        }

        if (preg_match("/([a-zA-Z]+)\(([0-9]+)\)/", $column['type'], $matches)) {

            $column['type'] = $matches[1];

            $column['alias'] = $matches[2];

        }

        if (preg_match("/([a-zA-Z]+)\(([0-9]+)\)/", $column['type'], $matches)) {

            $column['type'] = $matches[1];

            $column['length'] = $matches[2];

        }

        $column['type'] = strtolower($column['type']);

        // check if legacy column type (1.x) needs to be mapped to a 2.0 one