sqlite_query.py

import pandas as pd
from sqlalchemy import create_engine

engine = create_engine("sqlite:///sample.db")

# Option one
with engine.connect() as connection:
    results = connection.execute("""
        SELECT column1, column2, column3
          FROM table_name
    """)
    df = pd.DataFrame(results.fetchall())
    df.columns = results.keys()
    
# Option two, my favorite
df = pd.read_sql_query("""
    SELECT column1, column2, column3
      FROM table_name
""", engine)