{
  "db_name": "PostgreSQL",
  "query": "SELECT name, id, scim_display_name, array_remove(array_agg(email_to_igroup.email), null) as emails, external_id FROM email_to_igroup RIGHT JOIN instance_group ON instance_group.name = email_to_igroup.igroup WHERE id = $1 group by name, id",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "name",
        "type_info": "Varchar"
      },
      {
        "ordinal": 1,
        "name": "id",
        "type_info": "Varchar"
      },
      {
        "ordinal": 2,
        "name": "scim_display_name",
        "type_info": "Varchar"
      },
      {
        "ordinal": 3,
        "name": "emails",
        "type_info": "VarcharArray"
      },
      {
        "ordinal": 4,
        "name": "external_id",
        "type_info": "Varchar"
      }
    ],
    "parameters": {
      "Left": [
        "Text"
      ]
    },
    "nullable": [
      false,
      true,
      true,
      null,
      true
    ]
  },
  "hash": "6032ab9ab230c48a44f684e70ebc3277a2543cd3b52a3123b0585f6c9071552c"
}
