Hacker News new | ask | show | jobs
by Helmut10001 1289 days ago
I write my SQL queries in Jupyter Lab, mixed in Python code and f-strings, which is enough of a template engine to my needs atm. I can also directly visualize stuff with pandas (etc.)

    species: str = 'acer'
    structure: str = 'trees.table'
    query = f"""
    SELECT * FROM {structure} WHERE species = {species}
    """