wrong type for results of average about arel HOT 2 CLOSED

Not sure if it is related but,
somehow I cannot execute my query by doing

ActiveRecord::Base.connection.execute(method_generating_arel_object_request)

when in my projection I have .average.as("somename") because the following error is raised

TypeError: no implicit conversion of Arel::SelectManager into String
from /Users/{users}/.rvm/gems/ruby-2.4.1/gems/activerecord-5.1.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:97:in `async_exec'

so I ended up doing

ActiveRecord::Base.connection.execute(method_generating_arel_object_request.to_sql)

from arel.

This doesn't sound a like a problem with ARel, but a problem with the database adapter or possibly your column types. The database adapter uses the column type to cast it to a Ruby object. It could be that the column type is wrong, or that the database adapter doesn't know how to handle that type. Take a look at the pg_typeof function. You can use that function to figure out what type you're selecting. From there, either fix your data so it's the right type, or file a bug on the Rails side (as it's a bug in the adapter).

Thanks!

from arel.