getAtRisk.php

<?php
function getAtRisk($api, $args)
{
    $seed = BeanFactory::newBean('Accounts');

    $q = new SugarQuery();
    // Set from to the bean first so SugarQuery can figure out joins and fields on the first try
    $q->from($seed);
    // Adding the ID field so we can validate the results from the select
    $q->select('id');
    $q->limit(5);

    // Return the raw SQL results through the API
    return $q->execute();
}