4 replies

Subqueries in relational queries

I'd like to use the query API but combine the

where

where

with a subquery. Meaning get all

posts

posts

where the

author

author

's name is "John".

I understand I can use the

select

select

syntax, but would prefer the ORM approach if possible:

await db.query.posts.findMany({
  // assuming `posts` has an ID field:
  where: (fields, ops) => ops.eq(fields.id, **SOME SORT OF SUBQUERY HERE**)
  with: {
    author: true,
  },
});

await db.query.posts.findMany({
  // assuming `posts` has an ID field:
  where: (fields, ops) => ops.eq(fields.id, **SOME SORT OF SUBQUERY HERE**)
  with: {
    author: true,
  },
});

I haven't seen any mention of it but seems doable with a subquery, any suggestions?

Drizzle Team•3y ago•

4 replies

jsee

Subqueries in relational queries

I'd like to use the query API but combine the

where

where

with a subquery. Meaning get all

posts

posts

where the

author

author

's name is "John".

I understand I can use the

select

select

syntax, but would prefer the ORM approach if possible:

await db.query.posts.findMany({
  // assuming `posts` has an ID field:
  where: (fields, ops) => ops.eq(fields.id, **SOME SORT OF SUBQUERY HERE**)
  with: {
    author: true,
  },
});

await db.query.posts.findMany({
  // assuming `posts` has an ID field:
  where: (fields, ops) => ops.eq(fields.id, **SOME SORT OF SUBQUERY HERE**)
  with: {
    author: true,
  },
});

I haven't seen any mention of it but seems doable with a subquery, any suggestions?

Subqueries in relational queries

Similar Threads

Subqueries in relational queries

Similar Threads

Similar Threads

Similar Threads