Miscellany

WHERE orders."obliterateDate" IS 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"    )