8. LIMIT (ORDER BY is roadmap)

# LIMIT works. ORDER BY through /sql is on the roadmap.
curl -X POST "https://$OC_HOST/v1/tenants/$OC_TENANT/sql" \
  -H "Authorization: Bearer $OC_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "sql": "SELECT id, amount_cents FROM shop.orders WHERE amount_cents > 0 LIMIT 3"
  }'

# Fetch a wider LIMIT, sort in Python.
result = db.sql("SELECT id, amount_cents FROM shop.orders WHERE amount_cents > 0 LIMIT 50")

sorted_rows = sorted(result.rows, key=lambda r: r["amount_cents"], reverse=True)[:3]
for row in sorted_rows:
    print(row["id"], row["amount_cents"])

// Fetch a wider LIMIT, sort in TypeScript.
const result = await db.sql(`SELECT id, amount_cents FROM shop.orders WHERE amount_cents > 0 LIMIT 50`);

if (result.kind === "select") {
  const sorted = [...result.rows]
    .sort((a, b) => Number(b.amount_cents) - Number(a.amount_cents))
    .slice(0, 3);
  console.log(sorted);
}

// Fetch a wider LIMIT, sort in Go.
result, _ := db.SQL(ctx, `SELECT id, amount_cents FROM shop.orders WHERE amount_cents > 0 LIMIT 50`)

sort.Slice(result.Rows, func(i, j int) bool {
    return result.Rows[i]["amount_cents"].(float64) > result.Rows[j]["amount_cents"].(float64)
})
top3 := result.Rows[:3]