1INSERT INTO feature_flags (user_id, name, expires_at)
 2SELECT DISTINCT ON (ff.user_id) ff.user_id, 'pastes', ff.expires_at
 3FROM feature_flags ff
 4JOIN invites ON invites.to_user_id = ff.user_id
 5WHERE ff.name = 'prose'
 6  AND NOT EXISTS (
 7    SELECT 1 FROM feature_flags existing
 8    WHERE existing.user_id = ff.user_id AND existing.name = 'pastes'
 9  )
10ORDER BY ff.user_id, ff.expires_at DESC;