{
  "db_name": "PostgreSQL",
  "query": "\n        SELECT\n            ig.name as group_name,\n            ws.workspace_id,\n            w.name as workspace_name,\n            ws.auto_invite->'instance_groups_roles'->ig.name as role\n        FROM instance_group ig\n        INNER JOIN workspace_settings ws ON ws.auto_invite->'instance_groups' IS NOT NULL\n            AND ws.auto_invite->'instance_groups' ? ig.name\n        INNER JOIN workspace w ON w.id = ws.workspace_id AND w.deleted = false\n        ORDER BY ig.name, ws.workspace_id\n        ",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "group_name",
        "type_info": "Varchar"
      },
      {
        "ordinal": 1,
        "name": "workspace_id",
        "type_info": "Varchar"
      },
      {
        "ordinal": 2,
        "name": "workspace_name",
        "type_info": "Varchar"
      },
      {
        "ordinal": 3,
        "name": "role",
        "type_info": "Jsonb"
      }
    ],
    "parameters": {
      "Left": []
    },
    "nullable": [
      false,
      false,
      false,
      null
    ]
  },
  "hash": "87cb0e9503776dbaea70652612cf43ecedc55b2e6319aefcf9797e7dfad0812c"
}
