Column name different in drizzle magic sql vs drizzle-orm

I use camelCase column names for the ORM and snake_case for the databse columns. Queries run through ORM returns camelCase columns but if I use drizzle.execute(sql``) it results in snake_case columns any workaround ?
3 Replies
rphlmr ⚡
rphlmr ⚡7mo ago
Executing a raw sql query will return its result as raw too. Any particular reason for doing this?
ak4zh
ak4zhOP7mo ago
Ohh ok, primarily because I was finding it easier to just do raw sql. Detail here: https://discord.com/channels/1043890932593987624/1056966312997429278/1262240863560667138 I use a lot of raw sql query in my other project and was not aware about this behaviour as my column names were in same case.

Did you find this page helpful?