Database: Select

$db = \Database::getDB();
$tbl = $db->addTable('foo');
$tbl->addFieldConditional('bar', 1);
$result = $db->select();

Alternate selects

$csv_importable_row = $db->selectAsCSV();
while ($first_column_result = $db->selectColumn(0)) {
...
}
$single_row = $db->selectOneRow();
echo $db->selectQuery(); // see what the sql string is going to before the query