如何在hibernate原生查询中仅从列表中获取值我的列表返回键值对

String sql = "SELECT column1, column2 FROM your_table";
SQLQuery query = session.createSQLQuery(sql);

query.setResultTransformer(Transformers.aliasToBean(YourCustomClass.class));

query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);

List<?> results = query.list();

for (Object result : results) {
    if (result instanceof YourCustomClass) {
        YourCustomClass obj = (YourCustomClass) result;
        // 获取键值对
        Object key = obj.getKey();
        Object value = obj.getValue();
        // 处理键值对
    } else if (result instanceof Map) {
        Map<?, ?> map = (Map<?, ?>) result;
        // 获取键值对
        Object key = map.get("column1");
        Object value = map.get("column2");
        // 处理键值对
    }
}