The fact that the advisor in the OP changed their stories multiple times indicates duplicity. Your inability to see that, coupled with an abrupt allegation against the journalist suggests self-deception
0 karma · joined August 6, 2021
You should offload that onto DBT or some other data modeling tools.