SQliteError: near OR unrecognized token if columns starts with number about better-sqlite3 HOT 3 CLOSED

Please try to simplify your example as much as possible, and in a reproducible code snippet (we're all volunteers here!)

from better-sqlite3.

When this column would start with a number it results in a SqliteError: unrecognized token error.

Did you try to just quote your identifiers? Just to make you statement more expressive. If the column starts with number, is it guaranteed to not just consist of digits but also has some other characters in its name?

SELECT 
    COUNT(*) AS "count"
FROM 
    "JOB"
WHERE 
    ('61' IN (
        WITH "split"("option", "csv") AS (
            SELECT 
                '', 
                "<whatever column name>" ||',' 
            FROM 
                "JOB" j2 
            WHERE 
               j2."id" = "JOB".id 
            UNION ALL 
            SELECT 
                substr("csv", 0, instr("csv", ',')), 
                substr("csv", instr("csv", ',') + 1) 
            FROM 
                "split" 
            WHERE 
                "csv" != '' 
        ) 
        SELECT "option" FROM "split" WHERE "option" != ''
    )
) 

from better-sqlite3.

I am terribly sorry for wasting your time. There where 2 places in my code and I only changed one to include the column name in brackets. It was one of those days...

Very sorry and thanks a lot.

from better-sqlite3.