Merge Struct in PartiQL

[yliuuuu]

I want to transform

<<
  {
    'k1': 'v1',
    'k2': 'v2'
  },
  {
    'k3': 'v3',
    'k4': 'v4'
  }
>>

to

{
  'k1': 'v1',
  'k2': 'v2',
  'k3': 'v3',
  'k4': 'v4'
}

Do you know if it is possible in PartiQL?

Question asked by krock21rus@ on community.partiql.org.

[yliuuuu]

I found a solution:

PartiQL> PIVOT sp.p at sp."s" from (SELECT s, p from [{'k1': 'v1', 'k2': 'v2'}, {'k3': 'v3', 'k4': 'v4', 'k5': 'v5'}, {'k6': 'v6'}] as c, unpivot c as p at s) sp
   |
==='
{
  'k1': 'v1',
  'k2': 'v2',
  'k3': 'v3',
  'k4': 'v4',
  'k5': 'v5',
  'k6': 'v6'
}
---

Question answered by krock21rus@ on community.partiql.org.