SQLPermit

Admitted input schema

{
  "type": "object",
  "properties": {
    "audience": {
      "type": "string",
      "minLength": 0,
      "maxLength": 4096,
      "description": "Identity of the ONE executor the permit is for. Required when issue_permit is true. Wildcards are rejected."
    },
    "dialect": {
      "type": "string",
      "minLength": 0,
      "maxLength": 4096,
      "enum": [
        "postgresql"
      ]
    },
    "issue_permit": {
      "type": "boolean"
    },
    "policy": {
      "type": "object",
      "properties": {
        "allow_multi_statement": {
          "type": "boolean",
          "description": "Permit more than one statement in the input. Defaults to false."
        },
        "allow_returning": {
          "type": "boolean",
          "description": "Accept RETURNING on a permitted write without a warning."
        },
        "allow_row_locks": {
          "type": "boolean",
          "description": "Accept SELECT ... FOR UPDATE without a warning."
        },
        "allowed_functions": {
          "type": "array",
          "items": {
            "type": "string",
            "minLength": 0,
            "maxLength": 4096
          },
          "minItems": 0,
          "maxItems": 100,
          "description": "Added to the built-in allowlist. Bare name, or schema.function to admit one of your own."
        },
        "allowed_languages": {
          "type": "array",
          "items": {
            "type": "string",
            "minLength": 0,
            "maxLength": 4096
          },
          "minItems": 0,
          "maxItems": 100,
          "description": "Permitted CREATE FUNCTION languages. Defaults to none."
        },
        "allowed_schemas": {
          "type": "array",
          "items": {
            "type": "string",
            "minLength": 0,
            "maxLength": 4096
          },
          "minItems": 0,
          "maxItems": 100,
          "description": "Schemas the statement may reference."
        },
        "allowed_tables": {
          "type": "array",
          "items": {
            "type": "string",
            "minLength": 0,
            "maxLength": 4096
          },
          "minItems": 0,
          "maxItems": 100,
          "description": "Permitted relations as schema.table, or a bare name to match an unqualified reference."
        },
        "max_rows": {
          "type": "integer",
          "minimum": 1,
          "maximum": 9007199254740991,
          "description": "Row ceiling. Becomes a permit obligation the executor enforces."
        },
        "read_only": {
          "type": "boolean",
          "description": "Reject anything that can change data or schema, including writes reached through a CTE."
        },
        "statement_timeout_ms": {
          "type": "integer",
          "minimum": 1,
          "maximum": 9007199254740991,
          "description": "Timeout written into the permit obligations. Defaults to 30000."
        }
      },
      "required": [],
      "additionalProperties": false
    },
    "sql": {
      "type": "string",
      "minLength": 1,
      "maxLength": 4096
    },
    "subject": {
      "type": "string",
      "minLength": 0,
      "maxLength": 4096,
      "description": "Opaque caller label recorded as the permit subject."
    },
    "target_pg_major": {
      "type": "integer",
      "minimum": -9007199254740991,
      "maximum": 9007199254740991,
      "enum": [
        18
      ],
      "description": "Required. The PostgreSQL major the statement will run on. Only 18 is supported in v1: a permit issued under one grammar and verified against another is a parser differential."
    }
  },
  "required": [
    "dialect",
    "target_pg_major",
    "sql"
  ],
  "additionalProperties": false
}