-- name: FindSimilarUsers :many
SELECT user_id, platform, embedding, top_keywords, style_summary, post_count,
       1 - (embedding <=> $1::vector) AS similarity
FROM user_style_profiles
ORDER BY embedding <=> $1::vector
LIMIT $2;