update concat syntax and cte names

[MiConnell]

This PR makes some small updates to avoid errors across database systems

• update concat syntax
• update cte name to avoid reserved names