tconbeer / sqlfmt

sqlfmt formats your dbt SQL files so you don't have to
https://sqlfmt.com
Apache License 2.0
390 stars 16 forks source link

feat(join-lint): handle left anti join #607

Closed clenost closed 2 months ago

clenost commented 2 months ago

Hey 👋 A small addition to the current formatter (thanks for the work done there 👌 ).

Main idea is to handle better left anti joins that are defined within databricks

before

select
...
from table_a left
anti join table_b using(key)

after

select
...
from table_a
left anti join table_b using(key)

Feel free to tell me if you want me to modify the content of this PR 🙏