attackers_by_reason_db: List[AlertModel] = db.session.query(AlertModel).filter(
        AlertModel.timestamp >= start_datetime, AlertModel.timestamp <= end_datetime
    ).group_by(AlertModel.id, AlertModel.source_ip).order_by(AlertModel.reason).distinct().all()

sqlalchemy.exc.ProgrammingError: (psycopg2.errors.GroupingError) column "alerts.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 2: FROM (SELECT DISTINCT alerts.id AS alerts_id, alerts.alert_i...