when QoQ is used, it sorts the query column, how can i force it to not sort and display in the same way as described in order

I'm not exactly sure what you mean, but keep in mind that QoQ is case-sensitive. And maybe show what you mean. Show your code, the results, and the expected results.

ok, i did select userid,name,email from users; it dumps me out, email,name,users

Dump always puts the columns in alphabetical order. How will you use the columns? Are you using Adobe or Lucee? In Adobe at least, there's a way to get the columns in select-list order, I think it's

query.getColumnNames()

ok, let me try the query.getcolumnnames i am using adobe cf2021

Why are you perceiving that the column-order in a dump "matters"? That can't be why yer asking yer question; there must be more to it than this. What's the actual problem yer trying to solve?