The main reason developers want the database to be a "dumb" data store is for portability and costs. If you use all the features of SQL Server, you are "locked in" and on the upgrade path for a long time. Smaller clients may not want to pay the cost or have another DBMS other than SQL Server.