Alias replacement not taking account multiple lines

[talski]

I'm using snake case, when using multiple lines ``, sometimes the column/table alias do not get replaced.

The first myModel.studentId, just before the or, do not get replaced in this example

this will not work

.innerJoin(MyModel, 'myModel', 'myModel.foreignId = another.foreignId')
.leftJoin(
  Message,
  'msg',
  `
  msg.receiverType = :userType and msg.receiverId = :userId and
  msg.senderType = 'Something' and msg.senderId = myModel.studentId
  or
  msg.receiverType = 'Something' and msg.receiverId = myModel.studentId and
  msg.senderType = :userType and msg.senderId = :userId
`
)

this one will

.innerJoin(MyModel, 'myModel', 'myModel.foreignId = another.foreignId')
.leftJoin(
  Message,
  'msg',
  `
  msg.receiverType = :userType and msg.receiverId = :userId and
  msg.senderType = 'Something' and msg.senderId = myModel.studentId or
  msg.receiverType = 'Something' and msg.receiverId = myModel.studentId and
  msg.senderType = :userType and msg.senderId = :userId
`
)

using .replace(/\s+/g, ' ') will also work

[akashjobanputra]

@talski I'm facing a similar issue, did you find a way to fix the issue?

[talski]

@akashjobanputra I'm just removing the spaces before running the query

.innerJoin(MyModel, 'myModel', 'myModel.foreignId = another.foreignId')
.leftJoin(
  Message,
  'msg',
  `
  msg.receiverType = :userType and msg.receiverId = :userId and
  msg.senderType = 'Something' and msg.senderId = myModel.studentId or
  msg.receiverType = 'Something' and msg.receiverId = myModel.studentId and
  msg.senderType = :userType and msg.senderId = :userId
`.replace(/\s+/g, ' ')
)

putting this code .replace(/\s+/g, ' ') will replace all new lines with a simple space