奇怪的Golang SQL错误-WHERE子句

Question

I am running a query in Golang, using the sqlx library:

rows, dbErr := db.Queryx(`
    SELECT *
    FROM table_a as a
       INNER JOIN table_b AS b
          ON a.b_id = b.id
       WHERE b.id = 'b3c06feb-8bd1-42e1-b516-c1121990ff81';
    `)

The query is syntactically correct, and runs fine in Postico, terminal, etc. However when I try to run this query in Golang I get the error pq: syntax error at or near "  WHERE"

Can anyone explain this strange behaviour?

Answer 1

The issue was outdated dependencies. We had to update our Golang sql libraries.

Thank you to everyone who submitted suggestions.