import duckdb
import traceback
db = duckdb.connect("mydb.db")
db.execute("""
create sequence id_seq start 1;

create table cool_numbers (
 id integer default nextval('id_seq') primary key,
 number int
);
""")
try:
 db.table("cool_numbers").insert((42,))
except Exception:
 print(traceback.format_exc())
try:
 db.table("cool_numbers").insert((None, 42))
except Exception:
 print(traceback.format_exc())
try:
 db.table("cool_numbers").select("number").insert((42,))
except Exception:
 print(traceback.format_exc())

Traceback (most recent call last):
 File "/home/frankier/edu/rse/apitofsim/duckdbinsertpls.py", line 16, in <module>
 db.table("cool_numbers").insert((42,))
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^
_duckdb.BinderException: Binder Error: table cool_numbers has 2 columns but 1 values were supplied
Traceback (most recent call last):
 File "/home/frankier/edu/rse/apitofsim/duckdbinsertpls.py", line 21, in <module>
 db.table("cool_numbers").insert((None, 42))
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^
_duckdb.ConstraintException: Constraint Error: Failed to insert into table 'cool_numbers': NOT NULL constraint failed: cool_numbers.id
Traceback (most recent call last):
 File "/home/frankier/edu/rse/apitofsim/duckdbinsertpls.py", line 26, in <module>
 db.table("cool_numbers").select("number").insert((42,))
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^
_duckdb.InvalidInputException: Invalid Input Error: 'DuckDBPyRelation.insert' can only be used on a table relation