Execute Agent Insights free-form SQL

Runs Ollie-generated read-only SQL bounded to the caller’s workspace and the requested project. Returns 501 when the Agent Insights toggle is off.

projectIdstringRequiredformat: "uuid"

This endpoint expects an object.

querystringRequired>=1 character

Read-only ClickHouse SQL. Must return exactly one column named result produced via toJSONString(…)

Query results

resultslist of objects

400

Bad Request Error

422

Unprocessable Entity Error

501

Not Implemented Error

$	curl -X POST http://localhost:5173/api/v1/internal/analytics-queries/projects/projectId \
>	-H "Content-Type: application/json" \
>	-d '{
>	"query": "SELECT toJSONString(arrayMap(x -> x * 2, [1, 2, 3])) AS result"
>	}'