I am attempting to use .expert on a database that uses REGEXP to CHECK text fields, but .expert fails with an error. example: >CREATE TABLE "foo" ( "id" INTEGER NOT NULL PRIMARY KEY, "value" TEXT NOT NULL CHECK("value" REGEXP '^[a-z]+$') ); >.expert result: sqlite3_expert_new: no such function: REGEXP The error occurs whether I use the built-in REGEXP or .load the pcre extension. If the CHECK() is omitted then following the above with >SELECT "id" FROM "foo" WHERE "value" IN ('a', 'bcd'); returns an INDEX suggestion. This seems to be a bug. If not then please consider it a feature request.