This should be a simple one but can't find which is the configuration option after looking at the documentation.
Example sql:
SELECT
people.id,
people.firstname,
people.lastname,
cities.name
FROM people LEFT JOIN cities ON cities.id = people.cityid WHERE people.firstname IN ('plop', 'zoo')
Output sql:
SELECT
people.id,
people.firstname,
people.lastname,
cities.name
FROM
people
LEFT JOIN
cities ON cities.id = people.cityid
WHERE people.firstname IN ('plop', 'zoo')
Current config in .sqlfluff:
[sqlfluff]
dialect = snowflake
sql_file_exts = .sql
I expect the sql to have the table name in the same line, both for the FROM and LEFT JOIN clauses. (The ON clause can be in the same line or the next one, but indented preferably)
Expected sql:
SELECT
people.id,
people.firstname,
people.lastname,
cities.name
FROM people
LEFT JOIN cities ON cities.id = people.cityid
WHERE people.firstname IN ('plop', 'zoo')
Can anyone point me to the right setting?