Multi-Language
REST API DB Studio npm Sign In
Docs / Universal Client / Table CRUD
Data Layer

Table CRUD Operations — Multi-Language Reference

Paginated selects, inserts with generated IDs, and record deletes across all languages.

Perform standard table-level operations with built-in pagination, sorting, and RETURNING * inserts.

Paginated Row Selection

const { rows, total, page } = await db.from('orders')
  .select('*')
  .limit(25)
  .page(1)
  .orderBy('created_at', 'DESC')
params = {"limit": 25, "page": 1, "sort_col": "created_at", "sort_dir": "DESC"}
res = requests.get(
    f"{BASE_URL}/api/dbaas/v2/projects/{SLUG}/tables/orders",
    headers={"Authorization": f"Bearer {API_KEY}"},
    params=params
)
orders = res.json()["rows"]
curl -H "Authorization: Bearer oq_live_..." \
  "https://db.echo.oqens.me/api/dbaas/v2/projects/production-app/tables/orders?limit=25&page=1"

Inserting Records

const { ok, row } = await db.from('orders').insert({
  customer_email: 'alice@example.com',
  amount_cents: 4999
})
console.log('Inserted ID:', row.id)
res = requests.post(
    f"{BASE_URL}/api/dbaas/v2/projects/{SLUG}/tables/orders",
    headers={"Authorization": f"Bearer {API_KEY}"},
    json={"customer_email": "alice@example.com", "amount_cents": 4999}
)
row = res.json()["row"]
print("Inserted ID:", row["id"])
curl -X POST https://db.echo.oqens.me/api/dbaas/v2/projects/production-app/tables/orders \
  -H "Authorization: Bearer oq_live_..." \
  -H "Content-Type: application/json" \
  -d '{"customer_email": "alice@example.com", "amount_cents": 4999}'

Deleting Records

DELETE /tables/:table/row?pk_col=id&pk_val=142 
curl -X DELETE "https://db.echo.oqens.me/api/dbaas/v2/projects/production-app/tables/orders/row?pk_col=id&pk_val=142" \
  -H "Authorization: Bearer oq_live_..."
Copied