Topics

Drizzle Team•16mo ago

MySQL Standalone queryBuilder?

https://discord.com/channels/1043890932593987624/1052239146699210863/1085708651374837810 Where should I import MySQL Standalone queryBuilder? pg looks like:

import { queryBuilder as qb } from 'drizzle-orm/pg-core';

import { queryBuilder as qb } from 'drizzle-orm/pg-core';

but mysql:

import { queryBuilder as qb } from 'drizzle-orm/mysql-core';

import { queryBuilder as qb } from 'drizzle-orm/mysql-core';

doesn't work.

6 Replies

bloberenober•16mo ago

Oof, forgot to re-export it in MySQL. Currently you can import from drizzle-orm/mysql-core/query-builders. Will be fixed in the next release

ysm•16mo ago

Thanks! btw, Querybuilder doesn't support insert and delete statement? only support select?

bloberenober•16mo ago

Oh yeah. Missed that one. The query builder was initially built for views support, so I implemented select statements and forgot about the rest 😅 The rest will be implemented shortly

ysm•16mo ago

got it, Thanks again! Hi @bloberenober Is it possible to insert and delete in the latest version?

bloberenober•16mo ago

Not yet

ysm•16mo ago

Thanks

Drizzle Team Join

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

8.1KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

Applying migrations with drizzle-orm/pg-coreHow would I apply all the migrations that have not yet been applied? I couldn't find any information What is the type for an .orderBy() parameterInside of a function, i have a query more complicated than this, but something like: ```ts db.selec MySqlInsertValue<> vs typeof Table type mismatchI've got this line of code: ```ts await db.insert(table).values(props); ``` Where `props` is showi Argument of type 'SQL<unknown>' is not assignable to parameterI have the following: ```ts const projects = await db .select() .from(project) .where Stream selectHey! I'm doing a large select and I'm wondering how to stream the responses for MySql documented types for the return of `drizzle()` and the return of `mysqlTable()`my most pressing need is documented types: https://github.com/drizzle-team/drizzle-orm/issues/273 S .andWhere()I know that `.andWhere()` isn't a function, but I'm wondering if there's a way to start a query in o Example failed to run: `pg` does not provide an export named `Pool`I'm trying to run the example from the `README` file. I made a minial version, installed `pg`, `@typ how do you pass a query in a typesafe way?Let's say i want to paginate a query, so I'm going to pass a query such as this to a pagination func help with column builder typesAs I play around with learning drizzle, I wondered if I could generate a drizzle schema from a maste