寻找一种在Golang MySQL中查看插值查询的方法

Question

So, I have a reasonably complicated query which I am trying to debug, but for a simple example let's say I have something like this:

q := "SELECT id FROM users WHERE timestamp > ? AND timestamp < ?"

I will do a Query() on this the usual way, e.g.

db.Query(q, 1546300800,1561127488)

And I would like to log/println/whatever (for debugging) the interpolated query, to end up with

SELECT id FROM users WHERE timestamp > 1546300800 AND timestamp < 1561127488

Wondering if anyone has a trick for me here.

Answer 1

Based on @mkopriva's comments,

Not in Go as it does not do the interpolation, both the query string and the argument values are sent to the db server, which does the interpolation. So if the db server doesn't provide such a feature then you're out of luck. Alternatively you could try searching for a 3rd party package that does the interpolation, however if you find one keep in mind that to be accurate it needs to keep up with the target server's version, if it doesn't do that you may see logs that don't match the actual query being executed

I cannot accomplish this using tooling, as go never has the interpolated query. Sticking to spitting out the non-interpolated query along with the pile of arguments.