Drush archive-dump override sql dump name
Unfortunately, there is no way to stipulate what the sql dump file should be named.  See the archive-dump source code for reference.

Wouldn't be too hard to adjust; PRs would be welcome.