We currently don't support BETWEEN checks in our column constraints. This breaks the UI for a tables like these:

CREATE TABLE not_working(
    value INT CONSTRAINT "value" CHECK(value BETWEEN 1 AND 5)
);

Keeping issue #40 in mind, it is also worth pointing out that the BETWEEN can also be negated:

CREATE TABLE not_working(
    value INT CONSTRAINT "value" CHECK(value NOT BETWEEN 1 AND 5)
);