The thing is, most people use MySQL. Most MOD authors (myself included) only develop with MySQL in front.
While SMF has an abstraction layer for database support, it is possible that some things can cause problems with other engines.
I might add that some other forum softwares out there only explicitly support MySQL
