8.36. SQLAlchemy Query Subquery — Python
Subquery
CTE - Common Table Expressions
https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.subquery