any join syntax with clickhouse moves up to the previous line
bug
**Describe the bug**
Doing any joins in clickhouse put the join keywords on the line above. I find it helpful to have the join modifier keywords on the same line.
**To Reproduce**
Given the follow clickhouse dialect sql
```
[tool.sqlfmt]
dialect = "clickhouse"
```
```sql
select color_of_the_garden, plant_in_the_garden, place_in_the_garden
from garden_full_of_flowers
left any join bugs_in_the_garden on (garden_full_of_flowers.place = bugs_in_the_garden.place)
```
**Expected behavior**
```sql
select color_of_the_garden, plant_in_the_garden, place_in_the_garden
from garden_full_of_flowers
left any join bugs_in_the_garden on (garden_full_of_flowers.place = bugs_in_the_garden.place)
```
**Actual behavior**
```sql
select color_of_the_garden, plant_in_the_garden, place_in_the_garden
from garden_full_of_flowers left any
join bugs_in_the_garden on (garden_full_of_flowers.place = bugs_in_the_garden.place)
```
It moved the "left any" up to the line above.
**Additional context**
I am using this with precommit
```
- repo: https://github.com/tconbeer/sqlfmt
rev: v0.27.0
hooks:
- id: sqlfmt
language_version: python
additional_dependencies: ['.[jinjafmt]']
```
关闭于 2025-10-17 7 条评论