Why is Alteryx casting field to REAL when using AVG for In-DB connection?

[Bo]

I'm using In-db plugin and Alteryx seems to cast the field used in Avg to REAL. My database doesn't support real. Is there a way to change this behavior? It doesn't do it for things like SUM. 

AVG(CAST(field as REAL))

I have created some mappings of the datatypes using the sample from here: C:\Users\<user>\AppData\Local\Alteryx\bin\RuntimeData\ODBC

But that doesn't seem to be for how Alteryx generates the SQL to the database. Any help is appreciated.