Sqlalchemy how to create a Table Variable table of values ​​(similar to temporary tables)?

Question

Flask

How to do the same on sqlalchemy (orm)?
here is the background https://habr.com/ru/sandbox/22659/
I don’t understand how to make temporary tables and value tables.
the goal is to create a table of values ​​and make an outerjoin into a query in the db

select * from (
values (10,'Акулина')
, (20,'Бронислав')
, (30,'Богдан')
, (40,'Борислав')
) t (tid, tname)