Benchlink PMS

// experts.ts — 서버 액션
const [rows] = await db.run({
  sql: `
    SELECT
      e.id,
      e.full_name,
      e.email AS primaryEmail,
      e.tier,
      (SELECT COUNT(*) FROM interview i
        WHERE i.expert_id = e.id
          AND i.interview_status = 'Completed') AS completedInterviews,
      (SELECT ee.company_name FROM expert_experience ee
        WHERE ee.id = e.id
        ORDER BY ee.start_date DESC LIMIT 1) AS latestCompany,
      (SELECT CAST(ee.start_date AS STRING) FROM expert_experience ee
        WHERE ee.id = e.id
        ORDER BY ee.start_date DESC LIMIT 1) AS latestStartDate
    FROM expert e
    LEFT JOIN recruited_by rb ON rb.expert_id = e.id
    LEFT JOIN \`user\` u ON u.id = rb.user_id
    ${whereClause}
    LIMIT @limit OFFSET @offset
  `,
  params: spannerParams,
});

---
batch_id: 21A
domain: Expert
status: COMPLETED
assigned_persona: Backend
files_touched:
  - apps/web/app/actions/experts.ts
  - apps/web/lib/spanner/where-builder.ts
  - apps/web/api/expert-suggestion-results/[id]/route.ts
dynamic_rules:
  - "expert.full_name 은 SELECT 시 항상 포함"
  - "Spanner는 \`user\` 테이블명 백틱 필수"
ddl_changes:
  - "CREATE INDEX idx_expert_status_created ON Expert(status, created_at DESC) STORING (full_name, email, tier)"
---