Dialect support (MariaDB)

[rottmann]

I use MariaDB instead of MySQL, there are small differences, e.g. MySQL CAST(? AS JSON) will not work in MariaDB, cause it handles JSON as LONGTEXT.

I saw that engines are hard coded and i currently don't know how much effort it takes to implement dialects or add it as an additional engine or allow custom overrides.

Currently i manually set the typing for the json fields, not elegant, but ok for some fields.

[lroal]

It is probably straightforward to add MariaDB. I prefer to have supported DBs hardcoded and well tested with integration tests so that we can ensure consistent behavior across all environments and avoid subtle dialect-specific issues.

I can probably do this within next week. If you want to create a PR yourself, you’re welcome to — I think an AI agent would handle this quite well by examining the existing structure and tests.

[lroal]

Added MariaDB in v5.3.0.
#169