// Insight Master - Natural Language to SQL Engine
import { SQLValidator } from '@axon/sql-validator';

interface QueryResult {
  sql: string;
  explanation: string;
  data: Record<string, any>[];
  visualization: ChartConfig;
}

async function naturalLanguageQuery(
  question: string,
  context: BusinessContext
): Promise<QueryResult> {
  // Step 1: Intent recognition
  const intent = await recognizeIntent(question);
  // "上个月哪个品类最赚钱？"
  // → intent: { type: 'ranking', metric: 'profit', dimension: 'category', period: 'last_month' }
  
  // Step 2: SQL generation with schema awareness
  const sql = await generateSQL(intent, context.schema);
  // → SELECT category, SUM(revenue - cost) as profit
  //   FROM orders WHERE order_date >= '2026-04-01'
  //   GROUP BY category ORDER BY profit DESC LIMIT 10
  
  // Step 3: SQL validation (prevent injection, verify logic)
  const validated = SQLValidator.check(sql, {
    allowedTables: context.permissions,
    maxRows: 10000
  });
  
  // Step 4: Execute and format
  const rawData = await executeQuery(validated.sql);
  
  // Step 5: Generate visualization config
  const chart = suggestVisualization(intent, rawData);
  
  return {
    sql: validated.sql,
    explanation: `查询了${rawData.length}条记录，按${intent.dimension}维度的${intent.metric}排名`,
    data: rawData,
    visualization: chart
  };
}