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, ...
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 ...