sql now represents API duration