Some kysely query with PostgreSQL CTE

kysely-cte.ts

await db
    .with("expiration_date", (db) =>
        db
            .selectFrom("missions")
            .select(({ fn }) => ["user_id", fn.max("end").as("expiration")])
            .groupBy("user_id")
    )
    .selectFrom(["users", "expiration_date"])
    .select([
        "users.username",
        "expiration_date.expiration",
        sql<boolean>`expiration_date.expiration < NOW()`.as("expired"),
    ])
    .where((eb) => eb("expiration_date.user_id", "=", eb.ref("users.uuid")))
    .execute();