How to log and get query?

[ansidev]

I want to get the following data:

• Prepared statement.
• Passed values.
• Query with bind value.

Currently, I find no way to do these things.

[meddulla]

I use this:

func getRawQuery(query *dbr.SelectBuilder) (string, error) {
	buf := NewBuffer()
	err := query.Build(dialect.ClickHouse, buf)
	if err != nil {
		return "", err
	}
	qstr := buf.String()
	return dbr.InterpolateForDialect(qstr, buf.Value(), dialect.ClickHouse)
}``` 

[zilan920]

You can refer to

// TracingEventReceiver is an optional interface an EventReceiver type can implement
// to allow tracing instrumentation
type TracingEventReceiver interface {
	SpanStart(ctx context.Context, eventName, query string) context.Context
	SpanError(ctx context.Context, err error)
	SpanFinish(ctx context.Context)
}

Create a EventReceiver and implement this