{
  "db_name": "PostgreSQL",
  "query": "\n        SELECT\n            p.id as project_id,\n            d.id as \"id?\",\n            d.status as \"status?: crate::db::models::DeploymentStatus\"\n        FROM unnest($1::uuid[]) AS p(id)\n        LEFT JOIN deployments d ON d.project_id = p.id\n            AND d.is_active = TRUE\n            AND d.deployment_group = 'default'\n        ",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "project_id",
        "type_info": "Uuid"
      },
      {
        "ordinal": 1,
        "name": "id?",
        "type_info": "Uuid"
      },
      {
        "ordinal": 2,
        "name": "status?: crate::db::models::DeploymentStatus",
        "type_info": "Text"
      }
    ],
    "parameters": {
      "Left": [
        "UuidArray"
      ]
    },
    "nullable": [
      null,
      true,
      true
    ]
  },
  "hash": "77067ee714cf21f723e729b45f48d962f961936c9a5ae1bee66a0a081d39a0a2"
}
