drizzle query (https://orm.drizzle.team/docs/rqb) does not work with bun:sqlite?

[huseeiin]

What version of Bun is running?

1.0.26+c75e768a6

What platform is your computer?

Linux 6.1.66-1-lts x86_64 unknown

What steps can reproduce the bug?

https://github.com/huseeiin/bun-drizzle-bug-reprod

What is the expected behavior?

No response

What do you see instead?

No response

Additional information

No response

[redraskal]

Likely related to drizzle-team/drizzle-orm#1885 & drizzle-team/drizzle-orm#1276, not yet merged

[AndriiSherman]

I'm going to fix it with one of the PRs, so it won't be a blocker for anyone, but I believe bun:sqlite should have the possibility to run .raw() with .get(), enabling it to return an array of 1 array instead of 1 object already mapped. All other SQLite drivers have this capability, so I think bun:sqlite should have it too. So we don't need to use values and then get the first element; we can just have one raw response for performance purposes

stmt.raw().get(...params)

cc @Jarred-Sumner