gwenn

Hello, I suggest you use the mattn's driver because it is widely used, SQLite C library is bundled and mattn is working on [this]( https://github.com/golang/go/issues/16673). I apologise for the lack...

Ok, I see that you are using the low-level API (not the standard database/sql API). And do the same for Postgresql with pgx! You are trying to retrieve some data...

I suggest that: * you use database/sql, I think you can already/temporary do it with my driver. You may need to deactivate the `ScanNumericalAsTime` flag with a custom `Register`. *...

For me, only the parser can choose to fallback _properly_. You can take look at [lemon (search "iFallback")](https://www.sqlite.org/cgi/src/artifact/105d0d9cbe5a25d2). Or you have to tweak your grammar like you suggest or [me](https://github.com/gwenn/sqlpop/blob/master/src/parser/lrsql.lalrpop#L126-L184)...

You just have to uncomment the lines [here](https://github.com/gwenn/sqlpop/blob/master/src/parser/lrsql.lalrpop#L126-L184) and you will have conflicts. And I suggest you keep using lalrpop because I don't want to waste your time. First, I...

I cannot reproduce: ```sh lemon-rs % cargo run --example sql_cmds bad-utf8.txt bad-utf8.txt CREATE TABLE LEC� (ABLEBL "0", "0" EATE TABL0BL REFERENCES a); CREATE TABLE LEC� (ASE0F�Y0); Err: unknown table option:...

For your information, - SQLite lexer does some look ahead to avoid conflicts [here](https://github.com/sqlite/sqlite/blob/fb77b3ed3f43c65cdca4ab56f2ca14d93ebe4152/src/tokenize.c#L246). - SQLite lemon parser has two specific features: [fallback](https://github.com/sqlite/sqlite/blob/fb77b3ed3f43c65cdca4ab56f2ca14d93ebe4152/src/parse.y#L246) and [wildcard](https://github.com/sqlite/sqlite/blob/fb77b3ed3f43c65cdca4ab56f2ca14d93ebe4152/src/parse.y#L267). So I guess you will...

As expected, it doesn't work: ```sql CREATE TABLE test (view TEXT); -- view fallbacks to ID instead of keyword ``` gives ``` code.cql:1:1: error: syntax error, unexpected VIEW Parse errors...

Not strictly related but we also have the issue for simple parameter: https://github.com/rusqlite/rusqlite/issues/164#issuecomment-1343250412 So even if `rusqlite` doesn't copy your parameter, `sqlite` will... Same with https://docs.rs/rusqlite/latest/rusqlite/types/enum.ValueRef.html#variant.Blob I am not sure...

See https://github.com/search?q=repo%3ACGamesPlay%2Fsqlite3_ext%20POINTER_TAG&type=code