// Direct value
where: { active: true }
where: { published: false }

// Explicit equals
where: { active: { equals: true } }

// Negation
where: { active: { not: true } }   // Same as active: false
where: { deleted: { not: false } }  // Same as deleted: true

// Only true
where: { verified: true }

// Only false (not null)
where: { verified: false }

// Only null
where: { verified: null }

// Not null (true or false)
where: { verified: { not: null } }

// Active and not deleted
where: {
  active: true,
  deleted: false,
}

// Published or featured
where: {
  OR: [
    { published: true },
    { featured: true },
  ],
}

async function getActiveUsers() {
  return client.user.findMany({
    where: { active: true },
  });
}

async function getPublishedPosts() {
  return client.post.findMany({
    where: {
      published: true,
      deleted: false,
    },
    orderBy: { publishedAt: "desc" },
  });
}

async function getUnverifiedUsers() {
  return client.user.findMany({
    where: { emailVerified: false },
  });
}

async function getUsersWithBeta() {
  return client.user.findMany({
    where: {
      settings: {
        path: ["betaFeatures"],
        equals: true,
      },
    },
  });
}

// Get only non-deleted
async function getActiveItems() {
  return client.item.findMany({
    where: { deleted: false },
  });
}

// Get only deleted
async function getDeletedItems() {
  return client.item.findMany({
    where: { deleted: true },
  });
}

// Get all (including deleted)
async function getAllItems() {
  return client.item.findMany();
}

async function getReviewablePosts() {
  return client.post.findMany({
    where: {
      published: false,
      submitted: true,
      rejected: false,
    },
  });
}