WHERE 
orders."obliterateDate" IS NULL 
AND orders."deliveryDate" <= %(orders_deliveryDate_1)s 
AND orders."closeDate" IS NULL 
AND (
  orders.id = %(orders_id_1)s 
  OR orders."deliveryDate" IS NOT NULL 
  AND to_char(orders."deliveryDate", %(to_char_1)s) LIKE %(to_char_2)s 
  OR upper(customers.name) LIKE %(upper_1)s
  AND customers.id = orders."customerID" 
  OR (
    upper(addresses.street) LIKE %(upper_2)s 
    OR upper(addresses.extra) LIKE %(upper_3)s 
    OR upper(addresses.name) LIKE %(upper_4)s 
    OR upper(addresses.area) LIKE %(upper_5)s 
    OR upper(addresses."zipCode") LIKE %(upper_6)s 
    OR upper(addresses.city) LIKE %(upper_7)s 
    OR upper(addresses.country) LIKE %(upper_8)s
  ) 
  AND addresses.id = orders."deliveryAddressID"
)