If it contains the "?" character, gdb.Raw generates an error SQL

[lijianbj]

What version of Go and system type/arch are you using?
go version go1.21.4 darwin/arm64

What version of GoFrame are you using?
v2.5.7

Can this bug be re-produced with the latest release?
yes

What did you do?

setting := g.Map{
		"url": "https://www.xxx.com?v=2.3",
	}
	data := g.Map{
		dao.Client.Columns().Setting: gdb.Raw(fmt.Sprintf("%s||'%s'", dao.Client.Columns().Setting, gjson.New(setting).MustToJsonString())),
	}
	if _, err := dao.Client.Ctx(ctx).Update(data, dao.Client.Columns().Id, req.ID); err != nil {
		return err
	}

What did you expect to see?
Looking forward to the success of the execution

What did you see instead?
Bad SQL was generated：The character "?" cannot be parsed。Remove the “?” character to execute successfully

UPDATE "client" SET "updated_at"='2024-04-20 21:09:25',"setting"=setting||'{"url":"https://www.xxx.com81346976072401993v=2.3"}' WHERE ("id"=$3) AND "deleted_at" IS NULL
Error: pq: could not determine data type of parameter $2

[oldme-git]

@lijianbj You have to use correct SQL value that Go Standard library can accept.

setting := g.Map{
	"url": "https://www.xxx.com?v=2.5",
}
ss := gjson.New(setting).MustToJsonString()
ss = strings.Replace(ss, "\"", "\\\"", -1)

data := g.Map{
	"setting": gdb.Raw(fmt.Sprintf("\"%s||'%s'\"", "setting", ss)),
}