Google sheets query: how to select column twice in query

I have a query that is really long (about 50 columns), I don’t want to split into 2 queries. But I want a column to show up twice. Is there a way to do this? below is a simple example that doesn’t work.

How to select B twice? The ability to select something twice is pretty standard in any SQL right?

=query(B3:D7,"select B,C,B",0)