Underscores or camelCase in PostgreSQL identifiers, when the programming language uses camelCase?

If your columns in the PostgreSQL are with underscores, you can put aliases but with doule-quotes.

Example :

SELECT my_column as "myColumn" from table;