Return a dynamic map regardless of query using namedParameterJdbcTemplate

namedParameterJdbcTemplate-Dynamic-map.java

  List<Map<String, Object>> result =  namedParameterJdbcTemplate.query(query, whereParams, rs -> {
            List<Map<String, Object>> rows = new ArrayList<>();
            ResultSetMetaData metaData = rs.getMetaData();
            int columnCount = metaData.getColumnCount();
            while (rs.next()) {
                Map<String, Object> columns = new LinkedHashMap<>();
                for (int i = 1; i <= columnCount; i++) {
                    columns.put(metaData.getColumnLabel(i), rs.getObject(i));
                }
                rows.add(columns);
            }
            return rows;
        });