good way to get the "count" for paginated queries

const fileCountRes = await ctx.db
  .select({
    count: sql<number>`count(*)`.mapWith(Number),
  })
  .from(file)
  .innerJoin(bucket, eq(file.bucketId, bucket.id))
  .where(eq(bucket.name, bucketName));

const filesRes = await ctx.db
  .select()
  .from(file)
  .innerJoin(bucket, eq(file.bucketId, bucket.id))
  .where(eq(bucket.name, bucketName))
  .limit(pageSize)
  .offset((currentPage - 1) * pageSize)
  .orderBy(desc(file.updatedAt));