import { Photon } from "@photon-ai/api";

const photon = new Photon({
  headers: { Authorization: `Bearer ${process.env.PHOTON_API_TOKEN}` },
});
const result = await photon.projects.getMessageMetricsSqlSchema({
  path: {
    projectId: "projectId",
  },
});

import os

from photon_api import Photon
from photon_api.rpc_generated import GetMessageMetricsSqlSchemaInput

photon = Photon(headers={"Authorization": f"Bearer {os.environ['PHOTON_API_TOKEN']}"})
result = photon.projects.get_message_metrics_sql_schema(
    GetMessageMetricsSqlSchemaInput.model_validate({
        "path": {
            "projectId": "projectId",
        },
    })
)

use photon_ai_api::{Credential, PhotonClientBuilder, SecretString};

let token = std::env::var("PHOTON_API_TOKEN")?;
let client = PhotonClientBuilder::new()
    .credential("accountServiceKey", Credential::Bearer(SecretString::from(token)))
    .build()?;
let result = client
    .get_message_metrics_sql_schema("projectId".to_owned(), None)
    .await
    .map_err(|error| format!("{error:?}"))?
    .into_inner();

{
  "capabilities": {
    "arrayJoin": true,
    "ctes": true,
    "joins": true,
    "parameters": true,
    "selectWithoutFrom": true,
    "subqueries": true,
    "unions": true
  },
  "dialect": "string",
  "limits": {
    "maximumParameterValueBytes": 1,
    "maximumParameters": 1,
    "maximumSqlBytes": 1,
    "maximumTotalParameterBytes": 1
  },
  "projectScoped": true,
  "tables": [
    {
      "columns": [
        {
          "description": "string",
          "json": {},
          "name": "string",
          "type": "string"
        }
      ],
      "currentState": "string",
      "description": "string",
      "name": "message_events"
    }
  ],
  "version": "2026-01-01"
}