my app is written in Go and I use PgBouncer as a connection pool to my Postgres Database. One downside of PgBouncer, in transaction mode, is that I can't use prepared statements.
So I have 2 options, using session mode (which is bad) or to disable prepared statements from clients.
Is it safe (SQL Injection) to not use prepared statements and use only Parameterized Query (eg.
(Select item from products where id = ? , itemID)
)