How to create sql alias in drupal 7
In this link you will see that field method doesn't support alias. Instead supports,

$query = db_select('node', 'n');


But to have alias for fields follow this link which will be,

$query-&gt;addField('n', 'name', 'label');
$query-&gt;addField('n', 'name', 'value');