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
select()at the moment. Do I need to connect to a local DB if I want to generate
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