added sqlgen and a failing api test