A SQL query runner using Pandas

sql.py

# A SQL query runner using Pandas

# pip install pandas tabulate sqlalchemy

import pandas as pd
from tabulate import tabulate
# import sqlite3

df = pd.read_sql(
    "select name, downloaded, serial from projects limit 20",
    "sqlite:///PyPI.db"
    # sqlite3.connect("PyPI.db")
)
print(tabulate(df, headers='keys', tablefmt='psql'))