In python I found that using conn.execute with an INSERT query had no effect, but my code proceeded as if everything was fine. When I try to insert into that table in the TURSO GUI I get the error shown in this screenshot. libsql-experimental-python should raise a python error of some kind so that python knows something is wrong, rather than simply behaving as if the query was executed correctly.
