def clause(field, operator, value)
escape_single_quotes = -> field { field.to_s.gsub("'", "\\\\'") }
value = case value
when DateTime, Time
value.iso8601
when Date
value.strftime('%Y-%m-%d')
when Array
value = value.map(&escape_single_quotes)
when true, false
value
else
value = escape_single_quotes.call(value)
end
if operator.downcase == 'in' && value.is_a?(Array)
value = value.map { |v| "#{VALUE_QUOTE}#{v}#{VALUE_QUOTE}" }
"#{field} #{operator} (#{value.join(', ')})"
elsif value == true || value == false
"#{field} #{operator} #{value}"
else
"#{field} #{operator} #{VALUE_QUOTE}#{value}#{VALUE_QUOTE}"
end
end