Simplest query

[aaronhernan]

I have a MySqlPool connection, but i cant get a vec of integers:

let ids: Vec<i64> = sqlx::query_as("SELECT id, id FROM table LIMIT 10").fetch_all(&pool).await?;
Compiler said:
the trait bound "for<'r> i64: FromRow<'r, MySqlRow>" is not satisfied

So, i am able to do:
let ids: Vec<(i64,)> = sqlx::query_as("SELECT id FROM table LIMIT 10").fetch_all(&pool).await?;
I guess it is because ( ) implements some traits?

Is there any way to just query a list (vec) or array of integers (ids)?

[CommanderStorm]

Why do you want to select id, id? That does not sound right.
please use a Vec<(i64,i64)> instead as these are two values