SQL complex query with aggregation in web2py DAL way

gistfile1.md

Raw SQL

query = '''SELECT COALESCE(SUM(imp), 0) AS imps,
                  COALESCE(SUM(click), 0) AS clicks
           FROM logCuDate
           WHERE id=%s
               AND date >= %s
               AND date <= %s'''
res = db.executesql(query, args, as_dict=True)

web2py DAL

res = (db((db.logCuDate.id == logId) &
          (db.logCuDate.date >= dateStart) &
          (db.logCuDate.date <= dateEnd))
       .select(db.logCuDate.imp.sum().coalesce_zero().with_alias('imps'),
               db.logCuDate.click.sum().coalesce_zero().with_alias('clicks'))
       .as_list())