so, if I'm using a SQL Query why do I end up with a big decimal in java for a database type that's defined NUMBER

my setter takes a native long and I currently map the database columns to java using AliasToBeanResultTransformer where
I define aliases using "as" where my physical columns are mapped to the property names of my bean class but
if I try to add an addScalar to fix the type of one of my aliases it assumes or takes precedence over all the existing
aliases "as" that are defined in the SQL so I'm forced to use addScalar for _all_ columns which is something I don't
want to do.