Expression fails when Field Contains a Number about sqlite.swift HOT 3 CLOSED

When was the last time you updated your SQLite.swift submodule? I can get the following to run just fine on master:

let db = Database()
db.trace(println)
let users = db["users"]
let field = Expression<String>("19500301_OFF")

db.create(table: users) { $0.column(field) }
users.insert(field <- "Hello")!
for user in users.select(field) {
    println(user[field])
}

Console output:

CREATE TABLE "users" ("19500301_OFF" TEXT NOT NULL)
INSERT INTO "users" ("19500301_OFF") VALUES ('Hello')
SELECT "19500301_OFF" FROM "users"
Hello

from sqlite.swift.

Ah, you know what, I think your issue is in your raw SQL syntax:

SELECT 2011301_ON FROM STOCKS_CORN_LOCATION

The above is invalid. You must quote identifiers (generally using ") that contain spaces or begin with numbers. SQLite.swift automatically quotes expressions for you, so as long as you're using the type-safe interface, things should just work. If you're writing raw SQL, however, you'll need to be careful to quote things yourself wherever necessary.

from sqlite.swift.

Thank you Stephen. I appreciate it.

from sqlite.swift.