Json filters array_starts_with and array_ends_with don't work on MariaDB

[Weakky]

Bug description

CAST(? AS JSON) is not supported by MariaDB. We need to find a way that works both on MySQL and MariaDB

How to reproduce

1. Spin up a MariaDB instance
2. Create a query that involves array_ends_with or array_starts_with
3. Notice the error

Expected behavior

Filter should work just like on MySQL 5.7/8

Prisma information

model Test {
  id   Int  @id
  json Json
}

Environment & setup

• OS: Mac OS
• Database: MariaDB

Prisma Version

latest QE