Using column aliases in `.where()`

This is a supported feature in MySQL, but having issues here:
https://kyse.link/?p=s&i=xxyMrfnfJ6CjbRlQZpMA

Do I need to do something special for it to recognize the alias?

i may have seen the You can use the alias in GROUP BY, ORDER BY, or HAVING clauses to refer to the column part of that page and jumped the gun

woops, sorry

no worries