Make it so that Freehand SQL doesn't remove joins
I have a requirement and the only way I can think of how to solve it is to use a common table expression. I cannot create one in a view. It can only be created in a freehand report. I have to make the CTE very simple and FINAL because any change to it and the entire report goes away. I'm only using it to pull in 3 columns and then I left join a view. Maybe there's a way to solve my issue without a CTE but I cannot think of one.