Generated YAML and SQL code should conform to dbt Labs style guide

[dbeatty10]

Describe the feature

Any YAML or SQL generated by codegen should adhere to these style guides:

• How we style our YAML
• How we style our SQL

Additional context

See https://github.com/dbt-labs/dbt-codegen/pull/74/files#r944596657 for the instigating thread.

For example, here is our current and original style guides for CTEs (with statement):

• Current
• Original (just for historical context of any changes over time)

Who will this benefit?

This will avoid confusion for users that see one thing recommended as a best practice or adopted style guide, but then see something else auto-generated by this package.

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.