I'd like to request improved formatting with regards to the queries generated by the dbt_salesforce_formula_utils package.
As data engineers we maintain our DBT models in GIT with several CI/CD checks and reviews before code is approved and merged. A typical tool for checking SQL queries might be something like sqlfluff.
The current version (v0.8.0) of the dbt_salesforce_formula_utils dumps the whole query as a single line. As anybody who has worked with version controlled development will know if everything is on a single line then everything changes every time anything changes.
To assist with best practices I'd like to request that the queries are generated using some type of:
- standard indenting and
- ordering of columns.
This is the only way we can realistically expect our engineers to do a good job of reviewing the changes.