Investigate the original reasons why ColumnStore is flagging "circular joins" as an error, and provide guidance as to how to stop it from happening.

SELECT * FROM a,b,c WHERE a.fk=b.PK and b.FK=c.PK and a.FOO = c.FOO

For historical reasons (nolonger known) ColumnStore is unable to do what every other relational databases do - break the loop in the join graph, and treat one of cross-table clauses as a filter as opposed to join condition (we are talking about b.FK=c.PK vs a.FOO=c.FOO - one of them has to be dropped from the join graph and become a post join filter).

This task is to figure out why it has not been done (if possible), and figure out how to solve it in the safest manner.