format output is not a valid SQL

[capaj]

Tested on "sql-formatter": "^4.0.2",

  console.log(
    format(
      `select "users".* from "users" where "users"."id" in where "certification_enrolments"."deleted_at" != 1)`
    )
  )

outputs

select
      "users".*
    from
      "users"
    where
      "users"."id" in
    where
      "certification_enrolments"."deleted_at" ! = 1
    )

expected output:

select
      "users".*
    from
      "users"
    where
      "users"."id" in
    where
      "certification_enrolments"."deleted_at" != 1
    )

the difference is there is not space between ! and =

[pankgeorg]

The same happens with the || operator (concatenation)

[ghenkhaus]

+1 We are seeing this issue as well with = > when the expected output is =>.

[inferrinizzard]

Hi, this issue is fixed in my fork here:
https://github.com/inferrinizzard/prettier-sql
https://www.npmjs.com/package/prettier-sql

[nene]

Fixed now in master branch.