YAML -> SQL

YAML

    
main:
  select:
  - field: ct.*
  from:
    alias: ct
    fields:
    - name: problem_id
      type: bigint
    - name: info_1
      type: varchar(255)
    - name: info_2
      type: varchar(255)
    - name: info_3
      type: varchar(255)
    crosstab:
    - select:
      - extra_infos.problem_id
      - extra_infos.info_type
      - extra_infos.info_value
      from: extra_infos
    - select:
      - extra_infos.info_type 
      distinct: true
      from: extra_infos

SQL

    
SELECT
  ct.*
FROM
  crosstab(
    'SELECT extra_infos.problem_id, extra_infos.info_type, extra_infos.info_value FROM "extra_infos"',
    'SELECT DISTINCT extra_infos.info_type FROM "extra_infos"'
  ) AS ct(
    "problem_id" bigint,
    "info_1" varchar(255),
    "info_2" varchar(255),
    "info_3" varchar(255)
  )