@MDCCL Yeah I'm with you there. I have tried a few others as well, with mixed results. Well actually not mixed at all - they were all terrible.

@AndriyM I like your answer but which DBMS doesn't automatically add column aliases?

@ypercubeᵀᴹ SQL Server doesn't and I thought PostgreSQL didn't either.

Oh maybe it was MySQL. At a guess, Sybase (SAP) products might be in that category as well

I thought all did. Have to check. On the phone now