[FEATURE]: Add `mode: mariadb` to `mysql`

### Describe what you want

Hello,

We use `mariadb` at work. I don't know why, but seniors told me that "it's just a fork of mysql because of licensing". So I used it as any mysql. With `mysql2` driver. While using Drizzle, I found out that `mariadb` doesn't support [lateral derived tables](https://jira.mariadb.org/browse/MDEV-19078), because my SQL for `db.query` failed on [`LEFT JOIN LATERAL`](https://jira.mariadb.org/browse/MDEV-33018?page=com.atlassian.jira.plugin.system.issuetabpanels%3Aall-tabpanel).

I don't think that it would be proper to treat `mariadb` as different db, because in my experience, it feels closer to `mysql` than Planetscale (at least it has fkeys). So I wanted to ask, what do you think about having a new `mode: mariadb` for `mysql` in Drizzle?