Add check constraints at table-alter time

[louwers]

Quoting the documentation.

SQLite3 supports specifying check constraints on the table or on the column definition. We currently only support adding a check constraint via a column definition, since the table definition approach only works at table-creation time and cannot be added at table-alter time.

Just wanted to let you know that as of SQLite 3.53.0 this is possible.

Enhance ALTER TABLE to permit adding and removing NOT NULL and CHECK constraints.

[warmwaffles]

OOO I did not catch that in the release notes. I'll get support for that added soon.

[louwers]

Yeah I am not even a user, but I thought you might want to know. :)