having clause

[YuriFontella]

hello, I'm trying to create this sql query but there is no having function in the orm, I already looked for a solution in the documentation and in the discussions and issues

What is the best way to implement this?

    """
    select
        customer_id,
        count(distinct date_trunc('day', played_date)) as days
    from tickets
    where
        played_date between '' and ''
    group by customer_id
    having count(distinct date_trunc('day', played_date)) > 2
    """

    response = await (
        Tickets
        .select(Raw("count(distinct date_trunc('day', played_at)) as days"))
        .where(And(Tickets.played_date > start, Tickets.played_date < end))
        .group_by('customer_id')
        .having() # Unresolved attribute reference 'having' for class 'Select' 
        .columns('customer_id', 'days')
    )

    return response

[dantownsend]

You could do something like this:

query = (
    Tickets
    .select(Raw("count(distinct date_trunc('day', played_at)) as days"))
    .where(And(Tickets.played_date > start, Tickets.played_date < end))
    .group_by('customer_id')
    .columns('customer_id', 'days')
)

response = await Tickets.raw('{} HAVING ...', query.querystrings[0]))

It shouldn't be too hard to add a having clause to Piccolo - will create an issue from this discussion.

[YuriFontella]

I believe it will work, but it seems like a good concept.
The having clause in piccolo will be very good.