expected struct sqlx::Any, found struct sqlx::Postgres

[Tristaan]

When using the query! macro and when trying to fetch a row or fetch multiple the error in the title happens:

error[E0271]: type mismatch resolving `<&Pool<sqlx::Any> as Executor<'_>>::Database == sqlx::Postgres`
  --> src/models/users.rs:32:14
   |
32 |             .fetch_all(pool)
   |              ^^^^^^^^^ expected struct `sqlx::Any`, found struct `sqlx::Postgres`

I expected Any to work with any database. What am I doing wrong? because i'm not exactly sure what's happening behind the scenes.

[abonander]

The macros generate code that requires a connection of the same kind of database as the DATABASE_URL you compiled with.

There's currently no way to tell the macros to generate code using the Any driver but we were discussing a way to do it in #964

I'm gonna close this as a duplicate of that issue.