const rows = await db
.selectFrom("table")
.where("id", "=", "123")
.select((eb) => [
eb.cast<Date | string>("created_at", "date").as("date"),
eb.fn.sum("points").as("score"),
])
.groupBy("date")
.orderBy("date")
.execute();
const rows = await db
.selectFrom("table")
.where("id", "=", "123")
.select((eb) => [
eb.cast<Date | string>("created_at", "date").as("date"),
eb.fn.sum("points").as("score"),
])
.groupBy("date")
.orderBy("date")
.execute();