Can the Query Builder allow me to add a calculated field so it shows up in my SQL?
The Query Builder does have the ability to include a calculated field. Open the Query Builder, add your columns and click on the Sigma icon (i.e. Edit calculated fields).
Review the following for additional information:
New field name - Click + to add the column to the list of defined fields.
Defined fields - Select a column for which you want to define fields from the list.
Field definition - Double-click the columns or calculated fields and the appropriate functions or operators to include in the calculated field.
Attach to table - Select the table that you want to attach to the calculated field.