Using `count` in CTE has type `never`

I got the following tables:

users

users

users

users:

id

id

, ...

followers

followers

followers

followers:

followingId

followingId

followingId

followingId,

followerId

followerId

followerId

followerId

I'm trying to write a

with

with

with

with common table expression to reuse in other queries:

const withUser = db.$with('user').as(
    db
      .select({
        id: users.id,
        // ...
        following: countDistinct(following.followingId),
        followers: countDistinct(followers.followerId)
      })
      .from(users)
      .leftJoin(following, eq(following.followerId, users.id))
      .leftJoin(followers, eq(followers.followingId, users.id))

const withUser = db.$with('user').as(
    db
      .select({
        id: users.id,
        // ...
        following: countDistinct(following.followingId),
        followers: countDistinct(followers.followerId)
      })
      .from(users)
      .leftJoin(following, eq(following.followerId, users.id))
      .leftJoin(followers, eq(followers.followingId, users.id))

const withUser = db.$with('user').as(
    db
      .select({
        id: users.id,
        // ...
        following: countDistinct(following.followingId),
        followers: countDistinct(followers.followerId)
      })
      .from(users)
      .leftJoin(following, eq(following.followerId, users.id))
      .leftJoin(followers, eq(followers.followingId, users.id))

const withUser = db.$with('user').as(
    db
      .select({
        id: users.id,
        // ...
        following: countDistinct(following.followingId),
        followers: countDistinct(followers.followerId)
      })
      .from(users)
      .leftJoin(following, eq(following.followerId, users.id))
      .leftJoin(followers, eq(followers.followingId, users.id))

The problem is that now, if I try to use the results of that CTE,

sq.following

sq.following

sq.following

sq.following and

sq.followers

sq.followers

sq.followers

sq.followers are not valid columns:

const result = db
  .with(withUser)
  .select({ 
    following: withUser.following //< sq.following has type never, result[0].following is never
   })
  .from(withUser);

const result = db
  .with(withUser)
  .select({ 
    following: withUser.following //< sq.following has type never, result[0].following is never
   })
  .from(withUser);

const result = db
  .with(withUser)
  .select({ 
    following: withUser.following //< sq.following has type never, result[0].following is never
   })
  .from(withUser);

const result = db
  .with(withUser)
  .select({ 
    following: withUser.following //< sq.following has type never, result[0].following is never
   })
  .from(withUser);

AstroBearOP•1/11/24, 8:44 AM

Fixed, I had to use countDistinct(following.followingId).as('following')countDistinct(following.followingId).as('following') etc.