Parentheses in STIX patterns using properties outside projected entity causes error

[pcoccoli]

Passing a STIX pattern such as [(url:value LIKE '%page/1%' AND x-oca-asset:hostName LIKE 'pc%')] to extract with a different entity type would generate invalid SQL:

ERROR    firepit.sqlitestorage:sqlitestorage.py:165 CREATE VIEW "nt" AS SELECT "network-traffic".* FROM "network-traffic" WHERE "id" IN (SELECT "network-traffic".id FROM "network-traffic"  INNER JOIN __queries ON "network-traffic".id = __queries.sco_id  WHERE query_id = 'q1' AND (()));: near ")": syntax error