Is it possible to get the total count while fetching rows in a single query?

const { items, count } = await db
  .selectFrom(eb => eb
    .selectFrom("ads")
    .selectAll()
    .$if(filters?.is_active !== undefined, eb => eb.where("is_active", "=", filters?.is_active as AdsTable["is_active"]))
    .$if(filters?.is_expired !== undefined, eb => eb.where(sql`expires > now()`))
    .offset((paginationOptions.page - 1) * paginationOptions.perPage)
    .limit(paginationOptions.perPage)
    .as("items"))
  .select(() => [
    sql<number>`cast(count(1) as int)`.as("count"),
    sql<Selectable<AdsTable>[]>`coalesce(json_agg(items), '[]')`.as("items")
  ])
  .executeTakeFirstOrThrow()

const { items, count } = await db
  .selectFrom(eb => eb
    .selectFrom("ads")
    .selectAll()
    .$if(filters?.is_active !== undefined, eb => eb.where("is_active", "=", filters?.is_active as AdsTable["is_active"]))
    .$if(filters?.is_expired !== undefined, eb => eb.where(sql`expires > now()`))
    .offset((paginationOptions.page - 1) * paginationOptions.perPage)
    .limit(paginationOptions.perPage)
    .as("items"))
  .select(() => [
    sql<number>`cast(count(1) as int)`.as("count"),
    sql<Selectable<AdsTable>[]>`coalesce(json_agg(items), '[]')`.as("items")
  ])
  .executeTakeFirstOrThrow()