Drizzle Team•13mo ago

How to select all from a table and get the the columns names returned as they are stored?

I want to do a select() query on my user table to get emailVerified: boolean('email_verified').default(false).notNull(), What is returning is emailVerified as opposed to email_verified. I want to return the latter, but also all the rest of the columns. I know I could do this:

    .select({
        id: user.id,
        email: user.email,
        email_verified: user.emailVerified
    })

    .select({
        id: user.id,
        email: user.email,
        email_verified: user.emailVerified
    })

But then if I add anything to the user table, I now have to add it to the select statement, where I might forget. Is there a way to say get ALL columns but return email_verified as actually email_verified? Or return all columns with their actual column names, as opposed to the Drizzle version?

4 Replies

Revan•13mo ago

Use https://orm.drizzle.team/docs/goodies#get-typed-table-columns

Goodies - DrizzleORM

Drizzle ORM | %s

Angelelz•13mo ago

The column names you get are the ones you defined in your table definition The keys you defined, in the database the string you passed to the will be the name for that column

Cory•13mo ago

yea I understand that. But for this particular instance I needed the original table name

Angelelz•13mo ago

The solution is getTableColumns() then

Gaming

Programming

How to select all from a table and get the the columns names returned as they are stored?