Support CHECK constraint as in (or close to) SQL Standard.
The following syntaxes will be supported (they are already supported by the current MariaDB parser, but does nothing):
As part of column definition:
CREATE TABLE t1 (a int check (A > 10));
As an independent constraint:
CREATE TABLE t1 (a int, constraint `A` CHECK (A > 10));
ALTER TABLE DROP CONSTRAINT `A`;