2 replies

How to include array literals in raw sql?

I have an input array used for an order by using the array_position function - rather than passing the array as a single param, the call to:

.orderBy(sql`array_position(${ingredientNames}, ${entity.name})`);

.orderBy(sql`array_position(${ingredientNames}, ${entity.name})`);

generates a param list for each item in the input array. This generates a record rather than an array literal in Postgres.

Trying raw sql with:

`{${array.map((item) => `'${item}'`).join(",")}}`

`{${array.map((item) => `'${item}'`).join(",")}}`

doesn't work either.