working sql query, how to make this with sqlalchemy?

sqlalchemy_conversion

    sql_text = '''SELECT *
      FROM
        CompetitionTeams ct
      INNER JOIN
        Teams t ON ct.teams = t.id
      WHERE
        ct.competitions = {}'''.format(comp)
    result = db.engine.execute(sql_text)