function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jason JonesJason Jones 

Can you Rename a Column in a SOQL Query

How can I rename columns for an ETL export? For example, I have a quote with quote line items export that I need to change the column name of Status to attribute:QuoteStatus.

Thanks in Advance!
SwethaSwetha (Salesforce Developers) 
HI Jason,
Sharing this similar post from past: https://salesforce.stackexchange.com/questions/38507/soql-alias-a-column

Based on answer provided , 
"SOQL has very limited aliasing support. You can alias the table, e.g. SELECT a.name FROM Account a, but that's of very little use. In most contexts you cannot alias fields.

The one exception is for queries that use aggregations, like SELECT COUNT(Id) recordCount FROM Account allows you to alias the result of the aggregation from it's default expr0 to recordCount."

Try appraoch suggested in https://salesforce.stackexchange.com/a/334846/80089

If this information helps, please mark the answer as best. Thank you