Relation queries

By default, none related records are fetched for a query. With include, related records can be fetched into the result set together. The nested argument inside include, behaves like findMany's argument or findUnique's argument depending on whether the relation is single or many.

const { data: artists } = await teo.artist.findMany({
  include: {
    songs: {
      where: {
        name: { startsWith: 'Fairy' }
      }
    },
  }
})

Hide HTTP response

[
  {
    "id": 4,
    "name": "Angela Peterson",
    "age": 23,
    "songs": [
      {
        "id": 2,
        "name": "Fairy Tale",
        "published": true
      }
    ]
  },
  {
    "id": 5,
    "name": "Tony Justin",
    "age": 27,
    "songs": []
  }
]