How can I alias column names in a sql query while loading data through logstash?

I want to change some column name while loading the data through logstash

Have a look at this: https://www.elastic.co/guide/en/logstash/current/plugins-filters-mutate.html

The SELECT part of a SQL query allows you to assign any names to the columns in the result set.