Function discoverESColumns

frontend/src/utils/sqlResult.ts:355–375

(hitsArray: unknown[])

// Discovers columns from ES hits: _id, _score, then sorted _source field keys.
const discoverESColumns = (hitsArray: unknown[]) => {
  const metaFields = ["_id", "_score"];
  const sourceKeySet = new Set<string>();
  for (const hit of hitsArray) {
    const source = (hit as Record<string, unknown>)?._source;
    if (source && typeof source === "object") {
      for (const key of Object.keys(source)) {
        sourceKeySet.add(key);
      }
    }
  }
  const allColumns = [
    ...metaFields,
    ...[...sourceKeySet].sort((a, b) => a.localeCompare(b)),
  ];
  const columnIndexMap = new Map<string, number>();
  for (let i = 0; i < allColumns.length; i++) {
    columnIndexMap.set(allColumns[i], i);
  }
  return { metaFields, allColumns, columnIndexMap };
};

// Builds a single QueryRow from an ES hit document.
const buildESHitRow = (