Update code gen tools

[mc738]

Is your feature request related to a problem? Please describe. Update generation tools to support the following:

• Escaping via backticks so names like sum don't cause issues.
• Add table prefix, so id becomes [table_name].id, making join queries easier.

Describe the solution you'd like Implement this, it should be relatively easy and add robustness.

Describe alternatives you've considered None.

Additional context None at the moment, if I think of any other good enhancements to the code gen tools I will add them.

[mc738]

Closing for now as both features have been added.