In my opinion, SQL will never go away. ORM tools like Entity Framework, Linq, Hibernate/nHiberante, are getting better but in every case I've seen thus far you still get better performing and easier to maintain code using T-SQL.