您可以尝试以下操作，但必须触发一个额外的查询。
我假设你把一个

@Transient
private int newCol;

字符串
你的MyTable Entity

public void fetchAllData() {
        //fetch all your MyTable here
        List<MyTable> myTableList = emSlave.createNativeQuery("select my_table.* as newCol from my_table", MyTable.class)
                .getResultList();

        //this query will fetch just the table id from your MyTable and the new column you desire to bring out
        String secondQuery = "select my_table.id as tableId, 1 as newCol from my_table";
        
        List<Object[]> secondQueryResult = emSlave.createNativeQuery(secondQuery)
                .getResultList();
        
        //Collecting the result into a dto
        List<TempDataHolder> tempDataHolderList = secondQueryResult
                .stream()
                .map(o -> new TempDataHolder((Number) o[0], (Number) o[1]))
                .collect(Collectors.toList());

        //Collecting the TempDataHoler into a map
        Map<Integer, Integer> mapOfTableIdAndNewCol = tempDataHolderList
                .stream()
                .collect(Collectors.toMap(TempDataHolder::getTableId, TempDataHolder::getNewCol));

        //using a loop, fetch the value from Map and set into the extra column
        myTableList.forEach((mt) -> {
            mt.setNewCol(mapOfTableIdAndNewCol.get(mt.getId()));
        });
    }

    @Getter
    @Setter
    public class TempDataHolder {

        private int tableId;
        private int newCol;

        public TempDataHolder(Number tableId, Number newCol) {
            this.tableId = tableId.intValue();
            this.newCol = newCol == null ? 0 : newCol.intValue();
        }

    }

型
我使用TempDataHolder只是为了使它更容易。你可以实现你的结果，而不使用任何新的DTO，只是把你的secondQueryResult直接转换成Map。
如果你只想把它投在你提到的新职业上。

public void fetchAllData() {
        //fetch all your MyTable here
        List<MyTable> myTableList = emSlave.createNativeQuery("select my_table.* as newCol from my_table", MyTable.class)
                .getResultList();

        //this query will fetch just the table id from your MyTable and the new column you desire to bring out
        String secondQuery = "select my_table.id as tableId, 1 as newCol from my_table";
        
        List<Object[]> secondQueryResult = emSlave.createNativeQuery(secondQuery)
                .getResultList();
        
        //Collecting the result into a dto
        List<TempDataHolder> tempDataHolderList = secondQueryResult
                .stream()
                .map(o -> new TempDataHolder((Number) o[0], (Number) o[1]))
                .collect(Collectors.toList());

        //Collecting the TempDataHoler into a map
        Map<Integer, Integer> mapOfTableIdAndNewCol = tempDataHolderList
                .stream()
                .collect(Collectors.toMap(TempDataHolder::getTableId, TempDataHolder::getNewCol));

       List<newObj> newObjList=new ArrayList<>(myTableList.size());
        
        for(MyTable mt : myTableList){
            newObjList.add(new newObj(mt, mapOfTableIdAndNewCol.get(mt.getId())));
        }
    }

    @Getter
    @Setter
    public class TempDataHolder {

        private int tableId;
        private int newCol;

        public TempDataHolder(Number tableId, Number newCol) {
            this.tableId = tableId.intValue();
            this.newCol = newCol == null ? 0 : newCol.intValue();
        }

    }

    @Getter
    @Setter
    class newObj {

        MyTable myTable;
        int newCol;

        public newObj(MyTable myTable, int newCol) {
            this.myTable = myTable;
            this.newCol = newCol;
        }
        
        
    }

型
如果成功了就告诉我。祝你好运！