DuckDB


1
2
3
4
5
6
!uv pip install -q \
    pandas==2.3.3 \
    matplotlib==3.10.7 \
    duckdb==1.4.1 \
    duckdb-engine==0.17.0 \
    jupysql==0.11.1

import duckdb
import pandas as pd
import warnings

warnings.filterwarnings("ignore", category=SyntaxWarning)

%config SqlMagic.autopandas = True
%config SqlMagic.feedback = False
%config SqlMagic.displaycon = False

%load_ext sql
conn = duckdb.connect(":memory:")
%sql conn --alias duckdb

%sql SELECT 'Off and flying!' AS a_duckdb_column;
a_duckdb_column
0 Off and flying!