{
  "db_name": "PostgreSQL",
  "query": "\n        SELECT DISTINCT deployment_group\n        FROM deployments\n        WHERE project_id = $1\n          AND (\n            -- Always include default group if it has any deployments\n            deployment_group = 'default'\n            OR\n            -- Include other groups only if they have non-terminal deployments\n            (deployment_group != 'default' AND NOT is_terminal(status))\n          )\n        ORDER BY deployment_group\n        ",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "deployment_group",
        "type_info": "Text"
      }
    ],
    "parameters": {
      "Left": [
        "Uuid"
      ]
    },
    "nullable": [
      false
    ]
  },
  "hash": "ced10e6ddf6f814adbe3799f3c82fdced9f852c3545b0b796b55e5420485c7b7"
}
