Athena query results

Hi all, I am aiming to sourcing data from AWS Athena into a retool app.
The data connection and the query works fine. However, all returned data items are strings, irrespective of the source table data types.
For example, integer data sourced from Athena appear with double quotes around them (e.g. "1").
Is there a way to resolve this?
Thanks in advance.

Hi there!

I'll gladly assist you with this!

Hm. This is certainly odd behavior! What is the use case of this query?
Would using a transformer to change the results of this query be a possible path we can take here?