[BUG]: unexpected results using bun:sqlite about drizzle-orm

[colecrouter]

Can confirm it's not just Bun; I'm running into the same error with drizzle-orm/d1.

Edit:

Seems to be part of this file.

		this.logger.logQuery(this.query.sql, params);
-		const row = this.stmt.values(...params)[0];
+		const row = stmt.raw().get(...params) as unknown[];

As per docs:

.raw() Causes the prepared statement to return rows as arrays instead of objects. This is primarily used as a performance optimization when retrieving a very high number of rows. Column names can be recovered by using the .columns() method.

Not sure if this is it, but it sounds like what's being described.

Edit 2:
Looks like I found the source of my problem...

[Jarred-Sumner]

I suspect this is a bug in Bun. Can you file an issue in https://github.com/oven-sh/bun?

[rev4324]

I don't think this is a bug in Bun, since the problem is caused by joined table column names overriding the original table column names. JS objects can't have the same key twice so the behavior is the same in bun:sqlite and better-sqlite3 when used directly, without Drizzle - the columns are overridden.
Drizzle seems to mitigate this behavior in better-sqlite3 driver, but it doesn't do that in bun:sqlite one.