search

Masterminds / squirrel

Fluent SQL generation for golang
Other
6.88k stars 465 forks source link

Sql doesn't match for SignleStore #350

Open DedicatedDev opened 1 year ago

DedicatedDev commented 1 year ago

I'm trying to use this library for SingleStore MySQL DB. By Insertbuilder, I've got this query string. 

pgQb().Insert("hello").Columns("user_id", "name").Values(
        3, "test"
)

INSERT INTO hello(user_id, name) VALUES ($1,$2) [3 "test"]

Here is a valid query in SingleStore. INSERT INTO hello(user_id,name) VALUES (2, 'test323'); If I run this query in the SingleStore query field, it shows an error.

Looking forward to hearing the solution soon. Best.