Read Documents

const user = await client.findUnique('users', {
  email: 'alice@example.com'
});

if (user) {
  console.log('Found user:', user.name);
} else {
  console.log('User not found');
}

const activeUsers = await client.findMany(
  'users',
  { active: true },
  {
    limit: 10,
    sort: { field: 'createdAt', order: 'desc' }
  }
);

console.log(`Found ${activeUsers.length} active users`);

const count = await client.countDocuments('users', { active: true });
console.log(`Active users: ${count}`);

const users = await client.queryBuilder()
  .collection('users')
  .whereField('active').isTrue()
  .whereField('createdAt').dateThisMonth()
  .selectFields(['id', 'name', 'email'])
  .orderBy('createdAt', 'desc')
  .limit(50)
  .execute();

const user = await client.findUnique('users', { id: 'user_123' });

// Page 1
const page1 = await client.findMany('posts', {}, {
  limit: 10,
  offset: 0,
  sort: { field: 'createdAt', order: 'desc' }
});

// Page 2
const page2 = await client.findMany('posts', {}, {
  limit: 10,
  offset: 10,
  sort: { field: 'createdAt', order: 'desc' }
});

const user = await client.queryBuilder()
  .collection('users')
  .whereField('email').equals('alice@example.com')
  .executeUnique<User>();
// Returns: User | null (latest version by timestamp)