ColumnIndexOptions.expression property

Indexes this SQL expression rather than the column.

Signature:

expression: string;

Remarks

For filtering on a computed value — lower("email") being the standard case, which nothing but an expression index can serve. Raw SQL, and it replaces the column as the key rather than joining it.