SqlAlchemy: count of distinct over multiple columns

The exact query can be produced using the tuple_() construct:

session.query(
    func.count(distinct(tuple_(Hit.ip_address, Hit.user_agent)))).scalar()