Transforming SELECT from case to camelCase via sql with execute

I am getting some values for example

comments.created_at,

comments.created_at,

comments.created_at,

comments.created_at,

I wish to transform this with the AS keyword:

comments.created_at AS createdAt,

comments.created_at AS createdAt,

comments.created_at AS createdAt,

comments.created_at AS createdAt,

The issue is that it just returns as:

createdat

createdat

createdat

createdat

It does not follow the camelCase that was defined, it just goes lower case for some reason.