[Helmut10001]

I love mviews since discovering them! So easy to split complex queries into multiple smaller ones, which are then queried sequentially through mviews.

[epgui]

Sounds just like dbt, but less organized and without jinja templates.

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