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")