title: how to convert the view rows into schema in sql
body: <p>i have a view in sql with dynamic columns like</p>
  <pre><code>id   name     col1             col2               col3
  1     a       value1           value2             value3
  </code></pre>
  <p>i need output like</p>
  <pre><code>col_name      values            result
  name          a                name : a
  col1          value1           col1 : value1
  col2          value2           col2 : value2
  col3          value3           col3 : value3
  </code></pre>
  <p>i have tried multiple things but unsuccessful..
  thanks in advance</p>