Zend AbstractTableGateway does not support table alias

Couldnt figure out how to do it,
finally, i created my own Sql and and Select on my own.

But ive to overwrite executeSelect to allow table select with alias
$resultSet = $this->selectWith($oSelect);