How to choose what tables to skip for drush sql-sync @dev @staging?
Drush sql-sync does not support shared databases that use prefixes.  You might have some luck if you wrote a wrapper script that used drush sqlq 'show tables;' to get a list of available tables, filter them manually by prefix, and then pass them back to sql-sync via the --tables-list option.