Small. Fast. Reliable.
Choose any three.

create-index-stmt

CREATE UNIQUE INDEX IF NOT EXISTS schema-name . index-name ON table-name ( indexed-column ) , WHERE expr

Used by:   sql-stmt
References:   expr   indexed-column
See also:   lang_createindex.html   partialindex.html