fix left_outer_joins, it was building queries with inner joins, add better tests for outer joins