SQL procedure outputs columns in totally different order

Hello everyone,
I have a procedure in SQL that outputs a table that includes columns of different types.
When I run it, I receive a perfectly normal output.
However, when I run the same exact procedure with node-red using the MSSQL pallet, the order of the columns is totally different.
Why is that?

Which actual mssql contrib node are you using?

Do you specify the columns in the SQL (or use a *)?