PonyORM does something similar in Python:

    select(c for c in Customer if sum(c.orders.total_price) > 1000)

I love the hackiness of it.

▲ porridgeraisin 4 days ago | parent [-]

PonyORM is my favourite python ORM.

Along with https://pypi.org/project/pony-stubs/, you get decent static typing as well. It's really quite something.

	▲	rafaelgoncalves 4 days ago \| parent [-]
		whoa, didn't know PonyORM, looks really neat! thanks for showing