Spanner supports creating secondary indexes based on scalar expressions that apply to one or more table columns.

Spanner supports creating secondary indexes based on scalar expressions that apply to one or more table columns. Expression indexes eliminate the need to create and maintain a dedicated generated column in your table for indexing purposes. For more information, see Create an index based on a scalar expression.