drizzle-team / drizzle-team/drizzle-orm

[BUG]: Casing used by SQLite Proxy is different from the config

Open
#4,898 2 comments 3 reactions 0 assignees View on GitHub
bug
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Report hasn't been filed before.

- [x] I have verified that the bug I'm about to report hasn't been filed before.

### What version of `drizzle-orm` are you using?

0.44.5

### What version of `drizzle-kit` are you using?

none

### Other packages

_No response_

### Describe the Bug

```ts
import { integer, sqliteTable, text } from "drizzle-orm/sqlite-core";
import {drizzle} from "drizzle-orm/sqlite-proxy"

export const usersTable = sqliteTable("users_table", {
id: integer().primaryKey({ autoIncrement: true }),
name: text().notNull(),
createdAt: integer({mode:"timestamp"})
});

const db = drizzle(async (sql, params, method)=>{
console.log({
sql, params, method
});
return {
rows:[]
}
}, {
casing: "snake_case",
schema: {
usersTable
}
})

await db.query.usersTable.findMany()
```

When executing the code, the expected output case style is snake_case.

The actual output is:

```js
{
sql: "select \"id\", \"name\", \"createdAt\" from \"users_table\" \"usersTable\"",
params: [],
method: "all",
}
```

where "createdAt" was not converted to "created_at".

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.