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.

Read this page as plain markdown — no HTML, no navigation. For pasting into an LLM, or for an agent to fetch.