NamedParameterJdbcTemplate无法执行insert into select

// 创建NamedParameterJdbcTemplate对象
NamedParameterJdbcTemplate jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);

// 执行select语句，获取需要插入的数据集合
String selectSql = "SELECT * FROM source_table WHERE condition = :condition";
Map<String, Object> selectParams = new HashMap<>();
selectParams.put("condition", condition);
List<SourceData> sourceDataList = jdbcTemplate.query(selectSql, selectParams, new BeanPropertyRowMapper<>(SourceData.class));

// 执行insert语句，将数据插入到目标表中
String insertSql = "INSERT INTO target_table (column1, column2, column3) VALUES (:column1, :column2, :column3)";
List<Map<String, Object>> insertParams = new ArrayList<>();
for (SourceData sourceData : sourceDataList) {
    Map<String, Object> insertParam = new HashMap<>();
    insertParam.put("column1", sourceData.getColumn1());
    insertParam.put("column2", sourceData.getColumn2());
    insertParam.put("column3", sourceData.getColumn3());
    insertParams.add(insertParam);
}
jdbcTemplate.batchUpdate(insertSql, insertParams.toArray(new Map[0]));