[development] Why do we avoid auto-incrementing db columns?

Could someone either clue me in or point to a prior discussion about why Drupal avoids using auto-incrementing database columns? If it is database compatibility, which versions of which databases that we support do not have it? Thanks, Barry