#176: sql-sync dump files stored to --dump-dir should not be temporary.
Make it a little clearer that dump-is-temp is an output of drush_sql_dump_file(); also, allow --temp to be used to force temp files in the dump directory, if desired.