Method analyzeQuery

frontend/src/lib/duckdb/utils/queryRouter.ts:52–93

* Analyze a SQL query and determine the best execution target

(sql: string)

   * Analyze a SQL query and determine the best execution target
   */
  analyzeQuery(sql: string): QueryRouterResult {
    const tableReferences = this.extractTableReferences(sql);
    
    // Categorize table references
    const postgresqlTables: TableReference[] = [];
    const motherduckTables: TableReference[] = [];
    const localTables: TableReference[] = [];
    
    let postgresConnectionId: string | undefined;

    for (const ref of tableReferences) {
      const classification = this.classifyTable(ref);
      
      if (classification.type === 'postgresql') {
        postgresqlTables.push(ref);
        if (!postgresConnectionId) {
          postgresConnectionId = classification.connectionId;
        }
      } else if (classification.type === 'motherduck') {
        motherduckTables.push(ref);
      } else {
        localTables.push(ref);
      }
    }

    // Determine routing target and confidence
    const result = this.determineTarget(
      postgresqlTables,
      motherduckTables,
      localTables,
      postgresConnectionId
    );

    return {
      ...result,
      tableReferences,
      postgresqlTables,
      motherduckTables,
      localTables,
      connectionId: postgresConnectionId,
    };
  }

  /**
   * Extract all table references from a SQL query