near "?": syntax error in "INSERT INTO "users" (?) VALUES (?)"

[meili19916]

When I run the demo to insert a email,it failed with error "near "?": syntax error in "INSERT INTO "users" (?) VALUES (?)""; Xcode 16.1 iphone os 17.3.1 pod 'SQLite.swift', '~> 0.14.0'

[soognarf]

i hav the same problem and this was tricky. Expression from swift will have Expression(value:VARX) and SQLite Expression will have Expression(VARX) i have first my code changed from swift 15 to swift 16 and have added value: to the function. then i have added for SQLite the prefix SQLIte. so was my code SQLite.Expression(value:VARX). this gives no error on compile but the SQLite function read only unnamed parameters and so hi has not initalized the name of my column. that gives exact the same output like yours. the right version is : SQLite.Expression(VARX)

[bradleyboyd]

I have the same issue. Did you have to revert to Xcode 15 to resolve it?

[soognarf]

no, i am on Xcode 16

[bradleyboyd]

Oh, I get it now. You changed 'Expression(VARX)' to 'SQLite.Expression(VARX)'. Thanks!