PartiQL

A SQL-style interface over your collections, addressed as "databaseId.collectionId". Send statements to POST /partiql with positional ? parameters.

Statements

SELECT * FROM "main.notes" WHERE done = ? ORDER BY priority DESC LIMIT 10
INSERT INTO "main.notes" VALUE { "$id": "n1", "title": "Hi", "done": false }
UPDATE "main.notes" SET done = ?, title = ? WHERE $id = ?
DELETE FROM "main.notes" WHERE $id = ?

curl

curl -X POST "https://base.finiteskills.com/v1/partiql" -H "X-Appwrite-Project: <YOUR_PROJECT_ID>" \
  -H "X-Appwrite-Key: <API_KEY>" -H "Content-Type: application/json" \
  -d '{"statement":"SELECT * FROM \"main.notes\" WHERE done = ? LIMIT 10","parameters":[false]}'

WHERE supports = != < <= > >= joined by AND. UPDATE and DELETE target a single item by $id. Responses are { items, count }.