Topics

Drizzle Team•4mo ago

How do I write a select with multiple subqueries?

Hey there, I'm trying to figure out how to write this postgres query using Drizzle:

select query_a.*, query_b.* from (select * from gpus) as query_a, (select * from products) as query_b;

select query_a.*, query_b.* from (select * from gpus) as query_a, (select * from products) as query_b;

2 Replies

Aaroned•4mo ago

@Alan I believe you are trying to do a cross join see https://github.com/drizzle-team/drizzle-orm/issues/1414 workaround is to use fullJoin(column, sql``true``)

Alan•4mo ago

Thanks!

Drizzle Team Join

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

8.2KMembers

View on Discord

Want results from more Discord servers?

Add your server

More Posts

relation 'users' does not existAfter I've successfully generated the migration file, I do bun run ./migrate.ts then I do npx drizz Getting data loss warning even though the change shouldn't be destructiveI am removing a `default` value from a column in 2 different tables both of which have all rows fill findFirst returns array instead of entity - using aws-data-api/pgHi folks -- I'm using `aws-data-api/pg`, running the latest version (`"drizzle-orm": "^0.30.7"`). I How do you deal with migrations? on postbuild?So, usually while developing locally, whenever I change my schema I run: ``` drizzle-kit generate:s ::character varying generating the end of varchar().default() in migrationsHello, guys! Maybe here is the right place for this, since I need help now. Just a quick question fo Spec for `onConflictDoUpdate` and nullsI observe the behaviour of the `set` clause is that a `null` value in the object to be set means tha