Alias

The use of alias in your query can be easily done in ivory.

Example

//import the ivory class
require_once('Operations.php');

//the instance of the ivory
$ivoryOrm = new Operations();

$arrSelect[] = "SUM(productValue) AS total";

$tables[] = "products";

//the method select creates the query : SELECT SUM(productValue) AS total FROM products;
$select = $ivoryOrm->select($arrSelect, $tables);

//the method runQuery is responsible to literally run your query into the database;
$result = $ivoryOrm->runQuery($select);