SQlite dialect escapes single quotes wrong, leads to SQL syntax error

[bilcus]

Describe the bug
I didn't have time to do much research but escaping with SQLite does not look right. According to specs, the only thing that needs to be escaped outside of LIKE, GLOB, REGEXP, and MATCH operators are single quotes: ' -> ''. Goqu escapes them wrong ' -> \' and also escapes a lot more then is needed. This leads to bad strings saved to DB or syntax errors in the case of single quotes.

Custom dialect with only these escape runes fixed my issue:

opts.EscapedRunes = map[rune][]byte{
	'\'': []byte("''"),
}

To Reproduce
Add this test to dialect/sqlite3

func (st *sqlite3Suite) TestInsert2() {
	ds := st.db.From("entry")
	now := time.Now()
	e := entry{Int: 10, Float: 1.000000, String: "abc'abc", Time: now, Bool: true, Bytes: []byte("1.000000")}
	_, err := ds.Insert().Rows(e).Executor().Exec()
	st.NoError(err)
}

Output:
Received unexpected error: near "abc": syntax error

Expected behavior
No error.

Dialect:

• postgres
• mysql
• sqlite3