[web2py] sub select query help

[SimMode]

All,

How can I formulate this query using dal objects?

select
        customer_name,
        server_name,
        server_type_name,
        application_name,
        application_version,
        install_date
    from customer, server, server_type, application, installation
    where server.customer_id=customer.id
        and server.server_type_id=server_type.id
        and application.customer_id=customer.id
        and installation.server_id=server.id
        and installation.application_id=application.id
        and installation.install_date =
            (select max(install_date) from installation where
application_id=application.id and server_id=server.id)
    order by customer_name, server_name, application_name

Thanks
Simmode