DO NOT USE THIS INSTANCE FOR LIVE DATA!!!!
Right now, the join clause is empty if bridge table flattening columns is enabled for chain ref columns.