INSERT statements can contain expressions for the values to be inserted for a column. For example, the following INSERT statement can be used to add a timestamp as the primary key for each row being added:
INSERT INTO mytable (col1, col2) VALUES (datetime(‘now’), ‘some string’)
Note: The expressions that can be used as values are limited and cannot contain column names that must be dynamically evaluated.
