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, but i'm looking for insert logic, which the query builder under drizzle-orm/sqlite-core is missing ( seems to only have select on the QueryBuilder)4 Replies
Any helpers in the chat 😮
You cannot insert with the relational query builder
Yet
Unless you're talking about something else haha
My goal is to build insert queries
A single table only - So how do i go about using a query builder to create my sql strings (if that is even possible) ?
you don't, use
db.insert(schema).....
if you are inserting into a single table, why do you need the query builder anyway? its only purpose is to make joins easier