{
  "db_name": "PostgreSQL",
  "query": "SELECT workspace.id, workspace.name, usr.username, workspace_settings.color, workspace.parent_workspace_id,\n                CASE WHEN usr.operator THEN workspace_settings.operator_settings ELSE NULL END as operator_settings,\n                usr.disabled\n         FROM workspace\n         JOIN usr ON usr.workspace_id = workspace.id\n         JOIN workspace_settings ON workspace_settings.workspace_id = workspace.id\n         WHERE usr.email = $1 AND workspace.deleted = false",
  "describe": {
    "columns": [
      {
        "ordinal": 0,
        "name": "id",
        "type_info": "Varchar"
      },
      {
        "ordinal": 1,
        "name": "name",
        "type_info": "Varchar"
      },
      {
        "ordinal": 2,
        "name": "username",
        "type_info": "Varchar"
      },
      {
        "ordinal": 3,
        "name": "color",
        "type_info": "Varchar"
      },
      {
        "ordinal": 4,
        "name": "parent_workspace_id",
        "type_info": "Varchar"
      },
      {
        "ordinal": 5,
        "name": "operator_settings",
        "type_info": "Jsonb"
      },
      {
        "ordinal": 6,
        "name": "disabled",
        "type_info": "Bool"
      }
    ],
    "parameters": {
      "Left": [
        "Text"
      ]
    },
    "nullable": [
      false,
      false,
      false,
      true,
      true,
      null,
      false
    ]
  },
  "hash": "c095a9658c542efc9f0255a1b536d2fd8a25fe4cd57c223db7d744493f8470c6"
}
