Compat issue for using MySQL and LibPQ together on julia v1.11

[briederer]

I've recently stumbled upon a problem using julia v1.11 when trying to include the newest version of LibPQ and MySQL in the same package (more detailed description JuliaDatabases/LibPQ.jl#305).

I traced down the compat issue to the fixed compat of MariaDB_Connector_C_jll to v3.1.12 here.
Can this compat be lifted maybe?

Compat-Issue trace

(@v1.11) pkg> activate --temp
  Activating new project at `/var/folders/0m/l4d83wg11t3csq1jnxhz29dm0000gn/T/jl_RNPdVb`

(@v1.11) pkg> add MySQL

(@v1.11) pkg> add [email protected]
   Resolving package versions...
ERROR: Unsatisfiable requirements detected for package MariaDB_Connector_C_jll [aabc7e14]:
 MariaDB_Connector_C_jll [aabc7e14] log:
 ├─possible versions are: 3.1.6 - 3.3.9 or uninstalled
 ├─restricted by compatibility requirements with OpenSSL_jll [458c3c95] to versions: 3.3.9 or uninstalled
 │ └─OpenSSL_jll [458c3c95] log:
 │   ├─possible versions are: 1.1.1 - 3.0.15 or uninstalled
 │   └─restricted by compatibility requirements with LibPQ_jll [08be9ffa] to versions: 3.0.8 - 3.0.15
 │     └─LibPQ_jll [08be9ffa] log:
 │       ├─possible versions are: 12.3.0 - 16.0.0 or uninstalled
 │       └─restricted by compatibility requirements with LibPQ [194296ae] to versions: 16.0.0
 │         └─LibPQ [194296ae] log:
 │           ├─possible versions are: 0.4.0 - 1.18.0 or uninstalled
 │           └─restricted to versions 1.18 by an explicit requirement, leaving only versions: 1.18.0
 └─restricted by compatibility requirements with MySQL [39abe10b] to versions: 3.1.12 — no versions left
   └─MySQL [39abe10b] log:
     ├─possible versions are: 0.6.0 - 1.4.6 or uninstalled
     ├─restricted to versions * by project [7ae5fbe9], leaving only versions: 0.6.0 - 1.4.6
     │ └─project [7ae5fbe9] log:
     │   ├─possible versions are: 0.0.0 or uninstalled
     │   └─project [7ae5fbe9] is fixed to version 0.0.0
     └─restricted by compatibility requirements with BinaryProvider [b99e7846] to versions: 1.4.0 - 1.4.6 or uninstalled, leaving only versions: 1.4.0 - 1.4.6
       └─BinaryProvider [b99e7846] log:
         ├─possible versions are: 0.4.0 - 0.5.10 or uninstalled
         └─restricted by julia compatibility requirements to versions: uninstalled

[briederer]

Related #208, #219