duckdb_inmemory_quickstart_create_table_and_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
11df = con.sql("SELECT * FROM items").df()
12print(df)