Within reason, there’s nothing you can’t do with XML in SQL Server 2012. The Microsoft team has addressed nearly every XML complaint and wish-list item gathered from the days of SQL Server 2008 R2.
For the beginner and expert alike, SQL Server 2012 offers much to master in the realm of XML processing. The sheer quantity of features may seem challenging at first. Remember that you need only utilize those features that are appropriate to your current application needs. How your applications develop and grow from there is entirely up to you.