"... relational queries use lateral joins of subqueries [...] for now PlanetScale does not support them"--what does this mean exactly??

[205g0]

That Drizzle RQs use multiple queries for PS? If yes, are they then useless and I can write them myselves?

[Angelelz]

Relational queries use only one query, see this blogpost: https://medium.com/drizzle-stories/weve-built-typescript-orm-for-821-days-then-this-happened-71282a8b0206

[205g0]

I know but how is it for PlanetScale, also just one query?

[Angelelz]

They just use joins and a bunch of json aggregations. See here https://github.com/drizzle-team/drizzle-orm/blob/main/drizzle-orm/src/mysql-core/dialect.ts#L680

[205g0]

Then, I could use joins right from the start, would be one query too and is perf-wise the same, right?