Skip to content

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

@miaobuao

Description

@miaobuao

Report hasn't been filed before.

  • 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

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:

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

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions