如何使用RawSQL注释字段?
sql_query = """
SELECT
c.id,
COALESCE(SUM((cm.temp_min + cm.temp_max) / 2 - %s), 0) AS gdd
FROM
agriculture_commune c
LEFT JOIN
agriculture_communemeteo cm ON c.id = cm.commune_id
WHERE
cm.date BETWEEN %s AND %s
GROUP BY
c.id
"""
communes = communes.raw(sql_query, [TBASE, start_date, end_date])
如果我试着这样做,
communes.annotate(gdd=RawSQL(sql_query, [TBASE, start_date, end_date]))
我得到错误"子查询必须只返回一个列\n行1:... mmune "