SQLAlchemy - using column in LIKE

Question

Is it possible to do this

select x.name, y.name, y.info
from tag x
join tag y
on y.info like '%#' || x.name || '#%';

with SQLAlchemy? I found examples using LIKE, but only with literals (from the SQL point of view).

Answer 1

session.query(x).join(y).filter("y.info LIKE '%#'||x.name||'#%'").all()