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

[briederer]

In julia 1.11 the support for BinaryProvider.jl has been completely dropped (see JuliaRegistries/General#114503).
Therefore it is not possible anymore in julia v1.11 to load the newest version of LibPQ.jl in the same package as MySQL.jl.
Before on v1.10 it was possible since loading the newest version of LibPQ.jl downgraded MySQL.jl to v1.3.1 which however still depends on BinaryProvider.jl

However, as can be seen from the example below, this issue could be resolved by one of the following approaches:

• Downgrading LibPQ to v1.17.1: This is not possible in my case since we have had several issues with LibPQ_jll v14.3.0+1
• Upgrading the restricting MariaDB_Connector_C_jll compat in MySQL.jl (see Compat issue for using MySQL and LibPQ together on julia v1.11 MySQL.jl#221)

Minimal example:

(@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