Like almost all commands, weather change commands can go in init fields, triggers, waypoints or scripts.
You never alter the mission.sqm. (Well actually you do sometimes, but only in very special cases when there is no command to do what you want. But that's another story.)