getSession().createSQLQuery(sql.toString())
.addScalar("key", Hibernate.STRING)
.addScalar("value", Hibernate.STRING)
.setResultTransformer(Transformers.aliasToBean(NameCode.class))
.list();
public class NameCode
{
private String key;
private String value;
...
}