So what I’m trying to do is take an array of objects that are similar to the rows stored in the db (minus the id since that’s auto-generated). However, I can’t seem to figure it out. I’m using node-postgres. It would go something like this

const fooObj:Omit<Food, fooId> = {
   // foodId omitted
   a: 'a',
   b: 'b',
   c: 'c'
}

const fooArr = [...] // array of above Foo objects

const {rows} = pool.query(format(
`
 INSERT INTO "foo" ("a","b","c")
 VALUES // insert properties into column from each obj in fooArr //
 RETURNING *
`,fooArr
))