many-to-one transaction with select API and Postgres

export const game = pgTable('game', {
    id: varchar('id', { length: 21 })
        .primaryKey()
        .default(sql.raw(`generate_pri('${ID_PREFIXES.game}')`)),
});

export const game_config = relations(game, ({ one, many }) => ({
    goals: many(goal),
}));

export const goal = pgTable('goal', {
    id: varchar('id', { length: 21 })
        .primaryKey()
        .default(sql.raw(`generate_pri('${ID_PREFIXES.goal}')`)),
    number: serial('number'),
    event_player_id: varchar('event_player_id', { length: 21 }).references(() => event_player.id),

    game_id: varchar('game_id', { length: 21 }).references(() => game.id),
});

export const goal_config = relations(goal, ({ one }) => ({
    game: one(game, {
        fields: [goal.game_id],
        references: [game.id]
    })
}));