Wrap an array so it is bound as a single parameter rather than expanded for IN clauses. Generates PostgreSQL's = ANY(?) syntax.
const statuses = ['active', 'pending'];const query = sql`${entityField('status')} = ANY(${arrayValue(statuses)})`;// Generates: ?? = ANY(?) with the array bound as a single parameter Copy
const statuses = ['active', 'pending'];const query = sql`${entityField('status')} = ANY(${arrayValue(statuses)})`;// Generates: ?? = ANY(?) with the array bound as a single parameter
Wrap an array so it is bound as a single parameter rather than expanded for IN clauses. Generates PostgreSQL's = ANY(?) syntax.