I have the following:

        $this->src('aws')
        ->query("SELECT o.opportunityId, o.status, FROM_UNIXTIME(o.projectDate) as 'projectDate', FROM_UNIXTIME(o.creationDate) as 'creationDate', a.nosql_ClientId_Of_Agency FROM voly_master.tbl_Opportunity o LEFT JOIN voly_master.tbl_Organization a ON o.organizationId = a.organizationId WHERE FROM_UNIXTIME(o.creationDate) between :StartDate and :EndDate AND a.organizationTypeId = 3")
		->params(array(
            ":StartDate"=>$this->params["StartDate"],
			":EndDate"=>$this->params["EndDate"]
        ))
        ->pipe(new Limit(array(2000)))
        ->pipe($this->dataStore('opp_test'));

This goes to a table. How would I go about replacing the inline query with a command to execute a proc? Note that there are two params.

*execute It is early... and I can't edit the title...

Figured it out, just had a typo. CALL usp_AgenciesWhoPostedOpportunities(:StartDate, :EndDate); in the query param.