OK, after playing with the highlighter it became obvious of a few shortcomings.
I use MariaDB (which is not the same as MySQL), there are some datatypes and functions missing (VARCHAR, CAST, ...). So I made my own highlighter with a few changes
1. New dialect - MariaDB
2. Enabled is true by default
3. Set some reasonable default colours
4. Exposed the three strings so it's easier to add functions, keywords, and datatypes.
I have attached a package.