The typical plan from MS is to announce deprecation in a version, say SS2K8, for a feature, continue to support it in the next version, say SS2K11, and then remove it in the following version, SS2K14.

That being said, I think some of this FOREACH functionality will be pushed to Powershell. It's a better fit for that type of language.