[adammarples]

People who don't use dbt usually have a half baked implementation they wrote themselves in python

[Helmut10001]

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}
    """