How to translate such a SQL query into SqlAlcemy?

Question

Python

How to translate such a SQL query into SqlAlchemy?

SELECT sub.name, pos.name FROM subscriber sub INNER JOIN position pos
ON sub.position_id = pos.id WHERE sub.name ~* 'какойто текст' OR pos.name ~* 'какойто текст';