{
  "db_name": "PostgreSQL",
  "query": "SELECT \n        v2_job_queue.workspace_id,\n        v2_job_queue.id,\n        v2_job.args as \"args: sqlx::types::Json<HashMap<String, Box<RawValue>>>\",\n        v2_job.parent_job,\n        v2_job.created_by,\n        v2_job_queue.started_at,\n        v2_job_queue.runnable_settings_handle,\n        scheduled_for,\n        runnable_path,\n        kind as \"kind: JobKind\",\n        runnable_id as \"runnable_id: ScriptHash\",\n        canceled_reason,\n        canceled_by,\n        permissioned_as,\n        permissioned_as_email,\n        flow_status as \"flow_status: sqlx::types::Json<Box<RawValue>>\",\n        v2_job.tag,\n        script_lang as \"script_lang: ScriptLang\",\n        same_worker,\n        pre_run_error,\n        concurrent_limit,\n        concurrency_time_window_s,\n        flow_innermost_root_job,\n        root_job,\n        timeout,\n        flow_step_id,\n        cache_ttl,\n        cache_ignore_s3_path,\n        v2_job_queue.priority,\n        preprocessed,\n        script_entrypoint_override,\n        trigger,\n        trigger_kind as \"trigger_kind: JobTriggerKind\",\n        visible_to_owner,\n        NULL as permissioned_as_end_user_email\n        FROM v2_job_queue INNER JOIN v2_job ON v2_job.id = v2_job_queue.id LEFT JOIN v2_job_status ON v2_job_status.id = v2_job_queue.id WHERE v2_job_queue.id = $1",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "workspace_id",
        "type_info": "Varchar"
      },
      {
        "ordinal": 1,
        "name": "id",
        "type_info": "Uuid"
      },
      {
        "ordinal": 2,
        "name": "args: sqlx::types::Json<HashMap<String, Box<RawValue>>>",
        "type_info": "Jsonb"
      },
      {
        "ordinal": 3,
        "name": "parent_job",
        "type_info": "Uuid"
      },
      {
        "ordinal": 4,
        "name": "created_by",
        "type_info": "Varchar"
      },
      {
        "ordinal": 5,
        "name": "started_at",
        "type_info": "Timestamptz"
      },
      {
        "ordinal": 6,
        "name": "runnable_settings_handle",
        "type_info": "Int8"
      },
      {
        "ordinal": 7,
        "name": "scheduled_for",
        "type_info": "Timestamptz"
      },
      {
        "ordinal": 8,
        "name": "runnable_path",
        "type_info": "Varchar"
      },
      {
        "ordinal": 9,
        "name": "kind: JobKind",
        "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": 10,
        "name": "runnable_id: ScriptHash",
        "type_info": "Int8"
      },
      {
        "ordinal": 11,
        "name": "canceled_reason",
        "type_info": "Text"
      },
      {
        "ordinal": 12,
        "name": "canceled_by",
        "type_info": "Varchar"
      },
      {
        "ordinal": 13,
        "name": "permissioned_as",
        "type_info": "Varchar"
      },
      {
        "ordinal": 14,
        "name": "permissioned_as_email",
        "type_info": "Varchar"
      },
      {
        "ordinal": 15,
        "name": "flow_status: sqlx::types::Json<Box<RawValue>>",
        "type_info": "Jsonb"
      },
      {
        "ordinal": 16,
        "name": "tag",
        "type_info": "Varchar"
      },
      {
        "ordinal": 17,
        "name": "script_lang: ScriptLang",
        "type_info": {
          "Custom": {
            "name": "script_lang",
            "kind": {
              "Enum": [
                "python3",
                "deno",
                "go",
                "bash",
                "postgresql",
                "nativets",
                "bun",
                "mysql",
                "bigquery",
                "snowflake",
                "graphql",
                "powershell",
                "mssql",
                "php",
                "bunnative",
                "rust",
                "ansible",
                "csharp",
                "oracledb",
                "nu",
                "java",
                "duckdb",
                "ruby"
              ]
            }
          }
        }
      },
      {
        "ordinal": 18,
        "name": "same_worker",
        "type_info": "Bool"
      },
      {
        "ordinal": 19,
        "name": "pre_run_error",
        "type_info": "Text"
      },
      {
        "ordinal": 20,
        "name": "concurrent_limit",
        "type_info": "Int4"
      },
      {
        "ordinal": 21,
        "name": "concurrency_time_window_s",
        "type_info": "Int4"
      },
      {
        "ordinal": 22,
        "name": "flow_innermost_root_job",
        "type_info": "Uuid"
      },
      {
        "ordinal": 23,
        "name": "root_job",
        "type_info": "Uuid"
      },
      {
        "ordinal": 24,
        "name": "timeout",
        "type_info": "Int4"
      },
      {
        "ordinal": 25,
        "name": "flow_step_id",
        "type_info": "Varchar"
      },
      {
        "ordinal": 26,
        "name": "cache_ttl",
        "type_info": "Int4"
      },
      {
        "ordinal": 27,
        "name": "cache_ignore_s3_path",
        "type_info": "Bool"
      },
      {
        "ordinal": 28,
        "name": "priority",
        "type_info": "Int2"
      },
      {
        "ordinal": 29,
        "name": "preprocessed",
        "type_info": "Bool"
      },
      {
        "ordinal": 30,
        "name": "script_entrypoint_override",
        "type_info": "Varchar"
      },
      {
        "ordinal": 31,
        "name": "trigger",
        "type_info": "Varchar"
      },
      {
        "ordinal": 32,
        "name": "trigger_kind: JobTriggerKind",
        "type_info": {
          "Custom": {
            "name": "job_trigger_kind",
            "kind": {
              "Enum": [
                "webhook",
                "http",
                "websocket",
                "kafka",
                "email",
                "nats",
                "schedule",
                "app",
                "ui",
                "postgres",
                "sqs",
                "gcp",
                "mqtt",
                "nextcloud",
                "google"
              ]
            }
          }
        }
      },
      {
        "ordinal": 33,
        "name": "visible_to_owner",
        "type_info": "Bool"
      },
      {
        "ordinal": 34,
        "name": "permissioned_as_end_user_email",
        "type_info": "Text"
      }
    ],
    "parameters": {
      "Left": [
        "Uuid"
      ]
    },
    "nullable": [
      false,
      false,
      true,
      true,
      false,
      true,
      true,
      false,
      true,
      false,
      true,
      true,
      true,
      false,
      false,
      true,
      false,
      true,
      false,
      true,
      true,
      true,
      true,
      true,
      true,
      true,
      true,
      true,
      true,
      true,
      true,
      true,
      true,
      false,
      null
    ]
  },
  "hash": "5bf200f2c8db25ddf231b564503c6c70f7f3958564a79bb0c6b3863b1ebb0cbf"
}
