It is only 1 query away checking if the user has an existing alert, though ... xf_user_alert would have it for that particular content_type with that id for the target user
It is not really a technical restriction, but rather, a choice, or an oversight