adding support for LEFT JOINs and bitwise comparisons