I have 5 different queries but they all use same select statement, how can i reuse the select to be used in 5 other queries
export const q_get_users = async () => {
const users = await dbk
.selectFrom('users as u')
.select([
'u.pid',
'u.email',
'u.first_name as firstName',
'u.last_name as lastName',
'u.profile_picture_url as profilePictureUrl',
'u.date_of_birth as dateOfBirth',
'u.user_role_type as userRoleType',
'u.user_status as userStatus',
'u.created_at as createdAt',
'u.updated_at as updatedAt',
])
.execute()
return users
}
I just need to re-use the same columns in other 5