Is there a way to change the order in which the columns are displayed?

You can use the fields operator. For example, if you fields are dispayed as   B , C , A, D, E.   In your query you can add "| fields A, B, C, D, E".