Doctrine allow you to use column alias but very buggy. I found two bugs till now, the first one is #1309 (just reported) and here come the second:

If I create an alias Id for primary key catalog_id. When I call $record->refresh(true) with column alias, Doctrine will yield that can't find column catalog_id.

The problem is here

$query->where(implode(' = ? AND ', $this->getTable()->getIdentifierColumnNames()) . ' = ?');

If we use column alias, this query is not possible.