insert using select that has a non string column

[shreyaspurohit]

Hello,

DB Fiddle for the example: https://www.db-fiddle.com/f/wpNmAGWfjWoZS4goc8EWfc/0

I was trying to generate a SQL like -

INSERT INTO test(id, data_id, type, deleted_at)
SELECT 10, data_id, type, deleted_at
FROM test
WHERE id=7

using -

                 sourceID:=7
                 targetID:=10
		sql, args, err := sb.Insert("test").
			Columns("id", "data_id", "type", "deleted_at").
			Select(
				sb.Select(targetID, "data_id", "type", "deleted_at").From("test")
					Where(squirrel.Eq{
						"id": sourceID,
					}),
			).
			ToSql()

when I realized that the select column needs to be of string type. Is there a way to generate this query where select is having a non string value. Or is there some other way to handle this use case?

Thank you for any help!