YAML -> SQL

YAML

    

main:
  from: data
  distinct_on:
  - data.code
  join:
  - query:
      from:        
        values:
        - key: 'us'
          value: 'test1'
        - key: 'fr'
          value: 'France'
      alias: codes
      fields: ["code", "name"]
    alias: countries
    type: left_join
    on:
    - left: countries.code
      operator: "="
      right: data.code

SQL

    


SELECT DISTINCT ON ( data.code ) * FROM "data" LEFT JOIN (SELECT * FROM (VALUES ('us', 'test1'), ('fr', 'France')) AS codes(code, name)) countries ON countries.code = data.code