Queries

Queries

jsorm uses a structured query shape instead of chain builders.

Select queries

const result = await db.get(User, {
  select: {
    id: true,
    name: true,
    role: {
      name: true,
    },
  },
  where: {
    active: true,
    name: {
      contains: 'Ali',
    },
  },
  orderBy: [{ createdAt: 'desc' }],
  pagination: {
    limit: 10,
    offset: 0,
  },
});

Update queries

await db.update(User, {
  data: {
    active: false,
  },
  where: {
    role: {
      name: {
        eq: 'guest',
      },
    },
  },
});

Delete queries

await db.delete(User, {
  where: {
    id: {
      eq: 10,
    },
  },
});

Best practices

1. Always keep where clauses explicit for writes.
2. Prefer nested relation filters over raw join strings.
3. Use orderBy and pagination together for stable list endpoints.