Try to implement where case filtering in nodes when performing SELECT statements. So when we have SELECT a, b, c FROM table1 JOIN table2 ON table1.id = table2.id WHERE table1.prop1 > 5 and table2.prop2 < 2
then we should get data from nodes using SELECT a, b,c FROM table1 WHERE table1.prop > 5 and SELECT a, b, c FROM table2 WHERE table2.prop2 < 2
it can be tricky but try even partially implement it, in to difficult cases use default SELECT * FROM table
Try to implement where case filtering in nodes when performing SELECT statements. So when we have SELECT a, b, c FROM table1 JOIN table2 ON table1.id = table2.id WHERE table1.prop1 > 5 and table2.prop2 < 2 then we should get data from nodes using SELECT a, b,c FROM table1 WHERE table1.prop > 5 and SELECT a, b, c FROM table2 WHERE table2.prop2 < 2 it can be tricky but try even partially implement it, in to difficult cases use default SELECT * FROM table