Select<Type> Help

type Reports = {
    character: typeof characters.$inferSelect & {
        faction: typeof factions.$inferSelect,
        guild: typeof guilds.$inferSelect & {
            faction: typeof factions.$inferSelect
        }
    },
    log: typeof logs.$inferSelect
}
const characterFaction = alias(factions, 'characterFaction')
const guildFaction = alias(factions, 'guildFaction')

const preparedReports = db.select({
    character: {
        ...characters,
        faction: characterFaction,
        guild: {
            ...guilds,
            faction: guildFaction
        }
    },
    log: logs

}) 
//...

type Reports = {
    character: typeof characters.$inferSelect & {
        faction: typeof factions.$inferSelect,
        guild: typeof guilds.$inferSelect & {
            faction: typeof factions.$inferSelect
        }
    },
    log: typeof logs.$inferSelect
}
const characterFaction = alias(factions, 'characterFaction')
const guildFaction = alias(factions, 'guildFaction')

const preparedReports = db.select({
    character: {
        ...characters,
        faction: characterFaction,
        guild: {
            ...guilds,
            faction: guildFaction
        }
    },
    log: logs

}) 
//...