duckdb_quickstart_in_memory_table_create_insert_query.py

1import duckdb
2
3# Connect to an in-memory database
4con = duckdb.connect()
5
6# Create a table and insert some data
7con.sql("CREATE TABLE items (item VARCHAR, value INTEGER)")
8con.sql("INSERT INTO items VALUES ('apple', 42), ('banana', 84)")
9
10# Query the table and display the results
11result = con.sql("SELECT * FROM items").fetchall()
12print(result)
13
14# DuckDB can also query data directly from variables (e.g., lists of dicts)
15items_list = [{"item": "cherry", "value": 126}]
16print(duckdb.query("SELECT * FROM items_list").fetchall())