如何将Sqlalchemy核心与文本sql一起用于日期范围？

Question

s = text('SELECT customers.id,WHERE customers.end_date IS NULL or customers.end_date >= '+ "2018-05-01"+ 'AND customers.end_date <='+"2018-05-31" + 'ORDER BY customers.id;')

这会引发语法错误。如何准确传递上述语句中的日期值？如何查找日期字符串？仅使用sqlalchemy core1.0.8版，Python2.7

Answer 1

试试这个：

    s = text('SELECT customers.id WHERE customers.end_date IS NULL or 
   customers.end_date >= \'2018-05-01\' AND customers.end_date 
    <= \'2018-05-31\' ORDER BY customers.id;')