Query builder insert

What is the syntax for creating an insert query with the query builder ?

There are some examples on the website showcasing

select

select

, but i'm looking for

insert

insert

logic, which the query builder under

drizzle-orm/sqlite-core

drizzle-orm/sqlite-core

is missing ( seems to only have select on the

QueryBuilder

QueryBuilder

)

VilianOP•8/20/23, 2:39 PM

Any helpers in the chat

Piotrek•8/20/23, 2:41 PM

You cannot insert with the relational query builder

Piotrek•8/20/23, 2:41 PM

Yet

Piotrek•8/20/23, 2:42 PM

Unless you're talking about something else haha

VilianOP•8/20/23, 3:31 PM

My goal is to build insert queries

VilianOP•8/20/23, 3:31 PM

A single table only - So how do i go about using a query builder to create my sql strings (if that is even possible) ?

francis•8/20/23, 5:57 PM

you don't, use

francis•8/20/23, 5:57 PM

if you are inserting into a single table, why do you need the query builder anyway? its only purpose is to make joins easier