# Introducing sqlfmt, an auto-formatter for dbt SQL

**URL:** <https://discourse.getdbt.com/t/introducing-sqlfmt-an-auto-formatter-for-dbt-sql/3687>\
**Category:** Show and Tell\
**Tags:** sqlfmt\
**Created:** [January 27, 2022, 3:18am UTC](https://discourse.getdbt.com/t/introducing-sqlfmt-an-auto-formatter-for-dbt-sql/3687 "2022-01-27T03:18:29Z")\
**Posts on this page:** 3\
**Page:** 2

<div class="post-metadata">

**Author:** ![manon\_bijenkorf](https://avatars.discourse-cdn.com/v4/letter/m/7ba0ec/32.png) [@manon\_bijenkorf](https://discourse.getdbt.com/u/manon_bijenkorf)\
**Post date:** [April 12, 2023, 7:48am UTC](https://discourse.getdbt.com/t/introducing-sqlfmt-an-auto-formatter-for-dbt-sql/3687/21 "2023-04-12T07:48:54Z")

</div>

Oops my bad. Now it works wonderful 😃 This was very confusing though. But really nice work!!

---

<div class="post-metadata">

**Author:** ![manon\_bijenkorf](https://avatars.discourse-cdn.com/v4/letter/m/7ba0ec/32.png) [@manon\_bijenkorf](https://discourse.getdbt.com/u/manon_bijenkorf)\
**Post date:** [April 12, 2023, 7:10pm UTC](https://discourse.getdbt.com/t/introducing-sqlfmt-an-auto-formatter-for-dbt-sql/3687/22 "2023-04-12T19:10:59Z")

</div>

I only noticed that sqlfmt does not only use lowercase keywords but makes everything lowercase. So if I have something like “select reportDateLastYear from calendar” it will turn into “select reportdatelastyear from calendar”. This makes it very unreadable for me. Is there a reason for this?

---

<div class="post-metadata">

**Author:** ![ted.conbeer](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/ted.conbeer/32/42_2.png) [@ted.conbeer](https://discourse.getdbt.com/u/ted.conbeer)\
**Post date:** [April 12, 2023, 9:14pm UTC](https://discourse.getdbt.com/t/introducing-sqlfmt-an-auto-formatter-for-dbt-sql/3687/23 "2023-04-12T21:14:17Z")

</div>

> **[Consider not lowercasing column names · tconbeer/sqlfmt · Discussion #229](https://github.com/tconbeer/sqlfmt/discussions/229#discussioncomment-3311467)**
>
> We use bigquery, which supports column names in mixed case though doesn't allow names which differ only in case: https://cloud.google.com/bigquery/docs/schemas#column\_names A column name must conta...

[Previous page](https://discourse.getdbt.com/t/introducing-sqlfmt-an-auto-formatter-for-dbt-sql/3687.md?page=1)