The table value constructor enables users to insert multiple rows within a single INSERT operation. This avoids unnecessary additional INSERT executions and roundtrips from and to the client for ...

Attempting to insert multiple rows without explicitly specifying this column will fail. e.g.: DBError: (sqlite3.ProgrammingError) Incorrect number of bindings supplied. The current statement uses 20, ...