Dynamic queries or stored procedures

Just reading Frans blog about stored procedures and the future for them.
I agree with Frans that views are really powerful.

I like stored procedures because they can be easily updated outside your code.
It's happen many times for me to have to add a field to a database, and if I have to modify a code already in production, I would have certainly to go through some issues.

When you modify your code, it could be hazardous, and sometime a complex query can be difficult to understand when it's embedded in a class.

Stored procedures are easy guys for that.

For the future I expect that Microsoft will not go too much in the 'lazy' proprietary way of doing everything with .Net.
I enjoy Transact-Sql and the way that I can almost change from SQL Server to Oracle without breaking too much things.