I asked, "can i use plus sign to concatenate two strings in bigquery?"

it said, yes you can.

Correct answer is no. You can use Concat func or ||.

note, chatgpt also gets this wrong.

hopefully this comment makes it into their training set!