duckdb_python_api_quickstart_inmemory_table_query.py

1import duckdb
2
3# Create a connection to an in-memory database
4con = duckdb.connect(database=':memory:')
5
6# Create a table from a Python object (Pandas, Lists, etc.)
7con.execute("CREATE TABLE items (id INTEGER, name VARCHAR)")
8con.execute("INSERT INTO items VALUES (1, 'apple'), (2, 'banana')")
9
10# Query the database and fetch the result as a data frame or tuple list
11result = con.execute("SELECT * FROM items WHERE id > 1").fetchall()
12
13# Print the result
14print(result)
15
16# You can also run queries directly on CSV/Parquet files
17# con.execute("SELECT * FROM 'data.csv'").show()