How to access values returned via an SQL Single Record Query

[Matt]

Hello,

I am making an SQL call to a local database to retrieve a users default warehouse. However I cant seem to reference these values. How would I assign a type to these values so I am able to reference them?

-Thanks, Matt

[daniel]

I would recommend in your “SELECT” statement to write out the columns you are querying. Good luck.

[Matt]

In the end the solution was to give the columns from the database an alias
Thank you Albin Lundberg for the help on this.