Can I use queryBuilder for inserts?

My scenario is that I want to read some rows from a database (prod), and generate a SQL file that we'd use to populate a local DB. I wanted to use queryBuilder ( since I wouldn't need to connect to a DB to generate the SQL queries, but seems like queryBuilder only supports select() at the moment. Do I need to connect to a local DB if I want to generate insert() queries?
drizzle-orm/ at main · drizzle-team/drizzle-orm
TypeScript ORM for SQL. Contribute to drizzle-team/drizzle-orm development by creating an account on GitHub.
2 Replies
Andrii Sherman
Andrii Sherman14mo ago
@Dan Kochetov
bloberenober14mo ago
For now yes, I didn't implement other query types for the query builder, but it's on our backlog.
Add missing query types to query builder · Issue #287 · drizzle-tea...
Currently, standalone query builder only supports select queries, need to add the rest of them.