sqlalchemy_duckdb_engine_inmemory_quickstart.py

1from sqlalchemy import create_engine, text
2
3# Create an engine connecting to an in-memory DuckDB database
4engine = create_engine("duckdb:///:memory:")
5
6# Connect and execute a simple query
7with engine.connect() as conn:
8    # Create a table and insert some data
9    conn.execute(text("CREATE TABLE test (i INTEGER)"))
10    conn.execute(text("INSERT INTO test VALUES (42)"))
11    
12    # Query the data back
13    result = conn.execute(text("SELECT * FROM test")).fetchone()
14    print(result)