create table agent_by_name (
  id uuid,
  name text,
  description text,
  primary key(name)
);

create table agent_by_description (
  id uuid,
  name text,
  description text,
  primary key(description)
);

public class AgentPOCO
{
    public Guid Id;
    public string Name;
    public string Description;
}

private ISession _session;
var _mapper = new Mapper(_session);

...

var cqlByName = new Cql("SELECT * FROM agent_by_name");
var cqlByDescription = new Cql("SELECT * FROM agent_by_description");

...

var mapResult1 = _mapper.Fetch<AgentPOCO>(cqlByName).AsQueryable();
var mapResult2 = _mapper.Fetch<AgentPOCO>(cqlByDescription).AsQueryable();