Actually it would make more sense if we also create a feature of reordering joins.
example of issue
from one to two
from two to three
from three to four
from four to five
it could produce joins in this order:
left join two on two.one_id= one.id
left join three on three.two_id= two.id
left join five on five.four_id = four.id
left join four on four.three_id = three.id
and error message which says that there is no four.id in field list
Actually it would make more sense if we also create a feature of reordering joins.
example of issue
from one to two from two to three from three to four from four to five
it could produce joins in this order: left join two on two.one_id= one.id left join three on three.two_id= two.id left join five on five.four_id = four.id left join four on four.three_id = three.id
and error message which says that there is no four.id in field list