MariaDB

MariaDB is not fully MYSQL compatible. Thus it does not support all the functions available to a MYSQL server. Thus we only a subset of functions can be used. Prism can support this by setting our NonStandardSQL parameter to false. We still use the MYSQL driver as it is packed with most servers. Alternatively you could use the advanced Hikari (see Custom Database Connection configuration

datasource:
  type: mysql
  properties:
    hostname: 127.0.0.1
    username: prism
    password: prism
    databaseName: prism
    prefix: prism_
    port: '3306'
    useNonStandardSql: false