By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE people (
firstname TEXT,
CHECK (firstname LIKE 'ca%')
);
✓
INSERT INTO people VALUES ('Callie');
✓
INSERT INTO people VALUES ('Erik');
{ "code": "SQLITE_CONSTRAINT_CHECK" }