Vendor DBs tend to aim at multiple platforms and this boils down to lowest common denominator design.

If the product states that MySQL is supported expect heap tables in SQL Server and no foreign keys.

Ditto check constraints and probably defaults.