Snowflake select query to return data in json format

Question

I am making a select call on a table and it always returns 1 row. I would like to get the data in json format.

{
  "column_name1": "value1",
  "column_name2": "value2",
}

Does snowflake query allows anything like this ?

Answer 1

object_construct is the way to go for this.

For example,

select object_construct(*) from t1;