Query vs Select
Hello!
I'm reading through the docs and absolutely loving Drizzle!
One thing is still not clear to me is when to use query (https://orm.drizzle.team/docs/rqb) vs using select (https://orm.drizzle.team/docs/select). Are there performance implications, am I'm missing some differences in behavior, or it's just matter of preference?
Thanks a lot!!
Drizzle Queries - DrizzleORM
Drizzle ORM | %s
1 Reply
The biggest difference is that the select qb gives you access to almost all SQL syntax. The RQB has a more convinient API, but there are limitations in its flexibility
In general, performance with the RQB is quite good, but you do lose some control over how the query is built, so it is possible you might run into a situation where you want to build the query differently for performance reasons