To be fair to vendors, it's increasingly difficult to maintain compatibility with both! Here's my very long rundown of the differences in tables/DDL alone: https://www.skeema.io/blog/2023/05/10/mysql-vs-mariadb-schem...

...and that doesn't even account for differences in global variables/configuration, SQL syntax, functions, replication, etc.