{
  "db_name": "PostgreSQL",
  "query": "SELECT\n                        j.id,\n                        j.kind AS \"kind: _\",\n                        COALESCE(s.path, f.path) AS \"script_path!\",\n                        COALESCE(s.hash, f.id) AS \"script_hash!: _\",\n                        COALESCE(jc.started_at, jq.scheduled_for, make_date(1970, 1, 1)) AS \"scheduled_for!: _\",\n                        args AS input,\n                        COALESCE(s.schema, f.schema) AS \"schema: _\"\n                    FROM v2_job j\n                    LEFT JOIN script s ON j.runnable_id = s.hash AND j.kind = 'script'\n                    LEFT JOIN flow_version f ON j.runnable_id = f.id AND j.runnable_path = f.path AND j.kind = 'flow'\n                    LEFT JOIN v2_job_completed jc ON jc.id = j.id\n                    LEFT JOIN v2_job_queue jq ON jq.id = j.id\n                    WHERE j.id = ANY($1)\n                        AND j.workspace_id = $2\n                        AND COALESCE(s.hash, f.id) IS NOT NULL\n                        AND COALESCE(s.path, f.path) IS NOT NULL",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "id",
        "type_info": "Uuid"
      },
      {
        "ordinal": 1,
        "name": "kind: _",
        "type_info": {
          "Custom": {
            "name": "job_kind",
            "kind": {
              "Enum": [
                "script",
                "preview",
                "flow",
                "dependencies",
                "flowpreview",
                "script_hub",
                "identity",
                "flowdependencies",
                "http",
                "graphql",
                "postgresql",
                "noop",
                "appdependencies",
                "deploymentcallback",
                "singlestepflow",
                "flowscript",
                "flownode",
                "appscript",
                "aiagent",
                "unassigned_script",
                "unassigned_flow",
                "unassigned_singlestepflow"
              ]
            }
          }
        }
      },
      {
        "ordinal": 2,
        "name": "script_path!",
        "type_info": "Varchar"
      },
      {
        "ordinal": 3,
        "name": "script_hash!: _",
        "type_info": "Int8"
      },
      {
        "ordinal": 4,
        "name": "scheduled_for!: _",
        "type_info": "Timestamptz"
      },
      {
        "ordinal": 5,
        "name": "input",
        "type_info": "Jsonb"
      },
      {
        "ordinal": 6,
        "name": "schema: _",
        "type_info": "Json"
      }
    ],
    "parameters": {
      "Left": [
        "UuidArray",
        "Text"
      ]
    },
    "nullable": [
      false,
      false,
      null,
      null,
      null,
      true,
      null
    ]
  },
  "hash": "e2905bca184696a80357d8e4126832a902b3088d91fbbb858f6c0aa9de8a5ff7"
}
