Field alias does not maintain case

[denniswambua]

Created a field with camel casing
CountField(field="json->>'%s'" % unicode(column), alias="Count")]
The results comes with the count as all small letters.

[{'count': 7L, 'gender': u'male'}, {'count': 1L, 'gender': u'female'}]

Is there a way to maintain the casing as set in the alias property?

[denniswambua]

This is a postgres thing, i got it working by passing alias with double quotes.
'"Count"'
Full example
CountField(field="json->>'%s'" % unicode(column), alias='"{}"'.format('Count'))]

Is there a better way to achieve this?

[somewes]

@denniswambua You are right, postgres will lower the case unless the alias is in double quotes. I'll update the project to automatically add double quotes around the alias so you don't have to manually do this.

[denniswambua]

awesome that would be great