Sentences like orders.WHERE((order_status != None) & (total_price>1000)) turn the SQL WHERE into NULL
SELECT
orders.o_orderstatus AS order_status,
customer.c_name AS cust_name,
orders.o_orderkey AS order_num
FROM main.orders AS orders
JOIN main.customer AS customer
ON customer.c_custkey = orders.o_custkey
WHERE
NULL
Functions like PRESENT and ABSENT can be used. However using X == None or X != None should give an error or even better, be translated to X IS [NOT] NULL.