ipython_sql_jupyter_sqlite_query_quickstart.py

1# First, install the necessary packages
2# %pip install ipython-sql sqlalchemy
3
4# Load the sql extension
5%load_ext sql
6
7# Connect to a database (using an in-memory SQLite database for this example)
8%sql sqlite://
9
10# Create a table and insert some data
11%%sql
12CREATE TABLE writer (first_name, last_name, year_of_death);
13INSERT INTO writer VALUES ('William', 'Shakespeare', 1616);
14INSERT INTO writer VALUES ('Bertold', 'Brecht', 1956);
15
16# Execute a query
17%sql SELECT * FROM writer;