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 (https://github.com/drizzle-team/drizzle-orm/blob/main/drizzle-orm/src/pg-core/README.md#query-builder) 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?
GitHub
drizzle-orm/README.md 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
bloberenober
bloberenober14mo ago
For now yes, I didn't implement other query types for the query builder, but it's on our backlog. https://github.com/drizzle-team/drizzle-orm/issues/287
GitHub
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.