What is the substitute for update_sql() in D7?
No, it does not exist any longer. You need to use Schema API function dedicated for what you need to be done. For example to rename field you should use db_change_field.