DT
Drizzle Team•10mo ago
nobody

How to use drizzle as a sql builder?

I want to use drizzle with planet scale. Sadly for mysql drizzle does not support the returning function (although databasejs returns e.g the insertedId after an insert statement). Anyways I would be more than happy to just use drizzle as a SQL builder so I can pass the SQL to planet scale through databasejs. Any ideas how to achieve that? Awesome library by far, keep up the great work!
2 Replies
bloberenober
bloberenober•10mo ago
I think Drizzle passes along the response from databasejs in that case, no? In any case, you can invoke .toSQL() on any query builder to get the SQL string and params list.
nobody
nobody•10mo ago
Thank you for your response! You are right I somehow missed that, both points are valid so maximum stuff to utilize
Want results from more Discord servers?
Add your server
More Posts
How to make sql.placeholder() type safeI have the following prepared statement: ``` export const listDeployments = db .select() .from(drizzle-kit tsconfig.json paths aliasNot a drizzle issue per-se, but running into an issue trying to make drizzle-kit work again by changhow to set default null to an int columnI want the parentId to have the default Null, how to do that ``` export const comments = mysqlTableCan't run drizzle-kit push:pg - error: column is in a primary keyHi, I get this error every time i run push:pg error: column "userId" is in a primary key at PBest way to get raw SQL for a SQLite insert statement (with inline parameters)?I tried doing this: ``` class InlineSQLiteSyncDialect extends SQLiteSyncDialect { public inlineParid on transaction conflicthey all, using mysql (planetscale). when a transaction conflict happens over an insert with the same