Support for check constraints?

[SackCastellon]

Is there any plan to support check constraints in the future?

Suggestion

Method signature

/**
 * Creates a check constraint in this column
 * @param name The name of the constraint, optional
 * @param op The expression that the value of this column must satisfy
 */
fun <T> Column<T>.check(name: String = "", op: SqlExpressionBuilder.(Column<T>) -> Op<Boolean>): Column<T> { ... }

Usage

object CheckTable : Table("myTable") {
    val id = integer("id").autoIncrement().primaryKey()
    val positive = integer("positive").check { it greaterEq 0 }
    val oneToTen = integer("oneToTen").check("myCheck") { it.between(1, 10) }
    val greaterThanId = integer("greaterThanId").check { it.greater(id) }
}

SQLite Output

CREATE TABLE IF NOT EXISTS myTable (
  id INTEGER PRIMARY KEY,
  positive INT NOT NULL CHECK (positive >= 0),
  oneToTen INT NOT NULL CONSTRAINT myCheck CHECK (oneToTen BETWEEN 1 AND 10),
  greaterThanId INT NOT NULL CHECK (greaterThanId > id)
);