SQLite Forum

DROP TABLE failure - is it intentional or a bug?
`modified DATETIME AS (datetime(julianday())) STORED`

Note that this will not work in versions of SQLite3 3.35.2 and later as the datetime functions that return 'now' (datetime(), julianday(), strftime(format), current date, current time, current_timestamp) are no longer permitted in computed columns.

You now must use triggers to achieve the same effect.

Also, there is no such datatype as `DATETIME`, `BOOLEAN` or `BIGINT` and that they will be NUMERIC, NUMERIC, and INTEGER respectively.