> The downside of strict tables is that some data types are not available, such as Date.

There are only 5 datatypes in sqlite. INTEGER, TEXT, BLOB, REAL, and NUMERIC.

https://sqlite.org/datatype3.html

The downside is that you loose the place to store the metadata that a column is supposed to store a date.

Which is why I prefer not to use them.

numeric is not a type it’s an affinity, the underlying types are real and integer. That is why numeric is not valid on strict tables.