type "schema.x_enum" does not exist - after updating to SQLX 0.8.5

Description

Before, to have an enum in a namespace that is not public, I would do the following:

#[derive(
    Debug, Clone, PartialEq, Eq, EnumIter, DeriveActiveEnum, Serialize, Deserialize, JsonSchema,
)]
#[sea_orm(
    rs_type = "String",
    db_type = "Enum",
    enum_name = "SCHEMA.X_ENUM"
)]
pub enum XEnum {
    #[sea_orm(string_value = "A")]
    A,
    #[sea_orm(string_value = "B")]
    B,
}

impl IntoActiveValue<Self> for XEnum {
    fn into_active_value(self) -> sea_orm::ActiveValue<Self> {
        sea_orm::ActiveValue::Set(self.clone())
    }
}

This was hacky but it would work fine. It seems that now, after updating to sqlx 0.8.5. This breaks and returns the error type "schema.x_enum" does not exist.

Steps to Reproduce

1. Create an enum in a separate schema
2. Try to query it

Expected Behavior

It's queriable

Actual Behavior

Type doesn't exist

Reproduces How Often

Yes

Workarounds

I was able to work around it for now but setting the search_path to the schema, however, I am concerned about duplicate types if it ever shows up.

Reproducible Example

Versions

Start with the Rust enum declaration and reproduce the query against an enum in a separate schema using SQLX 0.8.5. Compare the failure with the search_path workaround; done means the schema-qualified type can be queried without relying on search_path or creating duplicate types.