export const sumQuery = db
.select({
sum: sql<number>`cast(sum(${Table.amount}) as integer)`,
})
.from(Table)
.where(
inArray(Table.userId, placeholder("userIds"))
.prepare("sum_query");
// later
const userIds = ['real', 'uuid', 's']
await sumQuery.execute({ userIds });
export const sumQuery = db
.select({
sum: sql<number>`cast(sum(${Table.amount}) as integer)`,
})
.from(Table)
.where(
inArray(Table.userId, placeholder("userIds"))
.prepare("sum_query");
// later
const userIds = ['real', 'uuid', 's']
await sumQuery.execute({ userIds });