Вот пример кода:
battle.heroes = [{ id: hero.id, name: hero.name }]; //This is my array I want to insert
await db.one('INSERT INTO battles(mode, params, heroes) VALUES(${mode}, ${params}, ${heroes}) RETURNING id', {
mode: battle.mode,
params: battle.params,
heroes: battle.heroes,
});
Тип PostgreSQL 'hero_info':
id int4
name varchar