exposed-core/org.jetbrains.exposed.sql.vendors/SQLiteDialect/createIndex

createIndex

open override fun createIndex(index: Index): String

Uniqueness might be required for foreign key constraints.

In PostgreSQL (https://www.postgresql.org/docs/current/indexes-unique.html), UNIQUE means B-tree only. Unique constraints can not be partial Unique indexes can be partial