{
  "db_name": "PostgreSQL",
  "query": "\n        SELECT\n            route_path,\n            http_method AS \"http_method: _\",\n            request_type AS \"request_type: _\",\n            workspaced_route,\n            summary,\n            description,\n            authentication_method AS \"authentication_method: _\",\n            authentication_resource_path,\n            script_path,\n            is_flow,\n            wrap_body\n        FROM\n            http_trigger\n        WHERE\n           path ~ ANY($1) AND\n           route_path ~ ANY($2) AND\n           workspace_id = $3\n        ",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "route_path",
        "type_info": "Varchar"
      },
      {
        "ordinal": 1,
        "name": "http_method: _",
        "type_info": {
          "Custom": {
            "name": "http_method",
            "kind": {
              "Enum": [
                "get",
                "post",
                "put",
                "delete",
                "patch"
              ]
            }
          }
        }
      },
      {
        "ordinal": 2,
        "name": "request_type: _",
        "type_info": {
          "Custom": {
            "name": "request_type",
            "kind": {
              "Enum": [
                "sync",
                "async",
                "sync_sse"
              ]
            }
          }
        }
      },
      {
        "ordinal": 3,
        "name": "workspaced_route",
        "type_info": "Bool"
      },
      {
        "ordinal": 4,
        "name": "summary",
        "type_info": "Varchar"
      },
      {
        "ordinal": 5,
        "name": "description",
        "type_info": "Text"
      },
      {
        "ordinal": 6,
        "name": "authentication_method: _",
        "type_info": {
          "Custom": {
            "name": "authentication_method",
            "kind": {
              "Enum": [
                "none",
                "windmill",
                "api_key",
                "basic_http",
                "custom_script",
                "signature"
              ]
            }
          }
        }
      },
      {
        "ordinal": 7,
        "name": "authentication_resource_path",
        "type_info": "Varchar"
      },
      {
        "ordinal": 8,
        "name": "script_path",
        "type_info": "Varchar"
      },
      {
        "ordinal": 9,
        "name": "is_flow",
        "type_info": "Bool"
      },
      {
        "ordinal": 10,
        "name": "wrap_body",
        "type_info": "Bool"
      }
    ],
    "parameters": {
      "Left": [
        "TextArray",
        "TextArray",
        "Text"
      ]
    },
    "nullable": [
      false,
      false,
      false,
      false,
      true,
      true,
      false,
      true,
      false,
      false,
      false
    ]
  },
  "hash": "1cb21a66ffc89ebe53fd8f58690eec4cf11cb4b7816738202b474e8d3ffef427"
}
