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;
A
Aaroned16d 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``)
A
Alan16d ago
Thanks!