Using query! with AnyPool

[nitnelave]

Hi,

I'm trying to use the query! macros with an AnyPool connection pool.
The idea is to have a simple sqlite DB for dev testing, but be able to use any type of DB in the wild.

With DATABASE_URL=sqlite://my_db.db (correctly created) I can have an sqlx::query!("my query") in the code that is correctly checked. However, I can't execute it with an AnyPool object:

pool: &AnyPool;
...
error[E0271]: type mismatch resolving `<&Pool<sqlx::Any> as Executor<'_>>::Database == sqlx::Sqlite`
query!("my valid query").execute(pool);
                         ^^^^^^^ expected struct `sqlx::Any`, found struct `sqlx::Sqlite`

Ideally, I'd like to be able to check that the query would work well on every engine, mysql/pg/sqlite, but even just working on sqlite is enough for me.

Is there a way to solve this error?

[nitnelave]

Seems that #964 is the correct issue for this.