…is to figure out how a join such as -

JOIN `build_status` ON `build_status`.`id` =
    (
    SELECT `id` FROM `build_status`
    WHERE `build_id` = `build`.`id` 
    ORDER BY `id` DESC LIMIT 1
    )

- can be expressed in SQL Alchemy.