I agree with you 100%. I've been on the front line too many times having to debug an error in production. If you can see the  SQL statements in a stored proc then half the battle is won.