tursodatabase / libsql-experimental-python

libSQL API for Python (experimental)
88 stars 10 forks source link

Support list of values for positional bound parameters #2

Open CodingDoug opened 1 year ago

CodingDoug commented 1 year ago

In sqlite3, this works as you would expect (list of values in square brackets vs. tuple in parens):

cur.execute("INSERT INTO users VALUES (?, ?)", [1, 'alice@example.org'])

In libsql, this yields the error:

TypeError: argument 'parameters': 'list' object cannot be converted to 'PyTuple'

PrinceBaghel258025 commented 2 months ago

using dagster to do some analytics and pandas.to_sql basically raises same error as underlying db is turso.