Prepared(true) does not work with postgres

[veqryn]

Describe the bug
When using .Prepared(true) it replaces the interpolated arguments with ?, even though Postgres is expecting $1, $2, etc.

Expected behavior
I expect it to use the correct parameter format.

Dialect:

• postgres
• mysql
• sqlite3

Additional context

1. Why is interpolation the default?
2. Why did goqu go to all the trouble to write an interpolation layer, when every database takes parameters? It seems much much safer to let Postgres do the interpolation, rather than just a library to do it.

[OriBenZaken]

We also encountered this issue on our team.
This fix is very much needed, please.

[filipencopav]

Try adding

import _ "github.com/doug-martin/goqu/v9/dialect/postgres"

At the top of your file and see if it creates $1, $2, $3 etc.

[nickzelei]

Echoing filipencopav, this is generally an issue when you haven't imported the postgres dialect. Goqu falls back to the ? arguments when it does not detect an imported driver.

[veqryn]

Why is interpolation the default?
Why did goqu go to all the trouble to write an interpolation layer, when every database takes parameters? It seems much much safer to let Postgres do the interpolation, rather than having a 3rd party library to do it.

[denizgursoy]

I had the same @filipencopav solution worked