{
  "db_name": "PostgreSQL",
  "query": "SELECT g_.workspace_id, name, summary, extra_perms, array_agg(u2g.usr) filter (where u2g.usr is not null) as members \n            FROM usr u\n            JOIN usr_to_group u2g ON u2g.usr = u.username AND u2g.workspace_id = u.workspace_id\n            RIGHT JOIN group_ g_ ON g_.workspace_id = u.workspace_id AND g_.name = u2g.group_\n            WHERE g_.workspace_id = $1 AND g_.name != 'all'\n            GROUP BY g_.workspace_id, name, summary, extra_perms",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "workspace_id",
        "type_info": "Varchar"
      },
      {
        "ordinal": 1,
        "name": "name",
        "type_info": "Varchar"
      },
      {
        "ordinal": 2,
        "name": "summary",
        "type_info": "Text"
      },
      {
        "ordinal": 3,
        "name": "extra_perms",
        "type_info": "Jsonb"
      },
      {
        "ordinal": 4,
        "name": "members",
        "type_info": "VarcharArray"
      }
    ],
    "parameters": {
      "Left": [
        "Text"
      ]
    },
    "nullable": [
      false,
      false,
      true,
      false,
      null
    ]
  },
  "hash": "ca5f42cb0e368d0817461600152aabefe718829fb6eae2f681c4c8328acc94b2"
}
