I’m having problems with WITH statements creating time outs and failed queries. A query runs fine on its own but if I put it in a WITH statement and do SELECT * FROM <withname> it dies. Is this a known issue?

Yes, I think I've always had to specify all of the column names in query when using WITH parameter. I don't remember why that's the case.

☝️ same here