I'm having really hard time understanding my SQL errors because I cannot copy & paste logged queries in my IDE because the parameters are not converted from placeholders.
It prints:
SELECT * from players where team_id = $1 AND id = $2
but I would like the below instead:
SELECT * from players where team_id = 'ABC' AND id = '123'
You’ll have to log the parameters yourself and use them with PREPARE. sqlx never creates the query you’re trying to log - it uses parameterization as well, so the query you’re seeing logged really is the query sent to the DB.