Function isExplainQueryPlan

src/components/gui/query-explanation.tsx:30–46

(sql: string, dialect: SupportedDialect)

});

export function isExplainQueryPlan(sql: string, dialect: SupportedDialect) {
  if (!["sqlite", "mysql"].includes(dialect)) return false;

  if (sql.toLowerCase().startsWith("explain query plan")) {
    return true;
  }

  if (sql.toLowerCase().startsWith("explain format=json")) {
    return true;
  }

  if (sql.toLowerCase().startsWith("explain (format json)")) {
    return true;
  }

  return false;
}

function buildQueryExplanationTree(nodes: ExplanationRow[]) {
  const map: Record<number, ExplanationRowWithChildren> = {};