I've always respected PonyORM because of their level of hacking of the python language.

    select(p for p in Product if p.name.startswith('A') and p.cost <= 1000)

PonyORM inspects the AST of the generator, and then translates that to SQL.

I feel like maybe something similar could happen to make the syntax more native for Amaranth.