-- name: UpsertStyleProfile :exec
INSERT INTO user_style_profiles (user_id, platform, embedding, top_keywords, style_summary, post_count)
VALUES (@user_id, @platform, @embedding::vector, @top_keywords, @style_summary, @post_count)
ON CONFLICT (user_id, platform)
DO UPDATE SET
  embedding = EXCLUDED.embedding,
  top_keywords = EXCLUDED.top_keywords,
  style_summary = EXCLUDED.style_summary,
  post_count = EXCLUDED.post_count,
  modified_at = NOW();