That's because a different database may have different transaction isolation than an another one. Fairly complex SQL queries cannot be used between different major databases.

I am one of those who don't care about SQL, I assume it will fail and in general avoid transaction as much as possible.