Первое доказательство.

TypeScriptNode ≥ 20

1. 01Установка

   $npm i @thyn-ai/sqaiскопировано

2. 02Подключение источника

   import { createSQAI } from "@thyn-ai/sqai";
   
   const sqai = createSQAI();
   await sqai.connect("./sales.csv",
     { name: "sales" });

3. 03Запрос

   const a = await sqai.ask({
     metric: "revenue",
     aggregation: "sum",
     group_by: "region",
     source_name: "sales",
   });
   // east 2130.5 · west 1519 · north 1000
   // plan_hash f87610d8afeb…

4. 04Вычисление значения

   const r = await sqai.compute({
     module: "finance", function: "npv",
     args: [0.1, [-1000, 300, 420, 560, 680]],
   });

   r.value505.020148896933

   r.computation_hashb74f67d0…d91bc8

PythonPython ≥ 3.10

1. 01Установка

   $pip install sqaiскопировано

2. 02Подключение источника

   from sqai import SQAI
   
   sqai = SQAI()
   sqai.connect("./sales.csv",
     name="sales")

3. 03Запрос

   a = sqai.ask({
     "metric": "revenue",
     "aggregation": "sum",
     "group_by": "region",
     "source_name": "sales",
   })
   # east 2130.5 · west 1519 · north 1000
   # plan_hash f87610d8afeb…

4. 04Вычисление значения

   r = sqai.compute(
     module="finance", function="npv",
     args=[0.1, [-1000, 300, 420, 560, 680]],
   )

   r["value"]505.020148896933

   r["computation_hash"]b74f67d0…d91bc8